CDO vs. MAPI

[ColeChaW]

Based on your experience, what is the faster, easier way to send e-mail in the background of an Access application, connecting to MS Outlook or using a CDO connection to the exchange server?

I'm not really looking forward to switching to the exchange server and bringing our IT Dept. into my program, but if it works better I'm all for the headaches and arguements.

In case you were wondering, this part of my application tracks education hours and e-mails empolyees when their certification gets within 4 months of expiring. This is all checked with a query. It then sends a simple text message, with one recepient and 4-5 CC to remind them about it.

 

[DJkarl]

Based on your experience, what is the faster, easier way to send e-mail in the background of an Access application, connecting to MS Outlook or using a CDO connection to the exchange server?

I'm not really looking forward to switching to the exchange server and bringing our IT Dept. into my program, but if it works better I'm all for the headaches and arguements.

In case you were wondering, this part of my application tracks education hours and e-mails empolyees when their certification gets within 4 months of expiring. This is all checked with a query. It then sends a simple text message, with one recepient and 4-5 CC to remind them about it.

IMO if all you're doing is sending simple text messages then I would use the CDO method over MS Outlook. The main reason being is if your IT department upgrades the exchange server security you may start getting the annoying messages from Outlook saying a program is trying to send email on your behalf...blah blah blah. The CDO method will not generate that message.