Emailing a report in Excel format

S

Stephanie

Hi. I've had success emailing a report in acFormatRTF, but when I try to
email in acFormatXLS, I receive an error message: Error 2280: The format in
which you are attempting to output the current object is not avialable.

DoCmd.SendObject acSendReport, "Member List", acFormatXLS, me.EmailName, , ,
"Member List", "Attached is an updated Member List"

If I take our acFormatXLS, a "Send" box pulls up and I can choose "Microsoft
Excel 5-7 or 97-2002. I'm using vaious versions of Access, with the highest
version at 2003.

Thanks for the help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error emailing Excel attachment 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Excel does not accept text format! 0
Sending multiple reports, attachments 1
acFormatXLS Works in 2003 not 2007 1
e-mailing reports excel format 0
Access 2007 acFormatXLS not working 7
report in a loop 4

Top