Search results

Hi Lightwave, Thanks for those. I'm had a go at using the bit of code that you sent over, above, and I'm getting a runtime error saying; The database has been placed in a state by user 'Admin' on machine..... that prevents it from being opened or locked. The debug brings up; "Set MyDB =...

Maybe something like... Private Sub NewTestEmailSend() 'Open My Contacts Table and Filter to those that require an email DoCmd.OpenTable "tblContacts", acNormal, acEdit DoCmd.ApplyFilter "", "[tblContacts]![Send_Email]= -1" Not sure what needs to go here 'Open the data table and filter to...

If that's what you think is the best way of doing it... (I'm really not sure of the best way) It's the filtering bit I'm having trouble with, how do I create a query that filters to each individual row in the contacts table without having to write 300 queries?

Hi, I have two tables; tblContacts 300 rows, 4 columns; Name, UNIQUE_ID, Email_Address, Send_email tblData18000 rows, Various columns of data including UNIQUE_ID Note: UNIQUE_ID can have multiple records in tblData, but only 1 record in tblContacts I am trying to write some vba to...

Sorry - also missed off a bit... The contact list table also has a send email, "Yes" or "No" field, that would need to control whether the email was sent. Again, hit me up if that makes no sense. Thanks, Andy

Hi, Sorry, this may be in the wrong area of the forum. I am looking to send some emails from Access that initially filter a query and send the relevant table as an excel file, or similar. I have loads of tables that put information together into a nice query that I want to send. So I'm...