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

> Download an Excel send report after every mail merge campaign to see who was emailed, when each message was accepted, and what every column means.

## 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](https://www.securemailmerge.com/help/sending-mail-merge-with-many-to-one/), 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](https://www.securemailmerge.com/help/reviewing-and-unselecting-recipients/) 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.
- 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](https://www.securemailmerge.com/help/reviewing-and-unselecting-recipients/)
- [Sending a mail merge on a specific day](https://www.securemailmerge.com/help/sending-mail-merge-on-a-specific-day/)
- [Sending a mail merge during specific hours](https://www.securemailmerge.com/help/sending-mail-merge-during-specific-hours/)
- [Sending a mail merge with many-to-one mode](https://www.securemailmerge.com/help/sending-mail-merge-with-many-to-one/)