Mail Merge to Email Security Issue

[Sue Sweet]

I actually have two questions. I am using Office 2003

I am trying to merge to email using a Access 2003 query. It is actually a
query based on another query. I am not getting the results I want. Please
help

When I used a work around when the merge started, I got a message from MS
Outlook:

"A program is trying to automatically send e-mail on your behalf. Do you
want to allow this?

How do I stop this from coming up?

Each month I do a merge to email with hundreds of records (using email to
send reminders instead of snail mail -- more cost effective) I don't want to
have to choose YES 200 times for each merge.

Thank you

Sue Sweet

 

[Roady [MVP]]

I am not getting the results I want.
What are you doing exactly, which results do you get and which did you
expect?
Having issues with creating a query sounds more like a question for the
Access newsgroup than for the Outlook newsgroup.

When I used a work around when the merge started, I got a message from MS
Outlook:

Which Mail Merge method are you using? I assume that at one point you are
passing through Word for the mail merge. Both Word and Outlook addins could
cause the security message to pop up. If you are using a script in Access to
sent the merge, depending on how you've written the script, you could end up
with security prompts as well.

Disabling the interfering addins or updating them could solve your issue.
See http://www.msoutlook.info/question/88

If you are having issues locating the source of the prompts, then this free
addin might help you as well;
http://addins.howto-outlook.com/mapilab_security