1. In Google Sheets have have a ready list of users you want to email to. The sheet should have first names, last names, and email addresses. You can add other fields for use in the body of the email.

2. Here is what it should look like

3. Go to your GMail account.

4. Click "Compose"

5. On the To: line click the people icon on the far right (contact the Tech Office if this is missing).

6. Check Mail Merge.

7. Click Add from a spreadsheet and then select the spreadsheet you will be using.

8. Click here.

9. Here you will to seelct which columns contain the email addresses, first names, and last names. Each column name is preceded by an @.

10.

11. If you haven't already finished your email to be sent, or you want to add to it, click Back to draft.

12. While editing, if you want to merge other fields in the email subject or body simply type an @ and a list of available fields will display. Click the one you want and it will merge into the email.

13. After you have finished editing the email and you believe you are ready to proceed click the Continue button.

14. Click "Continue"

15. You can select Send preview or Send All. Send preview will send you an email to your inbox so you can check to make sure it looks acceptable. Click Send All when you are ready to send.