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

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: joebloe@xxxxxxxxxxx
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.
.

Relevant Pages

  • Re: Date range on reports
    ... box to your report with a control source like: ... > In the Database window (Database window: The window that appears when you ... > In the New Form dialog box, click Design View, and click OK. ... > Begin by clicking Macro Names to display the Macro Name column. ...
    (microsoft.public.access.reports)
  • Re: Date range on reports
    ... Create an unbound form (unbound form or report: A form or report that isn't ... In the Database window (Database window: The window that appears when you ... In the New Form dialog box, click Design View, and click OK. ... Begin by clicking Macro Names to display the Macro Name column. ...
    (microsoft.public.access.reports)
  • Re: Date range on reports
    ... Without knowing where your report parameters were coming from, ... >>> open an Access database or an Access project. ... >>> In the New Form dialog box, click Design View, and click OK. ... >>> Begin by clicking Macro Names to display the Macro Name column. ...
    (microsoft.public.access.reports)
  • Re: D3 Output processor macros
    ... Actually I'm creating a pretty good looking report with OP. ... that I found has to do with the .TCL command. ... ..TCL command was inserting 'extraneous' form-feeds in the middle of the ... > macro that can be inserted anywhere with identical results. ...
    (comp.databases.pick)
  • Re: A question about converting text to excel and automatically searching data
    ... Creating a worksheet from a text file. ... Writing the macro might be a little bit tricky, though, depending on how ... Creating your report. ... > formula if needed and placed in the proper cell of the main report ...
    (microsoft.public.excel)