Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Mar 2003
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Saving a Merged Document to Individual Files (2000/2003/XP)

    I need to be able to take a mail merge document and save each letter (section) as a new document in PDF format to a dictory on the users desktop. Each file needs to be saved using the following naming convention, Month - Year - Account Name e.g. July 2004 Haitch Design. Note the Account Name is the first field in the section.

    Not sure how to even start the above and would appreciate help

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Saving a Merged Document to Individual Files (2000/2003/XP)

    See the replies to <post#=345003>post 345003</post#> for various methods to split a merged file into separate files. Perhaps others will have suggestions for the PDF part; it might be useful to know what software you are using to create PDF - Adobe Acrobat, pdf995, ...

  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Saving a Merged Document to Individual Files (2000/2003/XP)

    Here's a tip that I picked up somewhere (possible a Word NG) that you could incorporate into the macro referred to in the link from HansV's <post#=345217>post 345217</post#>. It's meant for use where you use a PDF convertor that works by printing using a .PDF "printer driver":

    Dim i As Integer
    For i = 1 To ActiveDocument.BuiltInDocumentProperties(wdPropert yPages)
    ActiveDocument.PrintOut Range:=wdPrintFromTo, From:="i", To:="i"
    Next I

    to automate the printing of each page to a separate file, but you would still need a means of supplying the filename for each page.


    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •