[AccessD] Outlook Automation Problem

Heenan, Lambert Lambert.Heenan at chartisinsurance.com
Thu Jan 28 11:34:33 CST 2010


Oh yes!. The brute force solution strikes again. :-) 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Thursday, January 28, 2010 11:55 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Outlook Automation Problem

Problem solved - using the simplest possible approach and without the liberal application of the client's cash. :( 

I had him uninstall every remnant of Office (2000,2003, and 2007) and do a fresh install of 2003 then do SP3 and viola! It makes an email just like the old days.  

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kenneth Ismert
Sent: Thursday, January 28, 2010 8:09 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Outlook Automation Problem

Ken Ismert:
> Out of curiosity, are you using Outlook simply to send emails from 
> your application? Or, are you doing deeper integration with Outlook?

Rocky Smolin:
> In this case just making an email:

I've always found Outlook a pain to deal with if all you need to do is send email. I just had a pleasant experience using CDO for Windows 2000 (CDOSYS), a component installed by default in Windows Windows 2000, XP, and Server 2003. For Vista, Windows 7 and later, the library is distributed as Collaboration Data Objects, version 1.2.1. (But, I haven't tested 1.2.1)

Unlike the old CDO for NTS, I was able to easily send email with just the address and port of a SMTP server using CDOSYS. The component required no installation on my XP box.

Links:

About CDO for Windows 2000
http://msdn.microsoft.com/en-us/library/ms527525(EXCHG.10).aspx

Collaboration Data Objects for Windows 2000 (CDOSYS) http://msdn.microsoft.com/en-us/library/aa142523.aspx

CDOSYS Examples (see ermora's snippet)
http://www.tek-tips.com/viewthread.cfm?qid=1280545

ASP Sending e-mail with CDOSYS
http://www.w3schools.com/asp/asp_send_email.asp

-Ken
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list