I need to send a report via email.

[Frank Martin]

We normally send the reports to our customers
via faxes, which can be done directly from
the computer.

But now more and more customers want the
reports emailed.

How can we send the reports directly from
Access2003 to the Outlook Express which we
normally use for email.

Please help, Frank

 

[Damian S]

Hi Frank,

Easily achieved!!

DoCmd.SendObject acSendReport, "REPORTNAME", acFormatSNP, EMAILADDRESS, , ,
"SUBJECT", "Please see the attached snapshot file. If you have difficulty in
viewing this file, please ensure that you have the Microsoft Snapshot Viewer
installed. It is free, and can be downloaded from download.microsoft.com or
by clicking the link below." & vbCrLf & vbCrLf & _
"http://www.microsoft.com/downloads/...3f-6d74-423d-8274-8b7e6313edfb&DisplayLang=en", True

The True on the end says that you want to edit the email before it's sent.
If you want it to just disappear, change this to false. I have used the
snapshot format in the example as it maintains all formatting and sends a
non-editable file to the user.

Hope this helps.

Damian.

 

[Frank Martin]

Thanks.


"Damian S"
message

Hi Frank,

Easily achieved!!

DoCmd.SendObject acSendReport,
"REPORTNAME", acFormatSNP, EMAILADDRESS, ,
,
"SUBJECT", "Please see the attached
snapshot file. If you have difficulty in
viewing this file, please ensure that you
have the Microsoft Snapshot Viewer
installed. It is free, and can be
downloaded from download.microsoft.com or
by clicking the link below." & vbCrLf &
vbCrLf & _
"http://www.microsoft.com/downloads/...3f-6d74-423d-8274-8b7e6313edfb&DisplayLang=en",
True

The True on the end says that you want to
edit the email before it's sent.
If you want it to just disappear, change
this to false. I have used the
snapshot format in the example as it
maintains all formatting and sends a
non-editable file to the user.

Hope this helps.

Damian.