Email current form information

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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