Access 2003 Report won't attach to an email message.

S

Steve

I have placed the following code behind a command button.
DoCmd.SendObject acReport, "rptPO_EmailViewOnly", "HTML(*.html)",
Forms!frmMain!sfrmPOMultiTAB!frmPOHeaderViewer!SupplierEmailAddress, "", "",
"Purchase Order", "", True, ""

The problem is once the email message is generated the report attachment is
not added to the message.
To try and fix the problem, I installed Office 2003 SP3.
After that, the attachment worked but is not able to be opened, I get an
error message "The operation failed due to network or other communication
problems. Check you connections and try again."

ANy help would be appreciated as I have a client who relies on this function
on a daily basis.

Thanks Steve.
 

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