Email current form information

B

Bexar1

I would like to have a command button that emails the current form
information. The primary key on the form is a text field. Advice?
 
C

Chris Reveille

Do you want to send a report based on the current
information or send some of the information on the form in
an email?

Chris
 
B

brian b

One way to send a report: Build a query by form using
[forms].[form1].[primarykey] as the Criteria. Use the query as the data
source for the report. Add the following to a command button:
DoCmd.SendObject acSendReport,
"report1",acFormatRTF,"toaddressee","ccaddressee","bccaddressee",,"subject","body",true

Format can be XLS, RTF, HTML or TXT.
True will open the email app
False will send without editing
 
Top