Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 6
Default Excel data reformatted in Word mailmerge

G'Day,

I'm using an Excel worksheet as a data source for merging into a Word
document. Some cells are "formatted" to contain blank lines (entered
using Alt-Enter) to act as paragraph separators. During the merge these

blank lines appear to be removed. E.g.


First pice of text.


Second piece of text.


Third piece of text.


becomes, after the merge,


First pice of text.
Second piece of text.
Third piece of text.


I've tried formatting the Word document using space after paragraphs
but this adds extra space when the source data is of the form:


First piece of text


First list item
Second list item
Third list item


This becomes:


First piece of text


First list item


Second list item


Third list item


Any suggestions/thoughts on ways to preserve the Excel-based formatting

of the text would be appreciated.


Thanks in advance,


Clive

  #2   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 459
Default Excel data reformatted in Word mailmerge

ha scritto nel messaggio
ups.com...
G'Day,

I'm using an Excel worksheet as a data source for merging into a Word
document. Some cells are "formatted" to contain blank lines (entered
using Alt-Enter) to act as paragraph separators. During the merge these

blank lines appear to be removed. E.g.


First pice of text.


Second piece of text.


Third piece of text.


becomes, after the merge,


First pice of text.
Second piece of text.
Third piece of text.


I've tried formatting the Word document using space after paragraphs
but this adds extra space when the source data is of the form:


First piece of text


First list item
Second list item
Third list item


This becomes:


First piece of text


First list item


Second list item


Third list item


Any suggestions/thoughts on ways to preserve the Excel-based formatting

of the text would be appreciated.


Thanks in advance,


Clive


Hi Clive,

Maybe this could be useful for you:

http://office.microsoft.com/en-ca/as...164951033.aspx

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy


  #3   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 6
Default Excel data reformatted in Word mailmerge

G'Day Franz,

Thanks for your input. Alas, I don't think the link helped.

I opened the spreadsheet using Access and noticed some fields were
identified by Access as text, others were memo. The memo fields allowed
their text to pass through the mail merge complete; the text fields
were truncated.

Solution: I entered a dummy first record, making sure each field in the
new first record contained text with more than 255 characters. Opeing
the new spreadsheet in Access, all fields were memo. The mailmerge
worked "perfectly" with no truncation of any fields.

Regards,

Clive

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help getting data from Word to Excel JM Excel Discussion (Misc queries) 4 January 4th 06 03:13 AM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
Print labels by using Excel data in a Word mail into word Zoey Excel Discussion (Misc queries) 1 November 1st 05 09:08 PM
Transferring Excel Data to Word Document maacmaac Excel Discussion (Misc queries) 0 October 6th 05 05:23 PM
Using Excel 2000 as Data source for Word 2000 document Malcolm Agingwell Excel Discussion (Misc queries) 2 June 21st 05 09:28 AM


All times are GMT +1. The time now is 10:08 PM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"