Re: Access 97 - Sending an Email with Content using a Command Butt

Tech-Archive recommends: Fix windows errors by optimizing your registry

Rob

Thanks for you reply, I tried the following to send the table "TBL_MAIN" in
XL format to Nancy Davolio and cc to Joan Weber with the subject being "New
Data Table"

DoCmd.SendObject acSendTable, "TBL_MAIN", acFormatXLS, "Nancy Davolio",
"Joan Weber", , "New Data Table"

This has returned the run time error 2287, "Microsoft Access cannot open the
mail session"

Any suggestions would be appreciated.

Thanks

Joe



"Rob Parker" wrote:

Check out the SendObject method in the help file. It allows you to set
several parameters (including cc: and subject: fields), and send any of
several objects (query, report, table, ...) as an attachment, in various
formats.

HTH,

Rob

"Joe Coulter" <JoeCoulter@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:18635022-6948-406F-A8AC-43A82B01EE24@xxxxxxxxxxxxxxxx
I have a database that is used to log details about received materials,
when
a new receipt is entered, I want some of the record detail sent to a
choosen
person via the users email when a button is clicked

I currently have a command button "eMail_Btn" with the following in the
"On
Click" Event - Application.FollowHyperlink "mailto:"; &
Me.EMailAddress.Value
EMailAddress being the field on the input form to choose the email address
to send.

This works fine, but only Opens the email software and populates the To
section with the selected email address, but what I also need to do is
also
populate the CC, Subject and include two or three pieces of information
within the body of the email with data also taken from fields within the
input form and automatically send the email.

I have been doing this with another system that emails to Lotus Notes from
Lotus Notes, but I now need to be able to change this to use any email
software.

I appreciate any help offered.

Joe



.

Quantcast