Find out how to personalize electronic mail with mail merge in Gmail

Discover ways to mix Google Contacts and Gmail multi-send to merge names into individualized emails.

In late 2022, Google added the flexibility to personalize Gmail messages despatched from multi-send mode. This implies you might now insert a @firstname, @lastname, @fullname or @electronic mail area inside a multi-send electronic mail, and the system will merge the corresponding area information from a recipient’s Google Contact report. Extra importantly, when Google introduced the characteristic, the corporate additionally indicated that “assist for customized mail merge tags utilizing spreadsheets” shall be added sooner or later.

Multi-send mode is offered to individuals who use:

• Google Workspace Particular person.
• Google Workspace Enterprise Customary or Plus.
• Google Workspace Enterprise Starter, Customary or Plus.
• Google Workspace Schooling Customary or Plus editions.

Moreover, a Google Workspace administrator should allow the characteristic by setting Permit Multi-send Mode to ON within the Admin console at Apps | Google Workspace | Gmail | Consumer Settings | Multi-Ship mode.

Find out how to handle a recipient record in Google Contacts

A Gmail multi-send merge attracts from information in Google Contacts, so be sure to have right data for every contact area you propose to make use of in your multi-send merge. If it’s good to import data into Google Contacts, you might obtain a Google-provided template to be sure to have information within the right fields for a .csv import. Open Google Contacts in a desktop-class browser to overview the info fields (Determine A) used within the mail merge course of:

• Prefix
• First Identify
• Final Identify
• Suffix
• Electronic mail

Determine A

First, be certain that the info for every recipient is right in Google Contacts with a overview of identify and electronic mail fields. For ease of use, you might wish to label contacts, so you might later choose that label so as to add all related contacts in an electronic mail recipient area.

Normally, additionally, you will wish to create a contact label (e.g., E-newsletter as proven in Determine A), then add that label to each contact you want to embrace on that record. This makes it doable to then choose the label whereas within the recipient area in Gmail so as to add all contacts with that label to the recipient record. You might choose the checkbox to the left of every contact for a set of contacts, choose the label icon (above the record of contacts), then select your contact label and choose Apply so as to add the label to the chosen set of contacts.

SEE: Find out how to handle your Google Contacts (TechRepublic)

Be sure your recipients lists don’t exceed Gmail sending limits or guidelines. One notable numeric constraint is that the utmost variety of recipients for a multi-send electronic mail is 1,500 electronic mail addresses. Do you have to ship this amount of electronic mail from an organizational tackle, you’ll be capable to ship 500 extra electronic mail messages that day earlier than you attain the each day total restrict of two,000 messages.

SEE: Find out how to ship mass emails from Gmail (TechRepublic)

The opposite vital rule is to not ship spam: Be sure the individuals you electronic mail are individuals who wish to obtain your electronic mail. By default, each multi-send electronic mail contains an “Unsubscribe” hyperlink that permits a recipient to take away themselves from this record. Nonetheless, if you ship electronic mail internally — to individuals inside your group — unsubscribing will not be an possibility. In different phrases, individuals could not be capable to unsubscribe from a multi-send inner message, akin to these less-than-useful emails from a frontrunner in your group who has mastered the artwork of the meaningless missive. For those who actually want to by no means see electronic mail from a selected particular person in your group, you might configure a filter to archive chosen emails routinely.

Find out how to insert mail merge fields in a multi-send Gmail

To create a brand new multi-send electronic mail, you’ll want to make use of a desktop-class browser, akin to Google Chrome as follows:

1. Go to Gmail.
2. Choose the Compose button within the higher left. (If the button isn’t displayed, choose the three horizontal line menu possibility within the higher left nook after which choose Mail.) Alternatively, if keyboard shortcuts have been enabled, press the c key.
3. Choose the multi-send icon from the lower-right portion of the compose menu icons, as proven by the crimson field in Determine B. The icon shows as an envelope positioned in entrance of one other envelope. A textual content field conveys that “You’re utilizing multi-send mode” together with extra textual content and a hyperlink to study extra.

Determine B

4. Add recipients (e.g., a set of recipients by way of a Google Contact label), an electronic mail topic and content material, a lot as you may in any commonplace Gmail.
5. Transfer your cursor within the textual content space of the e-mail to the place you want to insert your merge area, then kind @ to entry accessible mail merge tags, as proven by the crimson circle in Determine B. As of March 2023, these embrace @firstname, @lastname, @fullname and @electronic mail.
6. Choose the specified electronic mail tag from the record.

After you’ve gotten entered your whole multi-send electronic mail content material, choose the Proceed button. At that time, you might choose:

• Cancel, which lets you return to modifying your electronic mail,
• Ship preview, to convey a duplicate of your electronic mail to your individual Inbox, so you might fastidiously overview the e-mail content material, or
• Ship all, to carry out the merge, which sends an electronic mail to every chosen recipient.

Since, by definition, multi-send emails go to many recipients, be certain that to preview each message earlier than sending. Inevitably, typos, errors, omissions and incorrect dates/instances have a tendency to stay effectively hidden and solely reveal themselves after you press Ship. Use the Ship preview possibility, mixed with cautious proofreading to attenuate errors.

If a number of recipients lack information in a merge tag you’ve gotten used, the system will permit you to enter a default different (e.g., textual content to make use of when no first or final identify is current) or return to the draft and modify the recipient record to both add the lacking information or take away the recipient. For instance, in case your electronic mail begins, “Hello @firstname!” you may select “there” for contacts that lack an entered first identify, which leads to “Hello there!” textual content to these contacts.