If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
SEPERATE DOCUMENTS FOR MAIL MERGE
I CREATED A MAIL MERGE, AND I WANT TO FIND OUT IF THERE
IS A WAY TO SEPERATE THE DOCUMENTS RATHER THAN ONE HUGE DOCUMENT? I AM NOT FAMILIAR WITH MACROS, IS THERE ANY OTHER WAY TO DO THIS? |
#2
|
|||
|
|||
Please don't SHOUT!
Sub splitter() ' splitter Macro ' Macro created by Doug Robbins to save each letter created by a mailmerge as a separate file. Dim Letters As Integer, Counter As Integer, Source as Document, Target as Document, Letter as Range Set Source = ActiveDocument Letters = Source.Sections.Count For i = 1 to Letters Set Letter = Source.Sections(i).Range Letter.End=Letter.End-1 Set Target = Documents.Add Target.Range=Letter Target.SaveAs FileName:="Letter" & i, FileFormat:= _ wdFormatDocument, LockComments:=False, Password:="", AddToRecentFiles:= _ True, WritePassword:="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts:= _ False, SaveNativePictureFormat:=False, SaveFormsData:=False, _ SaveAsAOCELetter:=False Target.Close Next i End Sub If you don't know what to do with it, see the article "What do I do with macros sent to me by other newsgroup readers to help me out?" at: http://word.mvps.org/FAQs/MacrosVBA/CreateAMacro.htm -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "MARINA MORENO" wrote in message ... I CREATED A MAIL MERGE, AND I WANT TO FIND OUT IF THERE IS A WAY TO SEPERATE THE DOCUMENTS RATHER THAN ONE HUGE DOCUMENT? I AM NOT FAMILIAR WITH MACROS, IS THERE ANY OTHER WAY TO DO THIS? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple merge Documents | Paul | Mailmerge | 3 | August 25th, 2004 10:33 AM |
Merge all the documents | sarath | Formatting Long Documents | 1 | June 17th, 2004 02:43 AM |
Merge to Fax with SBS/Exchange? | Tom | Mailmerge | 3 | May 18th, 2004 11:22 PM |
Break up Mail Merge into separate documents | Mailmerge | 6 | May 15th, 2004 06:24 AM |