Tickmi

Knowledge

Bulk email from an Excel list: mail merge or a ticketing system?

To send bulk email from an Excel list you have three options: Word and Outlook Mail Merge, Gmail combined with Google Sheets through an add-on, or a ticketing system like Tickmi. The first two are enough for notification emails personalized with a name. When each attendee needs a unique QR code, you need to know who received the email, and you need to resend quickly, a ticketing system is the better fit.

· 5 min read · Written by the Tickmi product team, checked against Tickmi Studio

Bulk email from an Excel list: mail merge or a ticketing system?

What is bulk email from an Excel list?

Bulk email from a list (mail merge) means writing one email template with blanks, then letting software fill in the data from each Excel row and send a separate email to each person. Recipients see an email addressed to them alone, and do not see anyone else's address.

Every mail merge method needs three things: a list file with an Email column, an email template with merge fields such as {Full name}, and an email account to send from. The difference is whether each person's data is complicated, and whether you can track the sending results.

3 ways to send bulk email: Word/Outlook, Gmail + Sheets, a ticketing system

All three can send personalized emails; the biggest differences are unique QR codes and send status tracking. The table below compares them on the criteria event organizers usually need.

CriterionWord + Outlook Mail MergeGmail + Google Sheets (add-on)Ticketing system (Tickmi)
SetupNeeds Word and Outlook on a computerInstall an add-on in Google SheetsUse in a browser
PersonalizationInsert fields from Excel columnsInsert fields from Sheets columnsInsert fields from attendee information, including custom fields
Unique QR code per personYou must create QR images and merge them in yourselfYou must create them yourself, depending on the add-onCreated automatically when the ticket is issued, with a ticket code
Sending limitsPer your mailbox quotaA Google account has a daily limit on emailsSent through the system, or through the organization's SMTP
Send status trackingCheck the Sent folder manuallyDepends on the add-onStatus for each ticket, with a Send failed alert
Resending to one personFilter the row and run it againFilter the row and run it againResend email button
Check-in at the gateNoneNoneScan the QR in the same system

If you are weighing Gmail against a dedicated tool specifically, the article sending tickets with Gmail or a ticketing system looks closely at Gmail's quota.

When is Word/Outlook Mail Merge or Gmail enough?

Mail merge with office tools is enough when the email only carries general information and the list is small. Typical cases:

  • Internal meeting invitations, schedule announcements, post-event thank-you emails.
  • You do not need to control who enters the door and do not need a unique code for each person.
  • The list is moderate and within the sending limit of the email account you use.
  • You accept checking the Sent folder and bounce emails yourself to know who did not receive it.

A hypothetical example: an HR department sends a training schedule to a few dozen employees. Word + Outlook does this neatly in a few minutes, with no extra tools.

When does bulk email call for a ticketing system?

You need a ticketing system when the email is not only an invitation but also the entry ticket. Then each email must contain a unique QR code, and you must know for sure whether each person has received their ticket.

With Tickmi, the process is as follows:

  1. Go to the Attendees tab, choose Import attendees and upload the Excel file. Before uploading, filter out rows with a missing email or a badly formatted email yourself. Note: Excel import only adds new people and does not update people already on the list.
  2. Design the email template with the drag-and-drop builder, insert personalization fields, turn on Attach the ticket file to the email if you want, then check it with Email preview.
  3. Issue tickets: each person receives a unique QR code and ticket code, and the email is sent.
  4. Track the send status in the Tickets tab. For any ticket showing Send failed, fix the email and click Resend email.

If you want emails to go out from the organization's own address, configure SMTP in the Ticket email menu and use Send test before activating. The detailed steps are in the guide to sending QR tickets in bulk by email and the guide to designing emails and using an email on your own domain.

Two things Tickmi does not do, so you can plan correctly: Tickmi does not schedule emails (emails go out when you issue or click send), and it does not measure email open rates. If you need to send in a specific time window, issue the tickets at exactly that time; suggested send timings are in the article email schedule before the event.

Checklist before sending bulk email

  • The Excel file has Full name and Email columns, one person per row, with duplicate emails filtered out.
  • Emails have been checked for format, with no stray spaces or trailing commas.
  • The email has a clear subject line, the sender name is the organization's name, and it is not written in all capitals.
  • You have sent a test to yourself and checked it on both a computer and a phone.
  • The sending address is the organization's email, with domain authentication configured following your email provider's instructions.
  • Someone is assigned to watch the failed-send list on the sending day.
  • If the email is an entry ticket: the check-in method and the support channel for people who lost the email have been agreed.

Common mistakes when sending bulk email from a list

MistakeConsequenceHow to avoid it
Putting all addresses in the To or CC fieldEvery attendee's email is exposedUse mail merge or a system that sends each email separately
A merge field with the wrong column nameThe email shows "{Full name}" instead of the real namePreview with sample data before sending
Exceeding the account's sending limitSending stops midway and it is unclear who received itSend in batches, or use a system with per-person send status
Matching a QR code to the wrong personThe attendee cannot get through the doorLet the system generate codes tied to each person
Re-importing the whole Excel file to fix informationWith Tickmi, a re-import only adds new people and does not fix existing onesEdit directly on each attendee

When you need to turn the whole list into QR codes, see also the article generating QR codes in bulk from Excel. An overview of the solution for issuing and sending tickets is on the QR invitation tickets page; you can start with 100 free ticket issuance quota, with details on the pricing page.

About Tickmi

Tickmi is a ticketing and participant experience platform. On a single, unified set of attendee data, Tickmi connects the whole journey: issuing invitation, registration and paid tickets, sending branded QR tickets, checking in with an app, kiosk or scanner (even offline), and then moving on to the welcome screen, lucky draw, polls, quizzes and surveys. Tickmi is trusted by organizations such as Viettel, VNPT, MobiFone, FPT and CMC. Learn about Tickmi or try it free.

Frequently asked questions

How can I send bulk email from an Excel list for free?

You can use Word Mail Merge with Outlook, or Gmail with a mail merge add-on in Google Sheets. If each person needs their own QR ticket, Tickmi offers 100 free ticket issuance quota.

Is there a limit when sending bulk email with Gmail?

Yes. Each Google account has a limit on how many emails it can send per day, and once you exceed it the account temporarily cannot send. Check Google's official help page for the type of account you use.

How can I tell which attendees did not receive the email?

With Word or Gmail, you have to check bounce emails in your mailbox yourself. In Tickmi, the Tickets tab shows the send status of each ticket; a ticket showing Send failed can have its email fixed and then be resent with Resend email.

Does Tickmi schedule emails or measure open rates?

No. Tickmi sends email when you issue the ticket or click send, and does not measure open rates. Tickmi focuses on making sure each person receives their own QR ticket and that you know which emails failed.

Can I send bulk email from my organization's email address?

Yes. In Tickmi Studio, configure the organization's SMTP in the Ticket email menu, click Send test, then activate it. If it is not configured, Tickmi sends from the system's default address.

Try Tickmi for free

Issue QR tickets, send emails, check in and engage attendees on one platform.

Sign up free

Contact Tickmi

Request a callbackChat on ZaloMessage on FacebookHotline 0349 632 920

Tickmi uses essential cookies to run this website and Google Analytics to measure page views and clicks so we can improve the product (only if you agree). Privacy policy