Sending emails from Access 2003

[ATChurch]

This is probably fairly simple, but I am having no luck finding a solution.

I want a button that will send out an email of a report from access.

It needs to go out to multiple recipients simultaneously whose contact
details are stored in a separate form. Although these are unlikely to change
all that often, so if push comes to shove the email addresses could be hard
coded into the button.

Ideally, if the only message was "Your emails have been sent" that would be
fantastic but just having it open Outlook ready to be sent would be
sufficient.

 

[ATChurch]

Thanks for the swift reply. Just some followup questions.

My VBA programming skills are not that good, are the areas in the code you
provided that I need to change to "my values" the "As String" parts?

Secondly, you said I "need to create a saved file from the report before
being able to send it" Can this be done using the same button? Preferably
deleting it afterwords. I'm after a "send email" button where all the
information needed is in the database, so as little interaction from the user
as possible.

 

[ATChurch]

Thanks for the swift reply. Just some followup questions.

My VBA programming skills are not that good, are the areas in the code you
provided that I need to change to "my values" the "As String" parts?

Secondly, you said I "need to create a saved file from the report before
being able to send it" Can this be done using the same button? Preferably
deleting it afterwords. I'm after a "send email" button where all the
information needed is in the database, so as little interaction from the user
as possible.

 

[ATChurch]

Can anyone else help with this?

 

[Gee]

I'm needing this answer too...can you tell me where I'm supposed to supply
the data needed?
Thanks