How Can We Help?

Mail Merge For Tickets

← All Topics

You can use Mail Merge to send your attendees custom emails with our QR Code tickets.

To do so, you need to import the attendees using a CSV file.

From the Attendees page, go to Actions > Import Many Attendees.

On the import page, select the event, upload your CSV file with the attendee details, choose the event tickets and date.

After that, choose the Download Ticket URLs option.

Once your attendee details have been imported, from the confirmation message download the CSV file to use with your mail merge.

The CSV file, will contain the names of the attendees, a URL to their ticket page, and a URL for the QR Code itself.

Mail Merge With Outlook

What you need:

  • Microsoft Word
  • Microsoft Excel
  • Outlook (desktop app)
  • Your CSV file with at least: First Name, Last Name, Email, QR_URL

Steps:

  1. Open Excel
    • Open your CSV in Excel.
    • Ensure your columns are labeled: First Name, Last Name, Email, QR_URL
    • Save as .xlsx (if it’s still .csv)
  2. Open Word
    • Go to Mailings tab → Start Mail Merge → Email Messages
    • Click Select Recipients → Use an Existing List → choose your Excel file
  3. Write your message e.g Hi «First_Name», Here's your event ticket: <img src="«QR_URL»" alt="Your Ticket QR Code"> See you soon!
  4. Finish & Merge
    • Click Finish & Merge → Send Email Messages
    • To: Email
    • Subject line: “Your Event Ticket”
    • Mail format: HTML
    • Hit OK and emails go via Outlook.

Mail Merge With Gmail

Tools: Use [Google Workspace add-ons] like:

Steps with YAMM:

  1. Google Sheets
    • Open Google Sheets
    • Import your CSV (File > Import > Upload CSV)
    • Columns: First Name, Last Name, Email, QR_URL
  2. Compose email in Gmail
    • Write a draft in Gmail and use variables like: Hi {{First Name}}, Here's your ticket: <img src="{{QR_URL}}" alt="Your Ticket QR Code"> Thanks!
  3. Back to Google Sheets
    • Click Extensions → Yet Another Mail Merge → Start Mail Merge
    • Select your draft email and hit send.

Topics