A
ac512
Hello
I am using an access 2002 database, and have a table (which I will call
'tblPayments'). Within this table, I have the fields 'CusName' and
'PaymentAmt'. I am trying to create some visual basic code (I am not very
good at it!) which will enable me to send a separate e-mail to all the names
in the 'tblPayments' table outlining their payment amounts ('PaymentAmt').
Is there any way of doing this?
I am able to do this if I have a drop-down in the form with all the users
names; basically by selecting the names one at a time and then clicking the
command button that activates the code to send the e-mail to the individual.
But, I am hoping to be able to click the button once, and all the e-mails
will go out to the individuals automatically with their specific payment
amount only.
I hope this makes sense!
Hoping someone can provide some assistance
Thanking you in advance
AC
I am using an access 2002 database, and have a table (which I will call
'tblPayments'). Within this table, I have the fields 'CusName' and
'PaymentAmt'. I am trying to create some visual basic code (I am not very
good at it!) which will enable me to send a separate e-mail to all the names
in the 'tblPayments' table outlining their payment amounts ('PaymentAmt').
Is there any way of doing this?
I am able to do this if I have a drop-down in the form with all the users
names; basically by selecting the names one at a time and then clicking the
command button that activates the code to send the e-mail to the individual.
But, I am hoping to be able to click the button once, and all the e-mails
will go out to the individuals automatically with their specific payment
amount only.
I hope this makes sense!
Hoping someone can provide some assistance
Thanking you in advance
AC