Recent content by ConfusedBex

I'm still stuck on getting this to work 100%. With the coding above, it creates an email per record in my query, I really want all records with ID 1 to be put together in one email, all records with ID 2 in another email etc... Any help would be REALLY great!!

OK so I've changed what I have as I found some other coding where the query data is in the email body in table format (which looks pretty). At the moment: One email is created per record in my query, with the same email contact (in the To field) and same ID (in the Subject line). The email...

Ok, so I've created the query so now the query outcome looks like: ID DATE Person Yes/No Email 001 20/4 Mr A email1 001 20/4 Mr B email2 001 20/4 Mr C email3 004 20/4 Mr D...

This is what I have so far... not I've used numerous other threads to piece together this. I've only got it to create a new email for every ID in the CONTACT table with generic wording... (also not sure if the code will come up right) Public Function SendEmailAuto() Dim db As DAO.Database...

Hi, I'm a very new to VBA so I'm hoping what I'm looking for isn't too complex, or maybe someone might already have something written that might be able to help me out with the below. I have a table called Contacts in Access: ID Email 001...