Emailing based on criteria

[Jack W via AccessMonster.com]

Hi Guys,

I currently have a query that has 'Broker' as a field, on my form I select
the relevant broker and then hit an email button to send object to that
broker with their details (the table in the form has broker and email address
in the second column, email address is my recipient in VBA code.

I have to manually select each broker and then click send email for each one,
how do I go about having it so that it auto sends to each broker with their
details only?

 

[David Lloyd]

Jack:

Depending on exactly what object you are sending with the SendObject method,
the approach can be a little different. Below are two previous posts
related to sending a report, or sending no object. If those don't address
your needs, you may want to clarify what you are doing with your SendObject
method.

http://groups.google.com/group/micr....com+sendobject&rnum=6&hl=en#768266ce6f744440

http://groups.google.com/group/micr....com+sendobject&rnum=6&hl=en#a23f3a584181b309

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Hi Guys,

I currently have a query that has 'Broker' as a field, on my form I select
the relevant broker and then hit an email button to send object to that
broker with their details (the table in the form has broker and email
address
in the second column, email address is my recipient in VBA code.

I have to manually select each broker and then click send email for each
one,
how do I go about having it so that it auto sends to each broker with their
details only?