Sending Outlook Email From VB

I am sending emails to people who are registered on my website.  I have written a program using VB 6.0 that sends the email for me.  When I run the program, a prompt comes up from Outlook saying (in so may words) that a program is trying to send email, do you want to allow this?  

This prompt comes up everytime.  I figure there has to be a way to either say yes to the prompt in code so I am not having to sit here forever and say yes to the prompt for each registered person in my mail list, or turn this feature off.  I am running Outlook 2000 on Win XP and I also have Norton anti-virus 2003.  Any ideas would be greatly appreciated.
jenniferd732Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Éric MoreauSenior .Net ConsultantCommented:
This feature is to prevent that applications send e-mails without the user being warned. You can use ExpressClickYes to auto-click the message : http://www.express-soft.com/mailmate/clickyes.html

Better use a SMTP e-mailer like http://www.freevbcode.com/ShowCode.Asp?ID=109
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
nishikanthCommented:
Might be due to object model guard

http://www.slipstick.com/outlook/esecup.htm#autosec
0
nishikanthCommented:
also this
0
puneeshCommented:
You must be storing E-Mail addresses of people who register onto your site. If the database of yours is Oracle or SQL Server, mails can be generated directly from database server. Oracle and SQL Server uses SMTP directly bypassing Outlook.

Let me know if u want help on the same
0
jenniferd732Author Commented:
I have sent email that is stored on SQL server using SMTP.  This situation is a little different.  I get the addresses from a data dump on the web server (mySQL database).  I wrote a program that reads in the data, creates the contacts in Outlook, and adds them a distribution list.  I then setup the email and the emails are then sent out one at a time.  The list of registered people is getting bigger and bigger making the program kind of useless because I have to sit there and click "yes" everytime.  I am getting ready to send another batch out in a few days so I am going to try to use the "click yes" utility from express-soft.  If you have any other ideas or know a way around this in mySQL that would be great too.  That would eliminated the need for the program all together.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.