How to send email automatically from Access database

[Elaine16025]

Hello All,

I want to send Outlook emails to my group of coworkers (to remind them
of the biweekly meetings) every other Wednesday morning automatically,
can I do that through Access? If not, can it be done in some other
ways?

Thanks in advance!

Elaine

 

[Steve Schapel]

Elaine,

This can be done with Access. Using as macro is awkward since it would
involve looping through records, so in this case a VBA procedure would
be simpler. But I am also sure that this type of functionality is
available from within Outlook itself - ask for help on this in an
Outlook-related newsgroup. So my question is, why do you want to do it
from Access?

 

[Elaine16025]

Steve,

Thank you very much for your prompt reply. The reason I want to use
Access is that, I need to keep all the meeting agenda in the database.
I have two fields in my table, "Meeting Date" and "Agenda". Normally I
edit and save the meeting agenda before the meeting date, and I want
the meeting agenda and reminder be sent out automatically on the
"Meeting Date". Is it possible?

Thanks again for your time!

Elaine