A | B | C | D | E | F | G | |
---|---|---|---|---|---|---|---|
1 | name | date | mobile | balance | EXS_WasReplyReceived | EXS_DateReceived | EXS_Reply |
2 | Joe | 26/02/2021 15:11:29 | 078 00000000 | 12.50 | Yes | 31/05/2020 10:32 | Ok, thanks. I'll see you there |
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.
Field Name | Description | Format |
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.
A | B | C | D | E | F | G | |
---|---|---|---|---|---|---|---|
1 | name | date | mobile | balance | EXS_WasReplyReceived | EXS_DateReceived | EXS_Reply |
2 | Joe | 26/02/2021 15:11:29 | 078 00000000 | 12.50 |
A | B | C | D | E | F | G | |
---|---|---|---|---|---|---|---|
1 | name | date | mobile | balance | EXS_WasReplyReceived | EXS_DateReceived | EXS_Reply |
2 | Joe | 26/02/2021 15:11:29 | 078 00000000 | 12.50 | Yes | 31/05/2020 10:32 | Ok, thanks. I'll see you there |