Solved

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

Posted on 2004-09-25
4
293 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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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 Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

690 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