split a mail merge into seprate files

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ram - 02 May 2006 22:08 GMT

I have a 2000 row Excel data source file I am merging into a letter.

Is there way to merge the first 1000 letters and save to a file labled Jan.
Then merge the next 1000 letters and save to a file labled Feb.

Is there a way to have the date field change between the two files or would
itbe easier to accomplish this in the data source file.

Thanks in advance for any help

Reply to this Message

Doug Robbins - Word MVP - 03 May 2006 04:59 GMT

For that task, I would just manually execute the merge of the first 1000
records and save it as Jan and then merge the second 1000 and save it as
Feb. I am not sure what you mean by the date field, but if it is a date
that appears in the mail merge main document, just change it between the
merges.

For more sophisticated methods (that are not applicable to your situation),
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 a 2000 row Excel data source file I am merging into a letter.
>
[quoted text clipped - 7 lines]
>
> Thanks in advance for any help

Reply to this Message

ram - 03 May 2006 13:40 GMT

Thanks Doug

> For that task, I would just manually execute the merge of the first 1000
> records and save it as Jan and then merge the second 1000 and save it as
[quoted text clipped - 24 lines]
> >
> > Thanks in advance for any help

Reply to this Message

Rate this thread: