How to best send Emails

[Jack W via AccessMonster.com]

Ok,

I'm not that flash with Access but I'm learning. At the moment, I've got a
union query that has all info from say 4 different brokers, all with the
first column as Broker and their name. So say we have ABC, DEF, GHI and XYZ
as brokers. Another query based off this one calculates if we need to make a
payment to them. I've got a form with a combo box linked a table with a list
of brokers. I use this as a criteria for my query so I can view payments for
one broker. Now, if I want to email this query to the broker, I want to do a
sendobject, but I don't know how I'd get the email address of each different
broker to populate....could I have their email address stored in my table
with the brokers so and have the table as my To: field in VBA?

I've probably written in a really confusing way and I apologise...

Cheers.

 

[Jack W via AccessMonster.com]

How do I add a table field into VBA? I've got a sendobject code and I want to
make the To: field lookup the email address I have in the broker table.

I've tried [tblBrokers]![Address] but that puts that literally in the To:
field...

Can anyone help and will this work?