Stamplark Mail Merge: help

Get started

  1. In Outlook, start a new email. Write it like any other: formatting, pictures, your signature.
  2. Where each person's details go, type a tag with the column name from your spreadsheet: Hi {{First name}},. For cells that might be empty, add a fallback: {{First name|there}}. Tags work in the subject too.
  3. Click Mail merge on the ribbon (in Outlook on the web and the new Outlook it can be under the Apps button).
  4. Under Recipients, open a CSV or Excel (.xlsx) file, or copy the cells in your spreadsheet (header row included) and paste them.
  5. Check the preview of each email, click Send me this one to see a real one in your inbox, then Send.

Leave the draft's To line empty: each email goes to the address in its row. Delete the draft afterwards (or keep it for next time).

Tags

TagBecomes
{{Column name}}That row's cell, exactly as it appears. Capital letters and extra spaces in the tag don't matter.
{{Column name|fallback}}The fallback text when the cell is empty.
{{_today}}Today's date.
{{_email}}The recipient's address.
{{_row}}The row number in your spreadsheet.
{{_table}}When one person has several rows and you pick "One email listing every row": a table of their rows.

The pane lists your columns: click one to put its tag at the cursor in the draft. A tag that doesn't match a column is flagged before anything sends, with the closest column name.

A different attachment for each person

Add a column (for example Attachments) with each row's file name, like INV-1042.pdf. Several files: separate them with a semicolon. Pick that column in the pane, click Pick the files and select them all. Rows whose file wasn't picked are held back and listed, unless you tick "Send rows whose attachment wasn't picked". Files attached to the draft itself go to everyone.

Attachments can total up to 3 MB per email. For bigger files, put a sharing link in the email instead.

CC, BCC and From

Pick a CC or BCC column for per-row copies, or open Filter, duplicates, CC and BCC for everyone for addresses copied on every email. To send from a shared mailbox or alias, change the draft's From before you send; your Microsoft 365 admin must have given you Send As permission.

Filters and duplicates

Send only some rows: "Only rows where Status is Invoice due", or a row range like 2-50, 75. When the same address appears on several rows, choose one email (the first row), one email with a table of all their rows, or one email per row.

Send now or schedule

Microsoft 365 allows 10,000 recipients a day per mailbox by default, and your organization may set less. Stamplark warns you when a day would go over.

Stopping and resuming

Click Stop at any time. Sending again from the same draft and data skips every row that already went out, so nobody gets two. To send the same campaign again on purpose, click Send them again in the Check step.

The report

After a campaign, Copy report copies a table of every row (sent, scheduled, failed, skipped and why) to paste next to your data. Download CSV saves the same table.

Sign-in and permissions

Sign in with your Microsoft account so your trial and plan follow you. The first time you send, Microsoft asks you to allow Stamplark to send email as you (the Mail.Send permission). Stamplark can't read your mailbox, contacts or files. Some organizations require an admin to approve add-ins that send mail; if you see "Need admin approval", send your IT admin this page.

Plans

Trial: 50 emails or 14 days, whichever comes first, no card needed. Test emails to yourself don't count. Then $19/month or $159/year per person; teams buy seats at the same price per person. No footer or branding is added to your emails, on any plan.

Support

Email hello@greatwork.company. A person replies within one business day.

More about Stamplark Mail Merge, with screenshots and pricing: Stamplark Mail Merge in the Great Work app catalog.