Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need help getting data from Word to Excel | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Print labels by using Excel data in a Word mail into word | Excel Discussion (Misc queries) | |||
Transferring Excel Data to Word Document | Excel Discussion (Misc queries) | |||
Using Excel 2000 as Data source for Word 2000 document | Excel Discussion (Misc queries) |