Go to the Mail Merge menu again and choose “Configure Mail Merge” – the status column will change to “MAIL SENT” for all email messages that were successfully delivered.Mail Merge will automatically insert the actual file into the email.
#Mac mail gmail multiple drafts pdf#
If you would like to add file attachment to your email messages – say a PDF file or a Word document – just upload the file to Google Drive and then select Insert File Attachments to insert that link of the file into the Mail merge sheet.Alternatively, you can compose an email template in rich text using the HTML Mail tool and then copy-paste the generated HTML code into the message body field of the Google Sheet.
![mac mail gmail multiple drafts mac mail gmail multiple drafts](https://cdn.osxdaily.com/wp-content/uploads/2016/03/delete-all-email-from-mac-mail-app-osx.jpg)
![mac mail gmail multiple drafts mac mail gmail multiple drafts](https://storage.googleapis.com/support-forums-api/attachment/message-33926479-2804208118099891603.png)
Go to the Add-ons menu in the sheet, select Mail Merge with Attachments and then select the Create Merge Template menu. This will create a new Google Spreadsheet.Please watch the Mail merge tutorial for instructions. Install the Mail Merge for Gmail add-on.Here’s how you can do mail merge with Gmail: