Email merge with Word

[BK]

Using Windows XP and Office 2000.

I have created a lengthy list of email addresses in Excel. I have created a
mail merge document in Word that uses this Excel file as its data source. I
then merged the document to Outlook for email distribution.

When I started the merge, I got the following alert message for every one of
my 380 email messages. I had to manually click the "yes" button for each
individual message even though I set the permission to accept this answer
for a 30-minute time period.

The alert message generated from Outlook reads: A program is trying to
automatically send e-mail on your behalf. Do you want to allow this? If
this is unexpected, it may be a virus and you should choose "no." There are
three buttons below this message that are "yes" and "no" and "help." The
help button is where I was able to set the permission for a specified time
period, but I still had to manually click "yes" for each of the 380
messages.

Help?????

 

[Sue Mosher [MVP-Outlook]]

It is not possible to suppress the security prompts for this operation in
Office 2000. See http://www.slipstick.com/outlook/esecup.htm#autosec . You
may want to use a third-party mass mail utility instead. See
http://www.slipstick.com/addins/mail.htm#massmail

 

[BK]

Sue

Thank you for your answer although it was not what I had hoped for. <grin>
Surely I'm not the only one with large distribution lists that are not spam
! ! ! Does Office 2003 treat this issue any differently??

----------- Bonnie

 

[Sue Mosher [MVP-Outlook]]

The problem is that you have an old version of Outlook. Outlook 2002 and
2003 do not trigger security prompts from mail merges in HTML format.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[jim]

From my experience, Outlook 2003 treats this exactly the same as
Office 2000 (SR1 or above IIRC - earlier versions didn't have the
security code). What I have found is that, as long as Outlook is
sending it's emails out through an Exchange Server using the Exchange
service, you can use a security policy to remove the prompts from
specific machines/users.

http://office.microsoft.com/en-au/assistance/HA011524811033.aspx


Jim

 

[Sue Mosher [MVP-Outlook]]

Not if you use HTML format for the email message merge. No prompts in that
scenario.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[BK]

We are not using an Exchange Server, so I guess I am stuck with the security
prompt per email message.

 

[BK]

Sue

Interesting! This issue alone may make it worth upgrading to Outlook 2003.
Then I can send emails to a large distribution group using Word mail merge
with Excel data file. And you are saying that I won't have to manually
accept 380 separate security prompts to continue?

 

[Sue Mosher [MVP-Outlook]]

Yes, that's exactly what I'm saying. Mail merge to Word using HTML format
works with no security prompts.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Brian Tillman]

Interesting! This issue alone may make it worth upgrading to Outlook
2003.

Or save your money and download Express-ClickYes:
http://www.contextmagic.com/express-clickyes/