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?
information. The primary key on the form is a text field. Advice?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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
information or send some of the information on the form in
an email?
Chris
G
Guest
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
[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