SendObject and excel format

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?
 
G

Guest

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)
 
G

Guest

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?
 

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

Top