Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
Locked
0

Mail Merge with Adobe using an Excel File, then email individual PDFs

New Here ,
Oct 30, 2020 Oct 30, 2020

Hello:

I am trying to produce over 1,000 Certificates of Completion using the Mail Merge Option.  I have an PDF Document that is a Certificate of Completion Template.  I have the list of graduates in an Excel File with their emails included.  I have letter to include into the body of the email to each graduate their Certificate of Completion.

 

How can I make this work by creating the PDF using the list of names from the Excel and email them (each individual) their PDF Certificate with a letter in the body of the email?

 

14.8K
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Oct 30, 2020 Oct 30, 2020

>using the Mail Merge Option

 

Please post the exact name of the Adobe program you use so a Moderator may move this message to that forum

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Oct 30, 2020 Oct 30, 2020

Sending e-mail "Mail Merge" is a question for Microsoft Outlook or whatever e-mail client you use.

 

Nancy O'Shea— Product User, Community Expert & Moderator
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Feb 18, 2021 Feb 18, 2021

I've done a fair bit of research on this, and here's what I've figured out. There are two options to do this: number one, use a plugin like AutoMailMerge from Evermap, costs $150. Or, use a website like pdfmailmerger.com, costs a bit less.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 18, 2021 Feb 18, 2021
LATEST

I'm surprised you didn't find this tool I've created that does exactly that, and costs less than both of those options, especially for the long run, and doesn't require you to upload your files to an unknown third-party's website: https://www.try67.com/tool/acrobat-mail-merge-and-email-pdf-files

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines