emailing report snapshot with DoCmd.SendObject

W

will eichert

I'm using visual basic code behind an Access form to email a snapshot
report to a user.

The problem is that the "To" field of the email isn't getting filled
out. The message subject, message body, and snapshot attachment are
all correct, but the message "To" field is left blank (also the "CC"
and "BCC" options don't work). Any idea what's happening here? Or
which component is likely to be the culprit? Access, Mozilla, or some
config issue on the machine?

I'm using Mozilla's email client, and the DoCmd.SendObject call looks
like this:

DoCmd.SendObject acSendReport, theReportName, "Snapshot Format",
"(e-mail address removed)", , , messageSubjectText, messageBodyText,
false

Thanks,

Will Eichert
 
M

Mark

Did you try other email client? Such as Microsoft Outlook ? go to
IE->Internet Options->Programs tab, change the default email client to
Microsoft Outlook.
 

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