Sending email from Access

[Chaz]

Good morning,

Is there an "easy" way to send email from within Access? In particular I want to email people that are points-of-contact when lease agreements are coming due, and would like the database to read the system date and compare it to the lease renewal date, and automatically send out an email to the person who administers the lease.

Thanks for any help!

Chaz

 

[Malcy]

Hi
Have you tried doing a forum search on "email"?
There are loads of very helpful threads which cover almost every conceivable aspect.
It is worth digging around.
Good luck

 

[jeremie_ingram]

Is this an internal e-mail useing something in the way of outlook?
Do you have the e-mail addresses within the database?
If you are familliar with VBA, you can 1) Create a report detailing what you need (based off the proer queries and such) 2) Create a button to trigger the e-mail and code behind it DoCmd.SendObject

Select the report as the object and add in the proper To: CC: or BCC and it might do what you want.