Prompt box when emailing via VBA
 

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

Prompt box when emailing via VBA
 

On Dec 11, 11:56 am, Chad wrote:
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

Prompt box when emailing via VBA
 

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

http://www.contextmagic.com/
--
Les


" wrote:

On Dec 11, 11:56 am, Chad wrote:
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

Prompt box when emailing via VBA
 

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


" wrote:

On Dec 11, 11:56 am, Chad wrote:
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

Prompt box when emailing via VBA
 

A GMail account is free

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Chad" wrote in message ...
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


" wrote:

On Dec 11, 11:56 am, Chad wrote:
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