Looking For Advice For How to Achieve This...

[Darrell Wootton]

Hi,

I am looking for advice and pointers on hows best to achieve the following:

We have a reports system, the reports are written and working.

Here is where I need advice:

The user needs to email the report information to the end users.

We use MS Outlook.
We have a global address book with all users email entered.(However I could handcode the email address's or use a table for emails)
The report does not have to be in Access reports format (ie: I can use excel etc)

I need it to populate outlook message with.

To.
Subject.
Attachment (Report)
Tag up read reciept option
Send the email.
All Automatically if possible.

Any advice or pointers on how to resolve the problem would be welcome.

Thanks

Darrell....

 

[dt01pqt]

Do a search before you post.

Study these

    Dim objOutlook As Object
    Dim objMsg As MailItem
[snip]
    Set objOutlook = CreateObject("Outlook.Application")
    Set objMsg = objOutlook.CreateItem(olMailItem)
[snip]
    With objMsg
        .To = 'whoever
        .Subject = "subject of e-mail"
        .Body = "body goes here"
        .Attachments.Add([I]Path[/I])
        .ReadReceiptRequested = True
[snip]
        .Send
    End With
[snip]
    Set objOutlook = Nothing
    Set objMsg = Nothing

Is the general gist of it.

Look up OutputTo in the help files to save your report in a different format.