To send personalized attachments to each recipient, upload your files to Google Drive and add their URLs in a column of your sheet. YAMM will get the files from your Drive and send them as attachments to your email.
Method 1: Automatically list all files URLs in your Google Sheet
1.1. Associate an ID to each recipient in your spreadsheet
In our example, we are sending personalized payslips to each employee, who will be attributed a unique registration number.
List the ID related to each recipient under a new column of your spreadsheet:
1.2. Choose a naming convention for your files title that includes the ID
Our naming convention for the payslip/file titles is: 'PAYSLIP-DEC2017-ID-REGISTRATION_ID', where 'REGISTRATION_ID' matches exactly the ID in our spreadsheet.
For example, Simon's ID is 000418, so his payslip will be named 'PAYSLIP-DEC2017-ID-000418'.
Make sure to include the same ID in the payslip title for each recipient / employee, and upload the files in a Drive folder:
You are now ready to use YAMM to send your personalized attachments.
1.3. Select the folder containing your attachments from YAMM UI
Go back to your Google Sheet, then click 'Add-ons > Yet Another Mail Merge > Start Mail Merge'.
Click '+ Alias, filters, personalized attachments...', then 'Import from Drive folder':
Select your Drive folder that contains your payslips:
Then choose the 'column to check for matches':
Click 'Import files'. Once done, YAMM will automatically list your payslips URLs next to the right recipients. You'll also notice that we have detected the right column that contains your attachments:
You can now send your mail merge with the personalized attachments to your contact list. Click 'Back' then 'Send xx emails'.
Method 2: List your files URLs one by one in your spreadsheet
2.1. Upload your files to Google Drive
2.2. Get the URL of each file, and paste the URL in a column named 'Attachment' in your sheet
3.3. When starting a new mail merge, activate the option to send personalized attachments
Click '+ Alias, filters, personalized attachments...':
Then, check the box 'Attach files in column xx to emails sent':
Each recipient will receive the right attachment based on the URL you have added on each row.
How to add multiple attachments for one recipient?
Simply put multiple links in the same cell of your sheet, separated by commas:
How many emails with attachments can I send each day?
|Plan||Account Type||Email quota with attachments|
|Free Plan||G Suite, Gmail||
100 / 24 hours if installed < 1 month ago
50 / 24 hours otherwise
|Paid Plan||G Suite||1,500 / 24 hours|
|Gmail||100 / 24 hours|