e-mailing reports excel format

[leahf via AccessMonster.com]

We set up a system for e-mailing reports in WORD. However, because the lines
of the report are not entered in the WORD format (and we cannot rely on
Snapshot or PDF being on everyone's computer), we would like to change the
format to EXCEL.

We are getting the message: "the format in which you are attempting to
output the current object is not available".

The only thing that I changed in the sendReport command was "acFormatRTF" to
"acFormatXLS".

What else do I need to do?
Leah