Results 1 to 3 of 3
  1. #1
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    653
    Thanks
    93
    Thanked 14 Times in 13 Posts
    I am doing a mail merge with Word 2007, the data source is an Excel file. I need to save all the letters as individual Word files. By default it seems to put all the letters as separate pages in one file. Is there a way to tell it to separate each letter into its own file? I see that I can tell it to just merge the current record, but that method seems tedious.

    Also,is there a way to have the titles of the saved Word files be the name of the person the letter is going to, which is found in the Name column in the Excel file?

    Thanks

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

    You can't change Word's mailmerge output behaviour, though the Adobe Acrobat Add-in gives you the ability to save each letter as a separate file (I think they're just numbered files, though).

    There are also macro-based solutions for splitting the Word file into separate documents. See, for example: http://www.gmayor.com/individual_merge_letters.htm
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    5 Star Lounger Vincenzo's Avatar
    Join Date
    Mar 2004
    Posts
    653
    Thanks
    93
    Thanked 14 Times in 13 Posts
    OK thanks, macropod. I'll take a look at that.

Posting Permissions

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