How Mailveteran Mail Merge Works?


Configure your Google spreadsheet and list your recipients

It would be best if you also had your contact list ready. After installing the add-on, Go to Addons > Mailveteran > Start Mail Merge to open Mailveteran

Add column headers to your spreadsheet.

Each column will represent a personalized field in your email. In this simple example, we have only 5 columns: firstname, email, company, position, and websiteThe data in these columns can be used as personalized variables in your email. You can add as many columns as you want and pick any column header name you want.

Fill the spreadsheet with your recipients’ data

Fill your spreadsheet with all the information needed. Ensure all email cells are filled with valid email addresses. However, Once you run the Mail Merge, you can name any column from the spreadsheet as a recipient column. For example, if you called it ‘Prospects’, select the Prospects as recipient column in Mailveteran. Apart from emails, you can leave some cells blank, that’s fine! Our Mail Merge will skip those details in personalisation.

Once your contact list is ready, Create a simple draft email template in Gmail then open Mailveteran and start the campaign. In menu, go to Add-ons> Mailveteran > Open Mailveteran

Compose a draft in Gmail

First, you need a draft Gmail template. You can create a personalized draft in Gmail for every campaign by including personalization on First Name, Last Name, Address, Discount, Website, etc. To compose a draft, click Compose in Gmail, and write the email that you want, and hit save


Select your template in Mailveteran

That’s it! You can now use your template in Mailveteran. Go to Add-ons > Mailveteran > Start Mail Merge.

Send your mail merge with Mailveteran

Once you’re ready, click the Send Emails button to send your mail merge to your recipients.

You can also use our test email feature to check what your email will look like before sending it definitely.


2)How to track and measure your emailing campaign results?

With our tracking tool, all stats on your campaign are retrieved in real-time. Every time a recipient opens, clicks, or unsubscribes from your email, or if your emails bounce, the information is automatically and immediately recorded in the report. After sending your mail merge, the tracking report automatically opens on the right sidebar of your Google Sheets.

Check your tracking stats again

If you have closed the tracking sidebar, you can always open it again through the add-on menu. A new entry called Open tracking report appears.



3)Schedule a mail merge from multiple accounts

Mailveteran automatically sends your scheduled campaign from one of your accounts. When you don’t have enough quota anymore, Mailveteran switches to another account etc. So in the end, each account will send parts of your campaign one after another one.

Get your contact list ready and share your Google Sheet

Share your spreadsheet to all your accounts as Editor.


Share your draft to all your accounts

Finally, create your email template in one of your accounts’ Gmail draft. Then to share this draft with all of your other accounts, copy-paste the HTML code of the content of your Gmail draft and send it by email to your other accounts.

Activate our scheduling option from each of your accounts. Here’s an example when using two different accounts.

This is the first account.


This is the second account.


Then schedule your mail merge one by one from each of your accounts.



4) How to schedule Mail in Mail Merge?

Select Schedule Email, and Choose the time to which you want to schedule the campaign sending.