Mail Merge with an Excel document

[SteveS]

I am using Office 2002. I am using the Mail Merge Wizard in MS Word
(Tools/Letters & Mailing/Mail Merge Wizard) to create a bunch of letters.
I have all the text data in an Excel worksheet. It is very easy to use Word
to merge the two together. My problem is that some of cells have multiple
line spaces between paragraphs. The word document does not pick up the line
spaces. An example may be clearer:

cell a2 = This is paragraph1 <alt><enter><alt><enter><alt><enter>This is
paragraph2 after two blank lines.

The cell looks like this in Excel:

This is paragraph 1


This is paragraph 2 after two blank lines.


For some reason in Word, using a Mail Merge, it looks like this:

This is paragraph1
This is paragraph2 after two blank lines.


Does anyone know what to get the extra line breaks in Word?

Thank you!

SteveS
(e-mail address removed)

 

[Guest]

Do you see an option that says 'ignore blank line, or don't print blank lines' before you click Merge?

----- SteveS wrote: -----

I am using Office 2002. I am using the Mail Merge Wizard in MS Word
(Tools/Letters & Mailing/Mail Merge Wizard) to create a bunch of letters.
I have all the text data in an Excel worksheet. It is very easy to use Word
to merge the two together. My problem is that some of cells have multiple
line spaces between paragraphs. The word document does not pick up the line
spaces. An example may be clearer:

cell a2 = This is paragraph1 <alt><enter><alt><enter><alt><enter>This is
paragraph2 after two blank lines.

The cell looks like this in Excel:

This is paragraph 1


This is paragraph 2 after two blank lines.


For some reason in Word, using a Mail Merge, it looks like this:

This is paragraph1
This is paragraph2 after two blank lines.


Does anyone know what to get the extra line breaks in Word?

Thank you!

SteveS
(e-mail address removed)

 

[Francis Dion]

Hi,

Excel stores the newlines as ascii code 10, or CHR(10).

Word expects newlines to be composed of ascii codes 13 and 10, or
CHR(13) & CHR(10).

I don't know about Word Mail Merge, but this is easily fixed if you
use XpertDoc to execute your merges. All you need is to have your
template modify the field on the fly using the replace function:
replace(Sheet1.Fields("Notes").Value, chr(10), chr(13) & chr(10))

You can check out XpertDoc at www.xpertdoc.com

Regards,