SendObject and Oulook (Access 2002 SP-1)

Topic

New Reply

Background:
I have a database where I would like to send a snapshot of a report via code. I built a Macro with the sendobject command and supplied all the necessary arguments. I then did a Save As to create a module. I placed the code behind a button on my form. When I click the button it looks like everything is going through its motions. It ask me for a profile, I choose Outlook. Outlook gives me a warning that an application is automatically sending an email, I choose not to cancel. I click the yes option when it becomes available. Access gives me the error message: Unknown message recipient(s); message not sent. I have entered my contact information and saved it in Outlook.

Can anyone shed some light on this problem.

Thanks in advance
Tom

Reply | Quote

Replies

You’ll need to post the code before anyone can be sure they’re giving you the right answer. It sounds like the address you’re entering isn’t resolving properly.

Reply | Quote

Here is the line of code.
DoCmd.SendObject acSendReport, “rptBugs”, “SnapShotFormat(*.snp)”, “tfarrington@mindspring.com”, “cc”, “bcc”, “Bug Reported on: ” & Now(), “Double Click on Snapshot.”, False, “”

Reply | Quote

Your problem appears to be here: “Double Click on Snapshot.” Unless SendObject has changed a lot between A2k and AXP, you’ve got an extra argument there where it expects a true/false EditMessage value.

Reply | Quote

Don’t put in the “cc” and “bcc”. If you are not sending copies to anyone just leave these blank but retain the commas.
Also, since the template argument at the end is blank leave it and its comma off.

Your code will be

DoCmd.SendObject acSendReport, “rptBugs”, “SnapShotFormat(*.snp)”, “tfarrington@mindspring.com”,,, “Bug Reported on: ” & Now(), “Double Click on Snapshot.”, False

Reply | Quote