Export your member contact email addresses form ClubZap
Login to the ClubZap admin portal (clubzap.com/signin)
Go to Membership -> Members -> Export
On the export field filter choose the following fields
Member Id - Unique ID per member
Fore Name - Members first name
Surname - Members Surname
email - Members email
Member Type - Youth/Adult etc
Membership ID - identifier to link members to the same family membership
Note: Youth members (U18) would not have an email address but they can be linked to their parent/guardians contact email using the Membership ID column in the export.
Mail Merge
Mail merge lets you create batch emails that are personalized for each recipient. For example, a meeting invite might be personalized to address each recipient by name.
On your computer, open Gmail.
At the top left, click Compose.
You can also open an existing draft.
Go to the "To:" line.
Click Use mail merge
.
Turn on Mail merge.
In your message, enter “@.”
Select a merge tag.
To filter the list, enter the name of a supported merge tag:
For first name, enter “@firstname”
For last name, enter “@lastname”
For full name, enter “@fullname”
For email address, enter “@email”
To select a merge tag, press Enter.
Add recipients from a spreadsheet to your message
Instead of adding recipients to your message directly, you can load recipients from a spreadsheet (e.g: ClubZap export) where each row contains information for a different recipient. You can use any column from your spreadsheet as a merge tag in Gmail, so you can personalize messages with more information.
Important: Contact information must be in the first tab of your spreadsheet and can only contain text.
On your computer, open Gmail.
At the top left, click Compose.
You can also open an existing draft.
Go to the "To:" line.
Click Use mail merge
.
Turn on Mail merge.
Click Add from a spreadsheet.
Select a spreadsheet, then click Link.
Use the dropdown menus to select the columns from the spreadsheet to determine each recipient's address (e.g. Lisa Rodriguez <lisa@example.com>). You can choose the following contact information from your spreadsheet:
Email
First name
Last name (optional)
Click Finish.
Your spreadsheet is added to the “To:” line in the message.
In your message, enter “@.”
Select a merge tag.
Merge tags are determined by the column headers in your spreadsheet.
To select a merge tag, press Enter.
Tip: When using a spreadsheet for recipient information, check the text characters used in your column headers and email addresses.
If a column name contains special characters, other than A-Z or numbers, the corresponding merge tag in Gmail will be identified by its position. For example, the first column would be called “@A.”
If an email address contains special characters, it’s considered invalid.