Automation to Send Email to separate emails from a query

dpmac

New Member
Joined
Nov 1, 2005
Messages
4
I have simple database. It consist of Two tables.

TBL 1 consist of the email addresses with a unique identifer to TBL 2. TBL 2 consists of the data needed to be sent to individual email accounts.

I was thinking of a simple query to combine the two tables, but I need to send an email to each individual from the query and have the emails created automatically each time the query runs.

HELP!!!
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Welcome dpmac,

Check out my post on this thread, plus my sample download, it does what you are asking for.
 
Upvote 0
Corticus

Thanks for your reply. I checked out your website. Pretty cool. Can you please be more specific to the post you recommended me to. I don't mean to sound stupid, but I could not find it.
 
Upvote 0
Thanks for getting back to me so fast. Thanks for the code. It looks like it will work fine. I appreciate the help.
 
Upvote 0

Forum statistics

Threads
1,226,727
Messages
6,192,687
Members
453,747
Latest member
tylerhyatt04

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top