SendObject Method Fails

E

ET Sherman

I am using an Access 2k database on a Windows NT 4.0
server along with Microsoft Exchange Server 5.5. Outlook
2k is the mail client.

When I try to use the DoCmd SendObject method (to email a
report)I receive the following error especially on
reports that are more that 1 MB in size.

"Could Not Open One or More Attachments"

I have checked all the settings to make sure there are no
attachment size restrictions to no avail. I can manually
compose an email message and attach the file with no
problems. It only happens when I try to use the
SendObject method in Visual Basic.

The VB code is as follows:

DoCmd.SendObject acSendReport, "DeliveryTransactions",
acFormatSNP, , , , , , True

Any help will be appreciated.

Thanks,

ET Sherman
 

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