Is there a plain english way of sending Emails direct from Acess?

[Centaur]

I want to press a button on a form and it send an email pertaining the
selected record.

Is there a plain english way of setting up the code to make it happen.

Best wishes

Centaur

 

[Brendan Reynolds]

No, there is no 'plain english' answer to this question. It's a technical
question, and therefore requires a technical answer.

Some good technical answers are at ...
http://www.granite.ab.ca/access/email.htm

 

[Chris Reveille]

Maybe this will help
1 - create a table with userID and email address.
2 - create a form with the criteria for the report
combo boxes for "email to", CC and BCC
Text box for Subject
Text box for message
Report Name

a control box containing the logged on user emailaddress (
for verification takenfrom the table defined
A command buton which emails a report using a macro.
The macro would contain the action sendobject with the
following properties
OBJECT TYPE: Report ' if none leave blank
Object name: ReportName ' if none leave blank
Output Format: select type desired ' if none leave blank
TO: =[Forms]![NameOfForm]![email to]
from =[=Forms]![NameOfForm]![loggeduseraddress]
CC =[Forms]![NameOfForm]![CC]
BCC =[Forms]![NameOfForm]![BCC]
Subject =[Forms]![NameOfForm]![subjecttexbox]
Message =[Forms]![NameOfForm]![messageTextbox]
Allow Edits: No will put email in Outbox, Yes will allow
edits to the email before sending

Chris