Using CDO Mail with 2K or 2k3

[Leah]

I'm updating an app currently in Access 2000, which uses Outlook 2000
(sr1a) to send emails behind the scenes. Several issues have come up
since I've started work on this.

This office is moving to Office 2003, and the annoying security
prompts for Outlook automation are not wanted by the customer.

So, I started looking at CDO mail. Lots of stuff there, but nothing
works - in Access 2000. (Known bug, alternative is to use outlook
automation, resulting in popups to let it run)

Several questions - is it worth it to move completely to access 2003
and use CDO, where the bug will disappear? ONly about ten users will
have this access app.

Is anyone using CDO successfully in Access 2000 or Access 2003, and
would like to give me pointers?

Is there a way to make the security popups in Outlook 2003 not appear
(undocumented features)?
I'd love comments and feedback - I'm really not sure which road to
head down, and the customer wants this deployed next Friday.
Thanks in advance,

Leah

[Rick Collard]

I have used CDO without problems in Access 97 and 2002. On Windows NT
and XP I have avoided the security popups by restoring CDO 1.21
instead of using CDO 1.21s (the 's' denotes the security update) that
is installed by Outlook or a Windows update. To me, this is a
temporary solution until I have time to investigate but it has worked
without problems.. Just save your current cdo.dll and replace it with
the older version to give it a try. I am using cdo.dll with file
version 5.5.2448.0 which came from an Windows NT system running Office
97. HTH

Rick Collard
www.msc-lims.com
On 27 May 2004 10:46:42 -0700, le**@kaplooey.com (Leah) wrote:

I'm updating an app currently in Access 2000, which uses Outlook 2000
(sr1a) to send emails behind the scenes. Several issues have come up
since I've started work on this.

This office is moving to Office 2003, and the annoying security
prompts for Outlook automation are not wanted by the customer.

So, I started looking at CDO mail. Lots of stuff there, but nothing
works - in Access 2000. (Known bug, alternative is to use outlook
automation, resulting in popups to let it run)

Several questions - is it worth it to move completely to access 2003
and use CDO, where the bug will disappear? ONly about ten users will
have this access app.

Is anyone using CDO successfully in Access 2000 or Access 2003, and
would like to give me pointers?

Is there a way to make the security popups in Outlook 2003 not appear
(undocumented features)?
I'd love comments and feedback - I'm really not sure which road to
head down, and the customer wants this deployed next Friday.
Thanks in advance,

Leah

[Salad]

Leah wrote:

I'm updating an app currently in Access 2000, which uses Outlook 2000
(sr1a) to send emails behind the scenes. Several issues have come up
since I've started work on this.

This office is moving to Office 2003, and the annoying security
prompts for Outlook automation are not wanted by the customer.

So, I started looking at CDO mail. Lots of stuff there, but nothing
works - in Access 2000. (Known bug, alternative is to use outlook
automation, resulting in popups to let it run)

Several questions - is it worth it to move completely to access 2003
and use CDO, where the bug will disappear? ONly about ten users will
have this access app.

Is anyone using CDO successfully in Access 2000 or Access 2003, and
would like to give me pointers?

Is there a way to make the security popups in Outlook 2003 not appear
(undocumented features)?
I'd love comments and feedback - I'm really not sure which road to
head down, and the customer wants this deployed next Friday.
Thanks in advance,

Leah

Well, this may result in Bronx Cheers from others, but you can use
SendKeys. Ex:
SendKeys "{Enter}"

The caveat with Sendkeys is that while the process is running, someone
may quickly open up the Explorer, select a bunch of files, right click
and select Delete, and while sitting there pondering if they should
delete the files or not Sendkeys fires and answers the question for them.

If this is near instantaneous, I wouldn't worry. Let the boss know you
are using a kludge to fix a problem and if people want to open up and
work on other applications while the e-mails are being sent they may
experience problems.

[Tony Toews]

le**@kaplooey.com (Leah) wrote:

Is there a way to make the security popups in Outlook 2003 not appear
(undocumented features)?

See the Outlook page at the Access Email FAQ at my website.
http://www.granite.ab.ca/access/email/outlook.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm