473,729 Members | 2,150 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Using CDO Mail with 2K or 2k3

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
Nov 13 '05 #1
3 1942
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.c om (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
(undocumente d 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


Nov 13 '05 #2
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.

Nov 13 '05 #3
le**@kaplooey.c om (Leah) wrote:
Is there a way to make the security popups in Outlook 2003 not appear
(undocumente d 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
Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
3273
by: PeterR | last post by:
I've spent weeks trying to write a function that is simple to use for sending emails with attachments, but I my programming skills are not that advanced. I've noticed a few postings in these newsgroups with the same problem, so I just want to share my solution. I recommend using libmail from http://lwest.free.fr/doc/php/lib/index.php3?page=mail&lang=en it has made my university project much simplier now! :-)
1
5748
by: Irmen de Jong | last post by:
Hi I'm trying to create e-mail content using the email.MIMEText module. It basically works, until I tried to send mail in non-ascii format. What I did, to test both iso-8859-15 and UTF-8 encodings, was this: ---- from email.MIMEText import MIMEText m=MIMEText(u"body text including an Euro char \u20ac\n", _charset="iso-8859-15") m = "from@mail.invalid"
1
8181
by: Eric Sheu | last post by:
Greetings, I have been searching the web like mad for a solution to my SMTP problem. I am using Windows Server 2003 and ASP.NET 2.0 w/ C# to send out e-mails from a web site I have created to the members of my organization. I think my problem is incorrectly setting the settings on my server or an authentication problem. Here is the code I have written to send a test message: -----Code Begins: Sensitive Information Replaced by -----...
2
3496
by: Ryan | last post by:
Hi, I receive an access denied error (see below) when attempting to send an email with BodyFormat=MailFormat.Html from an asp.net page. Exactly the same code works fine in a console application, and also succeeds from the asp.net page with BodyFormat=MailFormat.Text. I've recently upgraded from W2K SP4 to WinXP SP2 and am using .Net Framework v1.1 SP1. The code worked fine under W2K SP4.
2
4531
by: Brad | last post by:
I have a web .Net app which sends emails with attachments. After the email is sent I clean up aftermyself and delete the attachments from disk. In upgrading to .Net 2 I changed the email logic from using system.web.mail to system.net.mail (of course vs is telling me system.web.mail is obsolete). In .Net 1.1, the files deleted with no problem but in .Net 2 when I attempt to delete I receive The process cannot access the file ...'...
2
2656
by: Abhi | last post by:
i need to create a user in web mail using dotnet coad by using webmailserver api ex: xxx is my webmail then i want to create to a user in that webmail xxx ex: yyy@xxx.com how i should do in dotnet code plz.... help me
1
5685
by: Prasanta | last post by:
Hello, How to read a mail from the mail server as formatted. I am able to read the mail as row HTML, is there any class, or something method using that i can easily get the all info of that mail, like as TO,From,Subject,Body. here I am attaching my coe which i developed. using System; using System.Collections.Generic; using System.Text;
4
7681
by: =?Utf-8?B?dHBhcmtzNjk=?= | last post by:
I have a web page that at the click of a button must send a bunch (1000+) emails. Each email is sent individually. I have the code working fine, using Mail Message classes and smtp and all that. But sometimes even when I'm just sending one e-mail the web page takes a minutes or so to post. Can anyone tell me why it is so slow, or how to fix the problem? To address this I am thinking of just creating a queue table to write the emails...
4
1846
by: Ron | last post by:
I have this code on one of my forms, the code takes whatever is in textboxes and adds it to a MS Access Database. It then shows a message that the operation was completed. Is there a universal command or code to send an email to the email entered in txtemail.text How would I do something like that? Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click
4
17476
Frinavale
by: Frinavale | last post by:
Introduction Many .NET applications will require an email be sent out for various reasons. This article will give a quick examples on how to send an email using VB.NET. The examples given can easily be translated into C#.NET. Storing Email Credentials If you are developing a web application the best place to store your email credentials is in your web.config file's <appSettings>. This will allow you to secure your email credentials using...
0
8913
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9142
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8144
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6722
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6016
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4525
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4795
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2677
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2162
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.