Solved

Mail Merge form Access to Outlook 2000- Item.Send Security Issue (Workaround??)

Posted on 2004-09-25
4
289 Views
Last Modified: 2010-05-18
Pain in the A$$

I am using a custom Access DBase to manage my contact information. I have a Query that I want to E-Mail to all of the contacts in the Qyery. I am using MS Word, and Mail Merging to the Query to send E-Mail via Outlook.

Since the last security update from MS, when an outside program tries to initiate Item.Send, it gives you a warning message and you must INDIVIDUALLY grant access to EACH E-Mail sent, then you must WAIT 5 seconds between confirmations! (A real problem since I am sending 900 E-Mails)

Does anyone know any GOOD workarounds, or better way to send this type of mass communication??

MS has no solution.     http://support.microsoft.com/default.aspx?scid=kb;EN-US;192258

0
Comment
Question by:tobytkd
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 41

Accepted Solution

by:
shanesuebsahakarn earned 100 total points
ID: 12152181
0
 

Author Comment

by:tobytkd
ID: 12152206
Cool....
What do you find to be the "best" option??
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12152230
Well, I work in an Exchange environment, so I deploy the Security & Administration package, which disables the warnings completely. If you don't need to track the e-mails via Outlook then CDONTS is a good option, but otherwise, ClickYes might be your best bet.

Your other option is to downgrade Outlook to an earlier service pack.
0
 

Author Comment

by:tobytkd
ID: 12152286
Thanks...I think I'll try ClickYes for now....
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question