Using email to update Table records

[Nih]

Wasn't sure exactly where to post this so here goes:

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?

 

[Maurice]

There is an option in the wizard which lets you select the emailaddresses.
When starting the wizard you get the various options to choose from. One of
the last options is to select the person you want to sent the mail to by
checking or unchecking the checkboxes.

It's important that you have a table or query which holds the email adresses
because that's the only option you can choose here. That's also one of the
options you have to choose from the wizard, if you want email from outlook or
emailaddresses from an accestable or query.

a handy tip is to select the designated query first and then choose 'create
mail'.

If you want it to be dynamically you might consider using creating an append
query which adds the selected records which the user selected from the form
and use a temp table as a source for the create mail option.

 

[Nih]

Thanks but I am not trying to send the table to only one recipient, I want to
only send one RECORD in the table to a recipient, right now it only emails
the entire table.

For example say I have a table with all employee's personal info and I want
to email John Doe his record and have him update it with his new info then
email it back. Right now Access will only let me email John Doe the entire
table with everyone's personal info.

 

[De Jager]

Thanks but I am not trying to send the table to only one recipient, I want
to
only send one RECORD in the table to a recipient, right now it only emails
the entire table.

For example say I have a table with all employee's personal info and I
want
to email John Doe his record and have him update it with his new info then
email it back. Right now Access will only let me email John Doe the
entire
table with everyone's personal info.