MailMerge setting off Securty Dialog

[dayv2005]

Im programming an add in for word to programmatically do the mail merge. But
i have all the code that sends it but then when i set it up to email like
this....

/* Merge properties */
ASSIGN
chTemplate:MailMerge:MailAsAttachment = FALSE
chTemplate:MailMergeestination = 0
chTemplate:MailMerge:MailAddressFieldName = "Email"
chTemplate:MailMerge:MailSubject = "Test"
chTemplate:MailMergeestination = 2
chTemplate:MailMerge:MailFormat = 1.

For some reason the securty access dialog keeps comming up. I have
redemption but dont know how to use it here. and i dont know why its doing
this or how to get around it

 

[Doug Robbins - Word MVP]

If by Security Dialog, you mean the following message:

"Opening This Will Run the Following SQL Command" then see the following
Knowledge Base Article:

http://support.microsoft.com?kbid=825765


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[dayv2005]

not that but this is what im getting.

there is a porgram that is accessing you email information in outlook. Do
you give them permission? then it's like for how long 1 - 2 - 5 - 10 minutes?

 

[Peter Jamieson]

You can consider the ClickYes utility:

http://www.contextmagic.com/express-clickyes/

(there may be others).

I'm not sure there is any way you can use redemption to help you here as
Word itself does all the work of sending the e-mail and you can't intercept
its code. However, you can consider "rolling your own" merge to e-mail and
you may be in a position to use redemption then.