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