Sign in to your LBNL email account

1. Click the setting icon
2. Click See all settings

1. Select the Accounts
2. Under Send mail as section, click Add another email address

Under the Add another email address you own window:

1. in the Name field, type in a name for the email
2. In the Email address field, type in the email address you want to add
   DO NOT type in [email protected] - it will not work
3. Check the box for Treat as an alias
4. Click Next Step

1. Input the confirmation code into the confirmation code box
2. Click Verify

Sign in to your lbl.gov email account

Click AUTHORIZE ACCESS

Create a draft email:

• Be sure to select the email you want to send as in the From field
• Fill in the Subject and Body field
• Leave the To field blank

Grab or create a Google Sheet with recipients' email addresses and any other required information needed for the email campaign:

• Make sure the email addresses are in the first column in the Google Sheet.
• Make sure to link to the Google sheet column if you want to include the information by adding {{column name}} in the email draft from the previous step. The column name needs to be typed exactly the same as seen in the Google Sheet

In the Google Sheet that you are using for the email campaign:

1. Click Extensions
2. Click Yet Another Mail Merge: Mail Merge for Gmail
3. Click Start Mail Merge

In the Start Mail Merge window:

1. You may be prompted to select the column for the email address, be sure to select the correct column. If not, you will see (change) in blue. You can click on it to confirm that the correct email column is selected
2. In the Sender Name field, type in the email that you are using to send as
3. In the Email Template field select the email draft you've created for the email campaign
4. Uncheck the box Track emails opened, clicked, or bounced
   IMPORTANT, it's recommended to uncheck this box to make sure the email campaign is successful and to follow Mass Emailing and Mailing Lists guidelines and Prevent Emails from Looking Phishy.
   
   

Now, before you send out the email campaign, do a test first:

1. Click on the Send a test button and you can check and make changes as you need. Keep in mind you can only send out 1,500 emails a day. If you have more emails to send, spread them out over multiple days
2. Once you are ready to send out the email, click Send # emails

• Once the email campaign has been sent, check back in the Google Sheets and you will see a new column titled Merge status with the status EMAIL_SENT. That means it was successful.
• You can add more email addresses and information to the Google Sheet and reuse it. Previous recipients that already have EMAIL_SENT status under the Merge Status column will not get a duplicate email.
• If you want to resend the email to previous recipients, just delete the EMAIL_SENT under the Merge Status column for the recipients.