How do I download the send report and read its columns?
After a campaign finishes (or is cancelled) you can download an Excel send report with one row per recipient row from your spreadsheet. It keeps all your original columns and appends SMM_ columns with the outcome of every row, including status, timestamps, resolved addresses, attachments, and message identifiers. The report is generated on your device and is never uploaded to SecureMailMerge.
Contents
Description
The send report is your record of what happened in a campaign. When a campaign finishes or is cancelled, you can download an Excel (.xlsx) file with one row for every recipient row in your spreadsheet. Your original columns are preserved unchanged and in their original order, and SecureMailMerge appends a set of SMM_ columns describing the outcome of each row.
Because SecureMailMerge does not store your campaign data on any server, the report is built entirely on your device and downloaded directly. It is the only persistent record of the campaign, so download it before you start a new campaign.
Download the report
When a campaign has finished sending, or after you cancel one, the finished campaign screen offers the report download. The report stays available even if you close and reopen Outlook: the finished campaign is restored with its download option until you explicitly start a new campaign, which clears the stored data.
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, or Skipped (a recipient you unselected before sending). |
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. |
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
.xlsxfile, 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. - Starting a new campaign clears the stored data of the previous one, so download the report first if you need it.
See also
- Reviewing and unselecting recipients before sending
- Sending a mail merge on a specific day
- Sending a mail merge during specific hours
- Sending a mail merge with many-to-one mode
Ready to try it yourself?
SecureMailMerge for Outlook
Runs inside Outlook — no external app needed. Free to install.
Free · No credit card required