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

[kyle.j.petersen]

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?

[Allen Browne]

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

--
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.

<ky*************@gmail.com> wrote in message
news:11**********************@t31g2000cwb.googlegr oups.com...

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?