Personalized PDF File Attachments
How to add personalized PDF file attachments to my emails?
This article describes how to create personalized PDF file attachments for each data row, enabling both the file attachment and the email body to be personalized to each email recipient.
From Google Docs
Step 1: Click Show Email Settings
In Google Docs, click on Show Email Settings in the Mail Merge sidebar.
This opens the email settings menu, which contains options to use your document template as a gmail PDF attachment with mail merge.
Step 2: Select Send Doc as PDF Attachment check box
Select Send Doc as PDF Attachment check box.
This enables you to mail merge a PDF email attachment, rather than using your document template as the email body.
Step 3: Click Write Email Body
Click on Write Email Body.
This opens the Email Body Template dialog box where you can write the email body to send with your mail merge PDF attachments.
Step 4: Create email body template
Create your email body template.
This is the email body that is sent along with your personalized mail merge PDF attachments.
Step 5: Insert and format text or *|merge fields|*
Insert *|merge fields|* into your email body template by clicking in the desired location within the template, selecting a field from the Merge Field drop-down menu, and clicking on Add.
Repeat this step for all required *|merge fields|*.
*|Merge fields|* are the column names found in the first row of data in your Google Sheet. You can change the (font, color, size, etc.) of the *|merge fields|* in your email body template in the same way you would regular text. You can further customize your email body template by adding images and hyperlinks.
Step 6: Click Save
Click on Save to apply the changes.
Step 7: Click Set Filename
Click on Set Filename to open the Attachment's Filename dialog box, where you can select a filename for your mail merge PDF attachment for gmail.
Step 8: Select filename option
Select from the drop-down menu one of the options below:
Same for all emails sets a static filename, which is the same for all PDF email attachments from mail merge.
Merge from column sets a *|merge field|* filename, which enables a different filename to be set for each personalized PDF attachment from mail merge.
Step 9: Decide filename
Decide a filename for your file attachment:
Type a filename for the same for all emails option.
Select a *|merge field|* from the drop-down menu for the merge from column option.
The option you select determines the filename used when the mail merge PDF attachments are sent.
Step 10: Click Save
Click on Save to apply the changes to save the filename settings for your personalized mail merge PDF attachments.
Static Filename
Merge Field Filename
Step 11: Mail merge emails
Select Emails from the Merge To list, and then click on Merge to start the mail merge process.
From Google Slides
To mail merge with personalized PDF attachments from Google Slides, refer to this article.