split a mail merge into seprate files

[ram]

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

 

[Doug Robbins - Word MVP]

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.

--
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

 

[ram]

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
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.

--
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