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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
Add the command "Clear All Filters" to a Command Button in Access 2010? 0
Separate Form 0
Linking forms 1
How do i set open form to current record? 8
Create form using query doesn't fill fields 12
Force Autonumber to generate 0
Command Button Question 2

Back
Top