E-Mail Single Record in Access

[Dan Austin]

I would like to e-mail a single field from an Access form using a command
button.

Optimally, the single field would consist of a concatenated fields from the
same record. I would like to do this in the simplest way possible.

Thank you.

[Jason Smith]

The easiest method is to use Docmd.sendobject. However, this method
envokes Outlook security which forces the user to click a confirmation
dialog before sending the email. I prefer using redemption which will
bypass this security. You can download redemption from
http://www.slipstick.com. The site will give you sample code, a .exe
file to install the required .dll file, as well as good documentation.
"Dan Austin" <da*****@slnysarc.org> wrote in message news:<Bp******************@twister.nyroc.rr.com>.. .

I would like to e-mail a single field from an Access form using a command
button.

Optimally, the single field would consist of a concatenated fields from the
same record. I would like to do this in the simplest way possible.

Thank you.