MS Word Mail Merge Wizard and Excel

S

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top