Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email from Excel; MS warning "program is trying to send mail on your behalf"
Using Excel 2003 and Outlook 2003
I just tested code from http://rondebruin.nl/mail/folder3/smallmessage.htm in my workbook; while I don't have it fully tweaked to meet my needs (more on that below) the first problem I ran into is that it pops up a message window that says "program is trying to send email on your behalf; do you want this" with a progress bar (I'm not sure if the progress bar is a delay in which to respond, or if it is tracking other stuff going on in the background, like Outlook still opening in the background). The user then has to click "yes" to send the mail. My workbook is a tracking log for our company, with various pieces of product and their status- who is responsible for what, and when. Right now, these people are called or emailed manually based on the information in the workbook, so I offered to try to help automate the process by just sending emails automatically based on information uploaded into the workbook from other data sources. Having the user respond to these email prompts isn't as efficient as I'd like, when my goal is to automate. I understand the reason for this warning (to keep a hostile macro from sending email or spam without your knowledge) but is there any way with a self-cert or other method for Excel/Outlook to recognize that you are doing this intentionally, and not give the warning? When the macro is run weekly, this could be dozens of emails. My less desirable alternative (because it would be a bunch more code) would be to save all my email messages to a text file, then trigger an outlook macro to open that file and cycle through and send out the emails. The other question I have, if anyone knows- does the code on Ron's page require a full email address, or is there anything I can do to resolve internal email by UserID? When I type my UserID in Outlook it knows who to send it to, but so far I haven't gotten this code from Ron's page to do the same. Not sure if I can use UserID via VBA, or if I am stuck with a full address (myName at company.com). I have everyone's userID in my workbook, but not their external email addresses. Thanks! Keith -- The enclosed questions or comments are entirely mine and don't represent the thoughts, views, or policy of my employer. Any errors or omissions are my own. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email from Excel; MS warning "program is trying to send mail on your behalf"
Hi KR
See http://www.rondebruin.nl/mail/prevent.htm I don't know about the UserID -- Regards Ron de Bruin http://www.rondebruin.nl "KR" wrote in message ... Using Excel 2003 and Outlook 2003 I just tested code from http://rondebruin.nl/mail/folder3/smallmessage.htm in my workbook; while I don't have it fully tweaked to meet my needs (more on that below) the first problem I ran into is that it pops up a message window that says "program is trying to send email on your behalf; do you want this" with a progress bar (I'm not sure if the progress bar is a delay in which to respond, or if it is tracking other stuff going on in the background, like Outlook still opening in the background). The user then has to click "yes" to send the mail. My workbook is a tracking log for our company, with various pieces of product and their status- who is responsible for what, and when. Right now, these people are called or emailed manually based on the information in the workbook, so I offered to try to help automate the process by just sending emails automatically based on information uploaded into the workbook from other data sources. Having the user respond to these email prompts isn't as efficient as I'd like, when my goal is to automate. I understand the reason for this warning (to keep a hostile macro from sending email or spam without your knowledge) but is there any way with a self-cert or other method for Excel/Outlook to recognize that you are doing this intentionally, and not give the warning? When the macro is run weekly, this could be dozens of emails. My less desirable alternative (because it would be a bunch more code) would be to save all my email messages to a text file, then trigger an outlook macro to open that file and cycle through and send out the emails. The other question I have, if anyone knows- does the code on Ron's page require a full email address, or is there anything I can do to resolve internal email by UserID? When I type my UserID in Outlook it knows who to send it to, but so far I haven't gotten this code from Ron's page to do the same. Not sure if I can use UserID via VBA, or if I am stuck with a full address (myName at company.com). I have everyone's userID in my workbook, but not their external email addresses. Thanks! Keith -- The enclosed questions or comments are entirely mine and don't represent the thoughts, views, or policy of my employer. Any errors or omissions are my own. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email from Excel; MS warning "program is trying to send mail on your behalf"
Ron- thanks for the tip on the warning message. I'll keep playing with the
UserID and see if I can figure anything out. -and as always, thanks for your contributions to this group and via your site. Best, Keith "Ron de Bruin" wrote in message ... Hi KR See http://www.rondebruin.nl/mail/prevent.htm I don't know about the UserID -- Regards Ron de Bruin http://www.rondebruin.nl "KR" wrote in message ... Using Excel 2003 and Outlook 2003 I just tested code from http://rondebruin.nl/mail/folder3/smallmessage.htm in my workbook; while I don't have it fully tweaked to meet my needs (more on that below) the first problem I ran into is that it pops up a message window that says "program is trying to send email on your behalf; do you want this" with a progress bar (I'm not sure if the progress bar is a delay in which to respond, or if it is tracking other stuff going on in the background, like Outlook still opening in the background). The user then has to click "yes" to send the mail. My workbook is a tracking log for our company, with various pieces of product and their status- who is responsible for what, and when. Right now, these people are called or emailed manually based on the information in the workbook, so I offered to try to help automate the process by just sending emails automatically based on information uploaded into the workbook from other data sources. Having the user respond to these email prompts isn't as efficient as I'd like, when my goal is to automate. I understand the reason for this warning (to keep a hostile macro from sending email or spam without your knowledge) but is there any way with a self-cert or other method for Excel/Outlook to recognize that you are doing this intentionally, and not give the warning? When the macro is run weekly, this could be dozens of emails. My less desirable alternative (because it would be a bunch more code) would be to save all my email messages to a text file, then trigger an outlook macro to open that file and cycle through and send out the emails. The other question I have, if anyone knows- does the code on Ron's page require a full email address, or is there anything I can do to resolve internal email by UserID? When I type my UserID in Outlook it knows who to send it to, but so far I haven't gotten this code from Ron's page to do the same. Not sure if I can use UserID via VBA, or if I am stuck with a full address (myName at company.com). I have everyone's userID in my workbook, but not their external email addresses. Thanks! Keith -- The enclosed questions or comments are entirely mine and don't represent the thoughts, views, or policy of my employer. Any errors or omissions are my own. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel hangs after using "Send to mail recipient (as attachment) " | Excel Discussion (Misc queries) | |||
"Excel could not start the e-mail program" in Excel _2003_ | Excel Discussion (Misc queries) | |||
Using 2007 Office EXCEL or WORD "SEND" Results in General Mail Fai | Excel Discussion (Misc queries) | |||
Signature missing when "send to" "mail recipient" | Excel Discussion (Misc queries) | |||
Can you set a "trigger" in excel to send an email? | Excel Worksheet Functions |