email only one record in access 2003

Benita,
Not a lot of detail to go on, but...

Create a report that is always filtered by some key value on the form
you are initiating the email from.
Example: A unique key field named CustID on form named MyForm

In the query behind the report, use that form value as a criteria to
filter
out all CustIDs except the one currently displayed on the active and open
form.
Example: = Forms!MyForm!CustID
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

<Benita Alston> wrote in message news:2009101171715bmw@nwnatural.com...
> How to e-mail only one record access 2003?
>
>
>
> Pepomarg wrote:
>
> email only one record in access 2003
> 08-Oct-08
>
> When I try to email a record it makes me a snapshot of all records and not
> only the one I want.
>
> EggHeadCafe - Software Developer Portal of Choice
> Dictionary Lookup ASP.NET ServerControl
> http://www.eggheadcafe.com/tutorials/aspnet/8bce9387-0278-433b-b7e1-23...6e88d76