Email current record

[wagz]

I need a way that I can email the current record that I am viewing.
Currently I have a code that email the entire table. I would also like to
send the email to the person's email in the record, so the To: field will
contain thier email address. I am using Outlook and Access 2007.

 

[Alex Dybenko]

Hi,
you can create a report, which show current record and then use
docmd.sendobject to send this report.

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Trickiedickiedido]

Hi Alex,
You state how wagz "should" resolve this, but you don't explain "how" he
should go about doing this?
I am in the same situation and want to email the current record in a form
(either as a page from the form or a report).

Cheers,

Richard

 

[Alex Dybenko]

Hi,
just make a report filtered to your current record in the form

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com