While drafting the email, you have to use the …”, in this format at the start of your email, the salutation gets customized for each individual, with the First Name placeholder getting replaced with the actual names mentioned in the spreadsheet under that column. Step 8: Next, go to your Gmail Inbox and click on Compose to draft a new message. You can also go to Extensions > Mail Merge with Attachments > Add File Attachments > Insert Files from Google Drive to do the same. If there are multiple attachments, do remember to separate the links by comma separator. Step 7: To add file attachments to your mail, you can paste the links of the corresponding files from your Google Drive. You can also choose to fill in the details of the recipients in the Mail Merge spreadsheet manually. Step 6: Go to Extensions > Mail Merge with Attachments > Import Google Contacts to import any existing contact groups from Google Contacts into Mail Merge. You can even add on more variable field columns if you want. Step 5: A new sheet with the name Mail Merge gets created with important variable columns like First Name, Last Name, Email Address, File Attachments, etc.
Step 4: Go to Extensions > Mail Merge with Attachments > Create Merge Sheet.
After it’s successfully installed, you will notice the Mail Merge with Attachments add-on appear as an option under the Extensions menu in Google Spreadsheets. Step 3: Authorize permissions to it so that it gets installed on your system.
0 kommentar(er)
