20180925 mj testing Mail Merge with YAMM (Yet another mail merge) PRICING Personal plan $24/year (1500 emails/day) Free version (50 emails/day) 1. Install YAMM on your Google account From your G Suite account Click the "Google apps" icon and click Sheets Start a new spreadsheet (click Blank) Find the "Add-ons" menu across the top, and click "Get Add-ons" Type 'Yet Another Mail Merge' in the search bar Click on the button '+ FREE' to install the add-on Accept the authorizations Messages: *) Start a new merge anytime & check other options by going to Add-ons > Yet Another Mail Merge *) ! There are no recipients in your sheet *) This add-on uses the data on each row to send personalized emails. Add at least one row of data below y our headers clicked "Add emails myself" follow the prompt https://support.yet-another-mail-merge.com/hc/en-us/articles/211752825 *) Add recipients to your sheet and then go back to menu Add-ons > Yet Another Mail Merge > Start Mail Merge [ spreadsheet ] Email Address First name Description Merge status mira@seas.ucla.edu mira test mail merge with my account gmiraj@gmail.com gmiraj test mail merge with my gmail account testgrad@seas.ucla.edu testgrad test mail merge with my testgrad account *) ! This add-on merges your Sheet data with a mail template created as a draft in Gmail. Please create a draft in Gmail and try again. ;; click "Create simple draft" in Gmail click on 'Compose' and write the email -- Recipients: (leave it empty) Subject: Testing YAMM Dear {{First name}}, I'm testing YAMM so this is my test email to you. {{Description}} Best regards, Mira Jung SEASnet -- click X to save and close the draft *) back to the Sheet, Add-ons, Yet Another Mail Merge> Start Mail Merge Sender Name Email Template: (select your email draft) [check] Track emails opened, clicked or bounced click "Receive a test email" *) Check your inbox to view the test email *) go back to the Sheet, and send the email to the recipients ! Your emails might be flagged as spam due to SPF record issues on domain seas.ucla.edu