Outlook security with FoxPro automation

[SteveBoard]

I'm using Visual Foxpro to create email messages to people in a database table. About 60 or 70 messages will be created and put in the Outlook 2000 outbox.

I'm getting a prompt with each message asking permission to write the message (virus warning). Each one I answer Yes.

What security feature in Outlook controls this? or can I programmatically control it in VFP? I've turned my security to low. Before I put through an update to Office 2000 (Service Pack 1 or 2 I think) this was not a problem; now it slows down my automated procedure with one-by-one Yes permissions to the prompt.

 

[Mike Gagnon]

SteveBoard

There are a couple of ways to bypass the security patch of Outlook.
[ol][li]On you Microsoft Office cd there is a seperate install of CDO (Collaboration data objects). Which will install a couple of DLLs. From there you can automate your e-mail sending via this CDO which bypasses the security patch.

oMSG = CREATEOBJECT("cdo.message")
oMSG = createobject("CDO.Message")
oMSG.To = "me@nowhere.com"
oMSG.From = "you@anywhare.net"
oMSG.Subject = "Hello Email"
oMSG.TextBody = "This is an easy way to create an email"
oMSG.Send()

There are other things you can do with it, as shown in faq184-1768[/li]
[li]There is also the Redemption solution (written by Dmitry Streblechenko), that bypasses the security patch.

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

[/li][ol]



Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[SteveBoard]

Thanks for your help on my Outlook & VFP automation.

I see the CDO.DLL on my hard disk but find no install feature for it on the Office disk. So I have not made progress in the way you suggest.

I just upgraded to Windows XP, so maybe there is some relief there.

Steve Board

 

[Mike Gagnon]

I see the CDO.DLL on my hard disk but find no install feature for it on the Office disk. So I have not made progress in the way you suggest.

You may want to do a keyword search in the Visual FoxPro 3.0 and higher area of this site for CDO issues, like this one :
thread184-424900 Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.