Recent content by Steve123

You're right about my code only sending the last record pbaldy, I had stripped down my data for testing so hadn't realised. I've made changes to get this bit right now. I'm still at a loss with sending one email per person with all of the query lines that contain their email address. I can...

Hi pbaldy, I've played around with the original code but with the sToName = sToName = .Fields(5) & ";" included I get an error too. I've taken it out and the error goes but i still get an individual email per query line. The code now looks like this: Dim MyDb As DAO.Database Dim rsEmail As...

I've been using this excellent piece of code thank you. My query returns a number of rows for the same recipient I would like to know how I can use this to consolidate the data and send all relevant records for one person on one email? Dim MyDb As DAO.Database Dim rsEmail As DAO.Recordset...