SendObject and excel format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have Office XP and Outlook 2003. Here is the following code in Access:

DoCmd.SendObject acSendReport, "rptOutServiceAreaAudit", acFormatXLS

When I run this, I get this error:

The format in which you are attempting to output the current object is not
available.

If I try any other format, it works fine. What am I missing?
 
I don't see any email adresses in this, it should be something like this:

docmd.sentobject acsendreport, "rptOutServiceAreaAudit", acformatxls, [email
address(es) separated by a semicolon'], cc email addresses, bcc email
addresses, subject on email, text in email message, edit message (true opens
the email to edit, false sends it immediately)
 
Actually, you don't need the rest of the stuff. If I end it at the
acformatxls, it will open an outlook new message with the attachment and wait
for me to send the email.

Cyberwolf said:
I don't see any email adresses in this, it should be something like this:

docmd.sentobject acsendreport, "rptOutServiceAreaAudit", acformatxls, [email
address(es) separated by a semicolon'], cc email addresses, bcc email
addresses, subject on email, text in email message, edit message (true opens
the email to edit, false sends it immediately)
--
James Gaylord
Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wolf


ngan said:
I have Office XP and Outlook 2003. Here is the following code in Access:

DoCmd.SendObject acSendReport, "rptOutServiceAreaAudit", acFormatXLS

When I run this, I get this error:

The format in which you are attempting to output the current object is not
available.

If I try any other format, it works fine. What am I missing?
Click to expand...
Click to expand...
 
Back
Top