SendObject creates an email but does not send it...

G

Guest

Hi,

My Goal is:
To automate generating a report in Access and sending it via email to 1 or 2
recipients once a day.

What I have done:
I'm using Access 2003 and Lotus Notes R5 (as my default email program). I
have written a macro in Access 2003 which uses the SendObject action to
create an email and attach a report to it. When I run the macro, the email is
created fine in Lotus Notes - the report is nicely attached, the "Message
Text" is included and the "To" field is correctly populated. I am using
scheduling software to run the macro in an Access database at a specified
time each day.
My SendObject arguments are as follows:
Object Type: Report
Object Name: Report1
Output Format: Rich Text Format
To: (e-mail address removed)
Subject: Daily Update
Message Text: Blah blah blah
Edit Message: No

The Problem:
When I run the macro (manually or via the scheduled task) the email is not
actually sent..... I would like to be able to SEND not just create an email
from Access. Currently I have to manually hit send in Notes to send the
email. I really need the email to be sent automatically (without manual
intervention) as the whole process will be run from a scheduled task.

Questions:
1. Is it possible to send an email from Access via a Macro?
2. Is there an obvious reason why the email is not being sent?
3. Is there another way of creating and sending emails with attachments from
Access?
4. Any other tips???

Any help would be very much appreciated. Thankyou.
 
S

Steve Schapel

Jenstar said:
Questions:
1. Is it possible to send an email from Access via a Macro?
Yes.

2. Is there an obvious reason why the email is not being sent?

The method you have outlined would work fine with Outlook, Outlook
Express, or Thunderbird. Therefore I would conclude the problem
probably has something to do with Lotus Notes.
3. Is there another way of creating and sending emails with attachments from
Access?

Not with a macro. Another commonly used approach is Office Automation,
using a VBA procedure to build an Outlook message. There is some good
information here, which may be of interest to you:
http://www.granite.ab.ca/access/email.htm
4. Any other tips???

Don't use Lotus Notes.
 

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