Emails from Access...

[dbn00bz]

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 left with;

Contact List Table (EMail address & Unique ID)
Data Table (Various fields including Unique ID)

I would like to setup a macro or module etc, that would scan the Contact List table, grab the Unique ID, filter the data table to those rows that match the unique ID and create an email, using the email address associated with the Unique ID in the Contact List table.

*take a breath.

I've created several Macro's which do this job as current, however, as there are 500 odd unique ID's, it's a very manual task, spread over about 10 different macros.
Ideally, I'd like to run it all from 1.

Does that make sense?
Any questions that could help clear up?

Any help, greatfully recieved... even if it's a "can't do it".

Regards,
Andy

p.s. I'm very new at all this... so speaking in jargon would probably confuse me.

 

[dbn00bz]

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

 

[HiTechCoach]

Here is an example that is very close to what you want:

Sending Emails To A Group, One Person At A Time