emailing an individual record

J

JulieC

I am trying to set up a control button, that when pushed will email a particular record in a form or table. I know that sendobject will email a table, form, query or report, but is there any way to isolate a particular record to send?
 
S

Steve Schapel

Julie,

Send a query, or a report based on a query, where the criteria in the
query is entered to refer to the current record on the form. The
criteria will use syntax such as [Forms]![NameOfYourForm]![NameOfKeyField].
 

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

Adding data to MS Access from csv file 0
Mail Merge skipping records/sending one at a time 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Outlook - Catgorizing emails by names 0
Can't send emails on new PC 1
Office365 Outlook for work email change signature how ? 0
Access 2010 DB not fuctional with multiple users 2
Windows 2016- Unable to do mail merge with my secondary email accounts 1

Top