Your spreadsheet can include one or more Report Fields that ExcelSend will populate with information about messages sent and received. The field names are fixed and are optional.
|EXS_WasMessageSent||Determines whether the message relating to that row was sent or not||text field: Yes or No|
|EXS_DateSent||If the message was sent the date and time it was sent||date field|
|EXS_Message||The text of the message that was sent||text field|
|EXS_SendError||The reason a message was not sent||text field|
|EXS_WasReplyReceived||Determines whether a reply was received to the original message sent||text field: Yes or No|
|EXS_DateReceived||If a reply was received the date and time it was received||date field|
|EXS_Reply||The text of the reply that was received||text field|
To use Report Fields they must be included in your spreadsheet before uploading to ExcelSend to use in sending your message.
Before Uploading To ExcelSend
This example spreadsheet shows 4 columns of data and 3 columns for the report fields.
|2||Joe||02/26/2021 15:11:29||078 00000000||12.50|
After Downloading From ExcelSend
Once the messages have been sent and replies received you can download the spreadsheet from the Message Job and ExcelSend will populate the report fields.
|2||Joe||02/26/2021 15:11:29||078 00000000||12.50||Yes||05/31/2020 10:32||Ok, thanks. I'll see you there|