Prompt box when emailing via VBA

[Chad]

I am sending an email using VBA code. There are no issues with the code,
except if I use .Send then I get a prompt box to answer "yes, i'm aware of
this" action. Is there any way to avoid this prompt? I have many emails to
send via a loop and don't want to have to click yes for each email being sent.

Thanks in advance,
Chad

 

[crferguson]

I am sending an email using VBA code. There are no issues with the code,
except if I use .Send then I get a prompt box to answer "yes, i'm aware of
this" action. Is there any way to avoid this prompt? I have many emails to
send via a loop and don't want to have to click yes for each email being sent.

Thanks in advance,
Chad

To save Ron a post, here's a link to what can fix your problem. I
created an emailing class using his handy code and it works perfectly
without prompts whereas using the Outlook object (for example) prompts
the user for each email:

http://www.rondebruin.nl/sendmail.htm

Thanks Ron! Your code has saved me tons of time and effort!

Cory

 

[Les]

Hi Chad, you can also go to this site. I use it and it is great.

http://www.contextmagic.com/

 

[Chad]

I have seen Ron's post on doing this with CDO; however, the only way that
seems to work is to use the gmail approach and I don't have a gmail account
to use and I'd like the "from" in the email to come from a specific email
address. Is there a work around for Ron's work or another option? Thanks,

-Chad

 

[Ron de Bruin]

A GMail account is free

Have you try one of the other suggestions
http://www.rondebruin.nl/mail/prevent.htm