Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
split a mail merge into seprate files
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
split a mail merge into seprate files
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" wrote in message ... 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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
split a mail merge into seprate files
Thanks Doug
"Doug Robbins - Word MVP" wrote: 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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Split a mail merge document into individual documents | Mailmerge | |||
NO CODE - mail merge to Outlook with attachment with CC | Mailmerge | |||
mail merge with word 2003 | New Users | |||
Data Files Not "Attached" to Mail Merge Main Document | Mailmerge | |||
Mail Merge - Parameter prompts twice... | Mailmerge |