Mail Merge Send Report - Download and Column Reference

Select "Download report" after a campaign finishes or is cancelled, and save the Excel file before starting another campaign. It records which messages Microsoft 365 accepted, failed rows and scheduled times. It does not confirm inbox delivery or email opens.

Were my emails sent?

The send report records what SecureMailMerge submitted to Microsoft 365. It is not a delivery confirmation. Start with the SMM_Status, SMM_Error and SMM_ScheduledFor columns:

Outcome	What to do next
`Sent`	Microsoft 365 accepted the message. If `SMM_DeliveryMode` is `Deferred`, check its future send time in Drafts; otherwise check Sent Items. Watch your Inbox for later bounces.
`Scheduled`	A send time was calculated, but this status alone does not confirm submission. Check your mailbox and the report before retrying.
`Failed`	Read `SMM_Error` and fix the cause before trying again.
`Unverified`	The result could not be confirmed. Check your mailbox and contact support before resending, to avoid a duplicate.
`Skipped`	You excluded this row before sending; no email was generated for it.
`Cancelled`	The row was not attempted before you cancelled the campaign.

Bounces arrive separately in your Inbox, even when Microsoft 365 initially accepted the message. SecureMailMerge does not track opens or clicks.

The report is built on your device, with one row per original recipient row and all your original data columns. Save a copy before starting a new campaign so you have a record outside the add-in.

Download the report

Wait for campaign generation to finish, or cancel the campaign.
On the finished campaign screen, select “Download report”.
Save the downloaded .xlsx file on your computer and open it in Excel or another spreadsheet application.
Check the outcomes above before selecting “Start new campaign”.

If you close and reopen Outlook, open the original template and the add-in to return to the campaign. Download the report while it is available; do not rely on the add-in as your permanent archive.

If you cancel a campaign, rows that were already sent or had failed keep their status, and rows that had not been attempted yet are marked as Cancelled, so the report still gives you a complete picture.

What the report contains

After your original spreadsheet columns, the report appends these columns in this order:

Column	Meaning
`SMM_Status`	The outcome for the row: `Sent`, `Failed`, `Scheduled`, `Cancelled`, `Skipped`, or `Unverified`. See the outcome table above.
`SMM_SubmittedAt`	When Microsoft 365 accepted the message for this row. This is the submission time, not the delivery time (see below).
`SMM_ScheduledFor`	The calculated send time for the row, if the campaign used scheduling options.
`SMM_DeliveryMode`	`Deferred` when Microsoft 365 held the message until its scheduled time, `Immediate` otherwise.
`SMM_To`, `SMM_CC`, `SMM_BCC`	The actual addresses used for the message after personalization.
`SMM_ConversationId`	The Microsoft 365 conversation identifier of the created message.
`SMM_InternetMessageId`	The internet message identifier. Some Microsoft 365 tenants do not provide this value, in which case the cell is blank.
`SMM_Attachments`	The attachment filenames included for this recipient, separated by semicolons.
`SMM_Error`	The error message for a failed row.
`SMM_CorrelationId`	An identifier that matches this row to lines in the diagnostics log, useful when working with support.
`SMM_CampaignId`	The identifier of the campaign.
`SMM_BatchTimestamp`	When the campaign started sending. This stays the same across pause and resume.
`SMM_ResolutionNote`	How an uncertain outcome was resolved, when a person had to confirm it.

Cells that do not apply to a row are left empty. Timestamps use the ISO 8601 format, which Excel recognizes and can reformat to your preferred date display.

Submitted is not delivered

SMM_SubmittedAt records the moment Microsoft 365 accepted the message, not the moment it arrived in the recipient’s inbox. Delivery is handled by Microsoft 365 and the receiving mail servers afterwards.

For scheduled campaigns the two timestamps work together: the message is submitted right away and Microsoft 365 holds it until the time in SMM_ScheduledFor. In that case SMM_SubmittedAt is legitimately earlier than SMM_ScheduledFor and SMM_DeliveryMode shows Deferred.

If you have used the send report before: this column was previously called SMM_SentAt. It was renamed because “sent at” read like a delivery time, and a new SMM_DeliveryMode column was added at the same time.

Many-to-one campaigns

If your campaign combined multiple spreadsheet rows into one email, the report still contains one row per original spreadsheet row. Each contributing row shows the outcome of the single message it was part of.

Skipped recipients

Recipients you unselected in the recipient preview are not emailed, but they appear in the report with the status Skipped, so you have a complete record of who was excluded.

Your data stays on your device

The report is generated locally and saved straight to your device. Recipient rows, addresses, message identifiers, and error details are never sent to SecureMailMerge servers. Keep in mind that the exported file contains your recipients’ personal data, so store and share it according to your own data policies.

Good to know

The report is always an .xlsx file, even if you uploaded your recipients as CSV or picked them from your contacts.
Uploading a send report as the spreadsheet for a new campaign treats it like any normal spreadsheet: the SMM_ columns are not yet recognized for features like resending only failed rows.
Download the report before starting a new campaign, rather than relying on stored campaign data for record-keeping.

Need more help?

Email support with what you were trying to do, what happened and the exact error message. Do not include real recipient data.

How do I download the send report and read its columns?