Mailmerge - to save to multipule documents

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Miss Marple - 08 Sep 2006 16:58 GMT

I have an excel document with x number of lines for x number of records (each
record is identified by a unique reference) - is there some way I can
automatically save a merged document (ie letter) for each record (which will
be one or more pages) rather than keep filtering and saving in mail merge?

I have 150 records

Many thanks

Reply to this Message

Doug Robbins - Word MVP - 08 Sep 2006 19:02 GMT

See the "Individual Merge Letters" item on fellow MVP Graham Mayor's website
at:

http://www.gmayor.com/individual_merge_letters.htm

If you are using Word XP or later, the "Add-in to Merge Letters to Separate
Files" that I have written and that can be downloaded from that site will
allow you to create each letter as a separate file with a filename taken
from a field in the data source with a minimum of fuss.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have an excel document with x number of lines for x number of records
>(each
[quoted text clipped - 6 lines]
>
> Many thanks

Reply to this Message