B
Bongard
Hi, I am trying to use a combo box in a form for the user to to choose
a [LoanServicer]. Once this is done, they will click a button that is
linked to a send object macro. Each Loan Servicer is responsible for
sending an email with with an attachment to each correspondent. For
instance, the name Brian is chosen on the form the macro should run
the qry [Correspondent Details] for each correspondent where the
[LoanServicer] field = Brian. For each correspondent, the query should
then be attached in an email and sent to that correspondent. The
correspondents email address is the field [PrimaryEmail] from the
Correspondent Details query.
I assume that I will have to create some sort of a looping statement
but I am not sure how to get started. Any help that someone could
offer would be much appreciated.
Thanks much,
Brian
a [LoanServicer]. Once this is done, they will click a button that is
linked to a send object macro. Each Loan Servicer is responsible for
sending an email with with an attachment to each correspondent. For
instance, the name Brian is chosen on the form the macro should run
the qry [Correspondent Details] for each correspondent where the
[LoanServicer] field = Brian. For each correspondent, the query should
then be attached in an email and sent to that correspondent. The
correspondents email address is the field [PrimaryEmail] from the
Correspondent Details query.
I assume that I will have to create some sort of a looping statement
but I am not sure how to get started. Any help that someone could
offer would be much appreciated.
Thanks much,
Brian