Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Emailing | Excel Discussion (Misc queries) | |||
CDO emailing | Excel Programming | |||
save prompt for user exit, but no save prompt for batch import? | Excel Discussion (Misc queries) | |||
Emailing | Excel Discussion (Misc queries) | |||
emailing pdf | Excel Discussion (Misc queries) |