Query Current Record Only to be sent Via E-Mail

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

System Administrator - 30 Nov 2005 17:47 GMT

How can I query the current record only and have it sent via e-mail with the
click of a command button?

Reply to this Message

[MVP] S.Clark - 30 Nov 2005 19:07 GMT

In the query, put criteria like:

WHERE [Field] = Forms!FormName!Controlname

Sending things in an email is accomplished with SendObject or Total Access
Emailer: http://fmsinc.com/products/emailer/index.asp

Signature

Steve Clark, Access MVP
http://www.fmsinc.com/consulting
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

> How can I query the current record only and have it sent via e-mail with
> the
> click of a command button?

Reply to this Message