Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    New Jersey
    Posts
    103
    Thanks
    6
    Thanked 0 Times in 0 Posts

    How do I mail merge from Excel file and create individual PDF files

    Hi,

    I have an excel file with multiple columns with data for each employee. I have about 400 employees on the file. I have a 19 page word document that I am merging with the excel file. What I need to do is create individual 19 page documents for each employee and convert into PDF. The excel file contains an employee id which is the unique key. Can you tell me how to create the individual PDF documents?

    Thank you in advance!
    Corden
    Last edited by Corden; 2015-10-07 at 19:40.

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts
    See Send Mailmerge Output to Individual Files in the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum:
    http://windowssecrets.com/forums/sho...ips-amp-Tricks
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. The Following User Says Thank You to macropod For This Useful Post:

    Corden (2015-10-10)

  4. #3
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    New Jersey
    Posts
    103
    Thanks
    6
    Thanked 0 Times in 0 Posts
    That is awesome Paul! Thanks so much. It worked and I am so thankful! You saved me.



    Corden

  5. #4
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    New Jersey
    Posts
    103
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Hi Paul,

    One more question on this. Is there a way to add code that once it creates the PDF it sends it to Outlook and sends it? The file contains email address fieldname is called Email.

    Thanks so much again.
    Nancy

  6. #5
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts
    See, for example: http://word.mvps.org/FAQs/MailMerge/...ttachments.htm
    As you can see, to fully integrate such a process with what I've already provided, you'd need quite a lot more code. There are, however, some free addins available for doing that kind of thing. See, for example, the Many-to-One Mail Merge add-ins, from:
    Graham Mayor at http://www.gmayor.com/ManyToOne.htm
    Doug Robbins at http://bit.ly/1hduSCB
    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
  •