Sending multiple emails from Access Query
Posted on 2014-01-22
I want to be able to send multiple emails from Access, hopefully using Outlook. I have a database that I will run a query on to get a list of people to who the email will go to. Once I have the results of that query, I would like to email those people. I can get the results in a query, report, form what ever. Doesn't really matter. But what I do want to be able to do it click and how the emails go to those people "records". Each email will have to be personalized for each person. So if I have 30 people as a result it will have to be 30 emails, with 30 subjects lines (could be similar, and the body will need to reference a field value that will be different for each person. So in other words the email is not generic is that same data goes to each person. It would need to say Dear "firstname" "lastname", please note that your appointment is on "Date of appointment". If you have any questions please contact us at ....