Mass mailing

[EM]

Hi U there,

I'm in trouble...
Is there a solution, preferably easy one to do all this))

I have customers in excel sheet, then a word document (with a table on it),
this one word should be filled and print 6 times /customer. The customers
are everytime different, the source sheet always the same....

Any help or suggestions?

em

 

[Jim Vierra]

Mailmerge from spreadsheet assuming spreadsheet also has customer email
addresses.

 

[EM]

The letters aren't going to the customers... But I need 6*1 word document
/customer to be printed and sent to the public authorities... Mail merge was
the only solution I came up, but doesn't work.
But thanks for helping, and sorry I was unclear


-e-

 

[Jim Vierra]

No - mailmerge to a single document and print it. You can script it in 20
or 30 lines - maybe less.

 

[Cindy M -WordMVP-]

Hi Em,

I have customers in excel sheet, then a word document (with a table on it),
this one word should be filled and print 6 times /customer. The customers
are everytime different, the source sheet always the same....

Your problem description is rather terse, so it's not 100% clear what it is
you have, and what you want to get out of it.

If what you want is basically the result of a mail merge, but you want six
pages instead of one / record, then

Insert a page break at the end of the merge main document page
Copy the content (including the page break) five times.
Delete the last page break
Set the type of mail merge to CATALOG (Directory, if Word 2002 or later)

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

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