A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

SEPERATE DOCUMENTS FOR MAIL MERGE



 
 
Thread Tools Display Modes
  #1  
Old September 3rd, 2004, 10:08 PM
MARINA MORENO
external usenet poster
 
Posts: n/a
Default 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  
Old September 4th, 2004, 12:08 AM
Doug Robbins
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 11:44 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.