[Graham Mayor]

You need the 'click yes' utilty which you can download, among other places,
from my web site http://www.gmayor.com/downloads.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Postal Methods wrote:
Before you send the merge, select a different email client as the
default client (Outlook Express, Thunderbird, etc.). The security
message is generated by Outlook. Outlook Express just asks once and
allows to cancel future messages.



SueSwee wrote:

Mail merge using Access Query
09-Jan-09

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

Previous Posts In This Thread:

On Friday, January 09, 2009 4:34 PM
SueSwee wrote:

Mail merge using Access Query
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

On Sunday, January 11, 2009 2:14 AM
Graham Mayor wrote:

Use the ClickYes utility (you can download it from my web site) to by
pass the
Use the ClickYes utility (you can download it from my web site) to by
pass
the message.


I am trying to merge to email using a Access 2003 query.
actually a
Please

Can you
a. provide the SQL text of the 2 queries
b. say what is going wrong

Peter Jamieson

http://tips.pjmsn.me.uk

Sue Sweet wrote:

EggHeadCafe - Software Developer Portal of Choice
Get Identity Values of Multi-row insert by using OUTPUT Clause
http://www.eggheadcafe.com/tutorials...ues-of-mu.aspx