 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / February 2006Merge to seperate documents
Hi, Is it possible in MSword to merge to seperate documents, because when i click merge to new document it blocks them all in one document and then i have to seperate them out manually which is very time consuming with over 100 records, Thanks You cannot output to individual files, but you can split the merge with a macro which achieves the same ends: http://www.gmayor.com/individual_merge_letters.htm  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Hi, Is it possible in MSword to merge to seperate documents, because > when i click merge to new document it blocks them all in one document > and then i have to seperate them out manually which is very time > consuming with over 100 records, > Thanks I found your website when searching through google looking for the answer and tryed you macro but couldnt get it to work, can you give me a walk through of how to make this work, and also more information on what the outcome should be? Thanks for you help Try this one: Sub splitter() ' splitter Macro ' Macro created by Doug Robbins to save each letter created by a mailmerge as a separate file. Dim i As Long, Source as Document, Target as Document, Letter as Range Set Source = ActiveDocument For i = 1 to Source.Sections.Count Set Letter = Source.Sections(i).Range Letter.End=Letter.End-1 Set Target = Documents.Add Target.Range=Letter Target.SaveAs FileName:="Letter" & i Target.Close Next i End Sub SignatureHope 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 found your website when searching through google looking for the answer >and [quoted text clipped - 5 lines] > > Thanks for you help I am curious to discover what problems you had - and given that the posted code is based on one of Doug's macros, the alternative he has posted may be similarly problematical. For installing macros from listings, see my other page http://www.gmayor.com/installing_macro.htm Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I found your website when searching through google looking for the > answer and tryed you macro but couldnt get it to work, can you give > me a walk through of how to make this work, and also more information > on what the outcome should be? > > Thanks for you help I've got Dougs macro to work but it doesnt keep all my table formating as all the information in the mail merge is put into different areas of the table, the output of the macro is just a list of information unformated, I dont know if either you or Doug can help me, Thanks for your assistance > I am curious to discover what problems you had - and given that the posted > code is based on one of Doug's macros, the alternative he has posted may be [quoted text clipped - 7 lines] > > > > Thanks for you help This is beginning to sound like a non-standard form letter merge document. A form letter merge (which the macro is intended to split) separates the individual merge 'documents' by section breaks and the macro splits the file along those section breaks. You seem to be doing something quite different. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I've got Dougs macro to work but it doesnt keep all my table > formating as all the information in the mail merge is put into [quoted text clipped - 24 lines] >>> >>> Thanks for you help This is what i have done, I have created an Access Database for the user to enter data using a form, then the information get merged into a word document, the word document has a number of tables and images, when it merges it is all in one document and i would like it split out into seperate files/documents, when i used Doug's macro it only split the information from 1 record into a new document, and it only had the merge text, Hope this helps, > This is beginning to sound like a non-standard form letter merge document. A > form letter merge (which the macro is intended to split) separates the [quoted text clipped - 29 lines] > >>> > >>> Thanks for you help Did you merge to a new document and then run the macro on that merged new document? Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > This is what i have done, > [quoted text clipped - 50 lines] >>>>> >>>>> Thanks for you help It works!!! thank you for your help, Kind Regards Matt Bryant > Did you merge to a new document and then run the macro on that merged new > document? [quoted text clipped - 53 lines] > >>>>> > >>>>> Thanks for you help That's a relief :) Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > It works!!! thank you for your help, > [quoted text clipped - 67 lines] >>>>>>> >>>>>>> Thanks for you help I was looking for a code that would enable me to split multiple pages i a merged document to separate documents for example I have a templat with 3 pages - when merged using a normal mail-merge for 5 people, i creates a merged document with 15 pages (i.e. 5 people with 3 page each). Now when I use a macro "Splitter" from the Topic "Individua Merge Letters", it splits the documents one page at a time creating 1 documents in this caserather than 5 documents. Any suggestions pls. Kind regards, Mano Use Sub splitter() ' Macro created by Doug Robbins to save each letter created by a mailmerge as a separate file. Dim i As Long, Source as Document, Target as Document, Letter as Range Set Source = ActiveDocument For i = 1 to Source.Sections.Count Set Letter = Source.Sections(i).Range Letter.End=Letter.End-1 Set Target = Documents.Add Target.Range=Letter Target.SaveAs FileName:="Letter" & i Target.Close Next i End Sub SignatureHope 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 was looking for a code that would enable me to split multiple pages in > a merged document to separate documents for example I have a template [quoted text clipped - 8 lines] > Kind regards, > Manoj |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.