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

  • Thread starter Thread starter Centaur
  • Start date Start date
C

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
 
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
 
Back
Top