Running an on-demand report in TrackMyMail

You can run an on-demand report for a particular job.

Products affected: TrackMyMail™

You can run an on-demand report for a particular job.

  1. On the left side, select TMM Dashboard.
    Dashboard icon
  2. In the View Details column next to the job you wish to run the report on, select the Choose Report menu and choose the report you wish to run.
  3. The report will be sent to the email associated with your profile. The email will come from [email protected].

Opening reports

Emailed reports are in CSV format. On most Windows computers, these will open in Excel by default. When opening CSV reports in Excel, it may auto-format the cells, which can cause data to be displayed incorrectly. To view reports with the data formatted correctly, the file must be imported instead of opened.

  1. From the report email, click the link and save the downloaded report. Do not open the report.
  2. Open Excel and open a new blank workbook.
  3. Select the Data tab.
  4. In the Get & Transform Data section on the ribbon, choose From Text/CSV.
    tmm-rpt-open-excel-new-from-btn
  5. Select the CSV file that you saved in step 1 and click Import.
  6. A window opens with the file name at the top and the data as shown below. Make sure that the Delimiter is set to Comma.
    tmm-rpt-open-excel-new_850x636
  7. If the report includes IMbs, under Data Type Detection, select Do not detect data types to keep the IMbs intact.
    Data Type Detection field in Excel import window
  8. Click Load.
  9. Save the file.

UPDATED: February 20, 2025