Question on how to do a multiple mail merge with Word

[Jody Krumm]

Can you create a letter in MS Word. Then create a mail
merge for title, first, last name, address, city, state,
and zip code. Then enter in the data for the merge.

Then create a MS Excel worksheet with data like dollar
amounts for car maintenance, with columns like Tires,
Windshield Wipers, and belts.

Can you then create another mail merge to draw the dollar
amounts into the MS Word doc?

When I try it, it deletes the data for the first mail
merge that I created.

HELP??

 

[Cindy M -WordMVP-]

Hi Jody,

If I interpret what you really want for the end result,
would it be something like an invoice? Word doesn't do this
easily, but it can be done. See under "Special Merges" in
the mail merge FAQ on my website. There are three basic
approaches one can use, and you'll find links to sample
files.

If the "list" information can appear in a table format, I
recommend the Database field method.

Can you create a letter in MS Word. Then create a mail
merge for title, first, last name, address, city, state,
and zip code. Then enter in the data for the merge.

Then create a MS Excel worksheet with data like dollar
amounts for car maintenance, with columns like Tires,
Windshield Wipers, and belts.

Can you then create another mail merge to draw the dollar
amounts into the MS Word doc?

When I try it, it deletes the data for the first mail
merge that I created.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail