Email to update records in a table - only want 1 record emailed



One of my employees is trying to utilize the functionality in Access 07 where
she can create an email that allows the recipient to make updates to a tables
record then emails the new info back and that updates the databases' table
accordingly. The problem is when she creates the email (using the Create
Email button on the External Data tab) the email includes every record in the
table, she only wants to send out one particular record in the email and
doesn't want the recipient to be able to see all the other records. I can't
find an option in the wizard to pick what record you want, how can I filter
the email the way she wants? I thought I could create a query to select only
the record I wanted then email the results of that query but Access tells me
I cannot collect data for action queries using email.

Any thoughts?

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