What mail merge is
Mail merge takes one email and a list of people and produces a personal copy for each of them. Where your email says Hi @first_name, Ada reads “Hi Ada” and Kwame reads “Hi Kwame”. Done well, it is the difference between an announcement and a letter. And because each person gets their own message, nobody sees anyone else’s address (unlike pasting everyone into CC).
Step 1: prepare the spreadsheet
- The first row is the header: short names like
email,first_name,city,plan. - One row per person, no merged cells, no blank rows in the middle.
- One email address per cell, with no spaces around it.
- Only people who agreed to hear from you. Bought lists are the fastest way to the spam folder, and often illegal.
Mailvender reads CSV, TSV, Excel (.xlsx, .xls), OpenDocument (.ods) files up to 100 MB (.xls and .ods up to 30 MB). Export from Google Sheets with File → Download → CSV.
Step 2: add merge tags
A merge tag is a placeholder named after a column. Type @ in any text, button or link in the Mailvender studio and pick a column, such as @first_name or @city. Tags work in the subject line too, which is where personalisation is most visible.
Empty cells become empty text, so plan for them: give the greeting a condition. Show “Hi @first_name” when first_name is not empty, and a plain “Hello” block when it is. Nobody gets “Hi ,”.
Step 3: show the right block to the right person
Names are the start. Conditions let a whole block, such as an image, a section or a button, appear only for some rows: free delivery for people whose city is Lagos, an upgrade offer only where plan is “starter”. One email then does the work of several segmented ones, and stays easy to maintain.
Step 4: test with real rows
Preview the email as several actual people from your list, especially the ones with long names, missing cells or unusual characters. Then send a test to yourself and read it on your phone.
Before a campaign goes out, Mailvender’s Send flow walks through List → Audience → Email → Checks → Send, and each step tells you what is missing: no email column chosen, no subject, no compliance footer with your postal address and unsubscribe link. Fix it in place and the step turns green.
Step 5: send, and look after the list
Each recipient gets their own message from your verified domain. People who unsubscribe, addresses that bounce and anyone who reports spam are added to your do-not-send list automatically, so the next campaign skips them even if they’re still in your spreadsheet. Campaign reports then show what was delivered and, if you turned tracking on, opened and clicked.
Put it into practice.
Mailvender designs, checks and sends emails from your own domain, and handles all of this for you.
Create your account