Performing a Mail Merge with Google Spreadsheets & Gmail
Recently I had the need to email people that had filled out a form for me. Definitely a time intensive job if you are creating the emails individually by hand! Fortunately, you CAN do a mail merge from data on in a spreadsheet! Here's how: Create or open the spreadsheet that contains the data you want to merge into emails, giving each column a heading - make sure the recipients' email address is one of the fields! Go to the Tools Menu; select Script Gallery In the pop-up box, type Mail Merge and search - there are MANY mail merge scripts - the one I used the worked very well was called "Yet Another Mail Merge" Grant permission for it to access your Google Account After a bit, a new menu item will appear at the top next to Help called Mail Merge Ok - your spreadsheet is prepared, now you need to prepare your template email. Type the email up exactly as you want it, leaving the recipient blank . The key here - any place you want the email to pull informat...