Sending Emails from Access

Serious Sam

New Member
Joined
Jan 19, 2005
Messages
30
Hola,

I am creating a database that registers new story ideas for a newspaper.
When a story idea is added to a table in the database (tbl Articles), the email address of the reporter assigned to write the story are input into the field ReporterEmail. At the end of a brainstorm session I want to send the story ideas to the reporters via email from the database.

I have read various postings that provide code for sending emails from an access.
My question is, where does the code get input? In a module? In the SQL view of a query? I'm not sure.

When a solution is found, I would also like to have a Yes/No field in my table checked to Yes when the record has been emailed, and for this check to prevent the record being emailed again. Can you provide a few clues?

I am using Access 2000 and Outlook 2002.
Thank you very much.
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

aw23

New Member
Joined
Jan 18, 2005
Messages
3
The code should be in a macro. Before sending the email, check the boolean field and only send to those that are yes. After sending the emails, run an update query on the table and all the records which you have sent to, set the boolean to yes.
 

Forum statistics

Threads
1,148,056
Messages
5,744,548
Members
423,882
Latest member
Seeham

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
Top