Use SendObject Property to email designated person who is listed in a table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kyle.j.petersen@gmail.com - 30 Mar 2006 23:56 GMT

I have a form where I select a business and I need to send a report to
a person who is tied to that business in one of my tables. How can I
use a command button that is tied to a macro to Send a report to the
specified person?

Reply to this Message

Allen Browne - 31 Mar 2006 07:08 GMT

In the lower pane of the macro design window, try using DLookup() in the To
argument.

For example, if the email address is found in MyEmailField in Table1, where
the ID is 99, use:
DLookup("MyEmailField", "Table1", "ID=99")

That works with SendObject in code. I'm not sure if it works in the macro.

If you need help with DLookup(), see:
Getting a value from a table: DLookup()
at:
http://allenbrowne.com/casu-07.html

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have a form where I select a business and I need to send a report to
> a person who is tied to that business in one of my tables. How can I
> use a command button that is tied to a macro to Send a report to the
> specified person?

Reply to this Message