MS Access and Outlook Interoperability

[Vik]

Not sure if I should post this here or the Access board but here's my question:

Is it possible to create a standard Access database, populate it with data
and set it up so that whenever a specifc event occurs (e.g. a person's
insurance expires) the Access DB will automatically send out an email to the
requested contact?


Thanks for any replies.

Vik

 

[Sue Mosher [MVP-Outlook]]

That's definitely more of an Access question than an Outlook question. The Outlook issue that you need to be aware of is that you can't send mail from Access VBA without triggering security prompts unless you use a third-party library (Redemption) or CDO for Windows. See http://www.outlookcode.com/d/sec.htm for details.