Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / June 2006

Tip: Looking for answers? Try searching our database.

Word Mailmerge Question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Amy - 08 Jun 2006 22:07 GMT
I have a mailmerge for a client letter that includes several hundred one page
letters in a single document.  What I need to happen is to print each letter
as a single print job to Adobe PDFwritter so it will create a .pdf file named
from the client's name merge field.  Any ideas?
I haven't found anything in the help file.  I have tried a couple of
downloads that splits pdf files.  

Thank you!

Amy
Doug Robbins - Word MVP - 09 Jun 2006 04:47 GMT
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.  It can also create
each letter as a separte .pdf file.

Signature

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

>I have a mailmerge for a client letter that includes several hundred one
>page
[quoted text clipped - 9 lines]
>
> Amy
Amy - 09 Jun 2006 13:56 GMT
Thank you so much!  This really helps!  I will test your macros today!

Amy

> See the "Individual Merge Letters" item on fellow MVP Graham Mayor's website
> at:
[quoted text clipped - 20 lines]
> >
> > Amy
Amy - 12 Jun 2006 17:32 GMT
I now have the macros in VBA.  Thank you again!  But now I am trying to Print
to PDF.  It is pulling the correct name for the save as but I can't figure
out how to have the save button to be scripted.  I would like this to be
fully automated.  Here is my code.  

Sub Test1()
' splitter Macro modified to save individual letters with
' information from data source. The filename data must be added to
' the top of the merge letter - see web article.

Selection.EndKey Unit:=wdStory
Letters = Selection.Information(wdActiveEndSectionNumber)
Selection.HomeKey Unit:=wdStory
Counter = 1
While Counter < Letters
Application.ScreenUpdating = False
With Selection

  .HomeKey Unit:=wdStory
  .EndKey Unit:=wdLine, Extend:=wdExtend
  .MoveLeft Unit:=wdCharacter, Count:=1, Extend:=wdExtend

End With
sName = Selection
Docname = "F:\ia\Monthly\Merge\" & sName & ".doc"
ActiveDocument.Sections.First.Range.Cut
Documents.Add
With Selection
  .Paste
  .HomeKey Unit:=wdStory
  .MoveDown Unit:=wdLine, Count:=1, Extend:=wdExtend
  .Delete
End With
ActiveDocument.SaveAs FileName:=Docname, _
FileFormat:=wdFormatDocument
ActiveWindow.Close
Counter = Counter + 1
Application.ScreenUpdating = True
ActivePrinter = "Acrobat PDFWriter"
   Application.PrintOut FileName:=Docname, Range:=wdPrintAllDocument,
Item:= _
       wdPrintDocumentContent, Copies:=1, Pages:="",
PageType:=wdPrintAllPages, _
       ManualDuplexPrint:=False, Collate:=True, Background:=True,
PrintToFile:= _
       False, PrintZoomColumn:=0, PrintZoomRow:=0, PrintZoomPaperWidth:=0, _
       PrintZoomPaperHeight:=0
Wend

End Sub

> Thank you so much!  This really helps!  I will test your macros today!
>
[quoted text clipped - 24 lines]
> > >
> > > Amy
Doug Robbins - Word MVP - 12 Jun 2006 19:06 GMT
What version of Word are you using?  If it is XP or later, the addin that I
have created that you can download from Graham's site has all of the
necessary code in it.

Signature

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

>I now have the macros in VBA.  Thank you again!  But now I am trying to
>Print
[quoted text clipped - 84 lines]
>> > >
>> > > Amy
Amy - 12 Jun 2006 20:04 GMT
I am using Word 2002.  Will the add-ins work for this version?  

> What version of Word are you using?  If it is XP or later, the addin that I
> have created that you can download from Graham's site has all of the
[quoted text clipped - 88 lines]
> >> > >
> >> > > Amy
Peter Jamieson - 12 Jun 2006 21:12 GMT
Word 2002 is another name for Word XP.

Peter Jamieson
>I am using Word 2002.  Will the add-ins work for this version?
>
[quoted text clipped - 97 lines]
>> >> > >
>> >> > > Amy
 
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.