Question

MS Access - Email from form - VAR email receipients

Microsoft Access

Hello,

I have an access dbase and I need to email records (usually one at a time) to different receipients. The receipient name is part of the form and I have a table that lists the name and e-mail address. I am hoping to click a cmd button that will e-mail that individual the record on view. I know how to e-mail the record/s to a fixed email address - now I need to email to a variable. How do I do this?

Thanks,
Asuasol

You can cycle with a For Each loop through the email addresses records and pass this values to the Subroutine that sends the emails.
Bye