Mail Merge

Whilst there are several ways to carry out a mail merge within Google Workspace we reccomend using the Autocrat Extenson. This provices a nice step by step method of getting your mailmerges setup, customised and sent with minimal hassle. And offers a similar way of working to the Microsoft Office Suite. 

Please follow the below instructions to carry out a successful mail merge.

Setup your google sheets spreadsheet properly - 

make sure you have all of the fields you require (first name , surname etc,) and title them accordingly.

Each field  name should be unique

Make sure there are no blank rows in your data.

 

Make sure your document templateis formatted correctly - 

Merge tags in google docs use << >> rather than { } so make sure your documents merge tags are entered properly (ideally with the matching field name in them so autocrat can automattically match the spreadsheet field to the merge tag.) 

A properly formatted example would be <<first name>> 


Start the merge

Open your spreadsheet containing the mailmerge data

​Click Extensions

Click Autocrat


Click the "NEW JOB" button to start the merge wizard

Once done, click run on the job you created and let the merge do its thing. Or if you want a preview before its sent off click the little eye icon on the job and click preview for first mergeable row.