VB code for emailing with Outlook 2003

Chris · Sep 10, 2005

Does anyone have an VB code for bypassing the yes no dialog when emailing
queries with Outlook 2003. I have a macro I run that emails 50 queries in
excel form every morning. With lotus notes this was fine, but switching to
outlook I have the annoying security box that pops up. I was thinking it was
possible to bypass with vb code

Thanks in advance for any suggestions

Debra Farnham · Sep 10, 2005

Hi Chris

I have the same annoying problem. I just came across this article which may
be of assistance (I haven't finished reading it yet).

Hope it helps

http://msdn.microsoft.com/office/de..._ta/html/odc_olSendEmailsProgrammatically.asp

Debra

Chris · Sep 10, 2005

thank you I will check it out.

Debra Farnham said:
Hi Chris

I have the same annoying problem. I just came across this article which
may
be of assistance (I haven't finished reading it yet).

Hope it helps

http://msdn.microsoft.com/office/de..._ta/html/odc_olSendEmailsProgrammatically.asp

Debra

Debra Farnham · Sep 10, 2005

Chris

I also found references to this site which may be of more benefit.

http://www.dimastr.com/redemption/

Debra

Chris · Sep 10, 2005

I just downloaded ClickYes a third part addin and it seems to work fine. I
can use it for my personal db's but the company I work for is fanatic about
any unauthorized software at all. I will keep looking. Thank you for your
help.