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.
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.