C
Chris B
Hi,
I have a user that has been using a Macro and the SendObject function for
quite some time to send a Snapshot report to multiple users. In fact, she
has several Macros, each used to send a different report. However, two of
these macros have recently started causing an issue.
Normally when the report is sent, it is attached to the email as a snapshot
report as indicated in the SendObject parameters. Now however, it is
converting the snapshot report to an Excel file and attaching the Excel file.
The excel file is garbled and the information is unreadable.
The only appears to be happening on two of the Macros, the rest work fine.
I think it probably has to do with the reports themselves, but I'm not sure.
The macros have been dropped/recreated and it still does the same thing. Can
one of you guru's point me down the road to resolution?
Thanks....
I have a user that has been using a Macro and the SendObject function for
quite some time to send a Snapshot report to multiple users. In fact, she
has several Macros, each used to send a different report. However, two of
these macros have recently started causing an issue.
Normally when the report is sent, it is attached to the email as a snapshot
report as indicated in the SendObject parameters. Now however, it is
converting the snapshot report to an Excel file and attaching the Excel file.
The excel file is garbled and the information is unreadable.
The only appears to be happening on two of the Macros, the rest work fine.
I think it probably has to do with the reports themselves, but I'm not sure.
The macros have been dropped/recreated and it still does the same thing. Can
one of you guru's point me down the road to resolution?
Thanks....