If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Emailing a report in Excel format
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! |
Thread Tools | |
Display Modes | |
|
|