Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sending email within a macro
In my endless quest to automate my personal files, I'm
trying to have a macro email my cells in the body of an email. I've done this using the ActiveWorkbook.SendMail recipients:="Jean Selva" vb command. Works great, just as I wanted. The only problem is that it STILL prompts for user input. A warning pops up saying that a program is automatically sending email on my behalf. I must then wait 5 seconds and press "yes." How can I get rid of this warning. I haven't been able to take vacation time because the data I send out is critical, and I'm trying to get this stuff automated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
sending email within a macro
I tested this and it worked in a macro of mine without any
prompt. Try this: Application.DisplayAlerts = False ActiveWorkbook.SendMail " Application.DisplayAlerts = True -IA -----Original Message----- In my endless quest to automate my personal files, I'm trying to have a macro email my cells in the body of an email. I've done this using the ActiveWorkbook.SendMail recipients:="Jean Selva" vb command. Works great, just as I wanted. The only problem is that it STILL prompts for user input. A warning pops up saying that a program is automatically sending email on my behalf. I must then wait 5 seconds and press "yes." How can I get rid of this warning. I haven't been able to take vacation time because the data I send out is critical, and I'm trying to get this stuff automated. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
sending email within a macro
This is part of the Security patch for outlook and can't be turned off.
You can get a dll called redemption I believe http://www.dimastr.com/redemption/home.htm but this probably requires programming Outlook Another way is to use CDO. Ron de Bruin has information on this: http://www.rondebruin.nl/index.html Again, this is more complex than SendMail. -- Regards, Tom Ogilvy Joe S. wrote in message ... In my endless quest to automate my personal files, I'm trying to have a macro email my cells in the body of an email. I've done this using the ActiveWorkbook.SendMail recipients:="Jean Selva" vb command. Works great, just as I wanted. The only problem is that it STILL prompts for user input. A warning pops up saying that a program is automatically sending email on my behalf. I must then wait 5 seconds and press "yes." How can I get rid of this warning. I haven't been able to take vacation time because the data I send out is critical, and I'm trying to get this stuff automated. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
sending email within a macro
Here is some additional information:
Information on the security patch http://www.slipstick.com/outlook/esecup.htm -- Regards, Tom Ogilvy Joe S. wrote in message ... In my endless quest to automate my personal files, I'm trying to have a macro email my cells in the body of an email. I've done this using the ActiveWorkbook.SendMail recipients:="Jean Selva" vb command. Works great, just as I wanted. The only problem is that it STILL prompts for user input. A warning pops up saying that a program is automatically sending email on my behalf. I must then wait 5 seconds and press "yes." How can I get rid of this warning. I haven't been able to take vacation time because the data I send out is critical, and I'm trying to get this stuff automated. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
sending email within a macro
Hi Joe
Read this also http://www.rondebruin.nl/sendmail.htm#Prevent If you use Outlook express you can turn it off -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "Tom Ogilvy" wrote in message ... This is part of the Security patch for outlook and can't be turned off. You can get a dll called redemption I believe http://www.dimastr.com/redemption/home.htm but this probably requires programming Outlook Another way is to use CDO. Ron de Bruin has information on this: http://www.rondebruin.nl/index.html Again, this is more complex than SendMail. -- Regards, Tom Ogilvy Joe S. wrote in message ... In my endless quest to automate my personal files, I'm trying to have a macro email my cells in the body of an email. I've done this using the ActiveWorkbook.SendMail recipients:="Jean Selva" vb command. Works great, just as I wanted. The only problem is that it STILL prompts for user input. A warning pops up saying that a program is automatically sending email on my behalf. I must then wait 5 seconds and press "yes." How can I get rid of this warning. I haven't been able to take vacation time because the data I send out is critical, and I'm trying to get this stuff automated. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
sending email within a macro
It actually appears to be a warning within Outlook 2003.
The .displayalerts didn't work on my machine. Are you running Outlook 2003? -----Original Message----- I tested this and it worked in a macro of mine without any prompt. Try this: Application.DisplayAlerts = False ActiveWorkbook.SendMail " Application.DisplayAlerts = True -IA -----Original Message----- In my endless quest to automate my personal files, I'm trying to have a macro email my cells in the body of an email. I've done this using the ActiveWorkbook.SendMail recipients:="Jean Selva" vb command. Works great, just as I wanted. The only problem is that it STILL prompts for user input. A warning pops up saying that a program is automatically sending email on my behalf. I must then wait 5 seconds and press "yes." How can I get rid of this warning. I haven't been able to take vacation time because the data I send out is critical, and I'm trying to get this stuff automated. . . |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
sending email within a macro
I do not have Outlook running, I use a different mail
application. It looks like you already have some substantial suggestions from others to sink your teeth into, so I am going to let go on this topic. Glad you got the info. -IA -----Original Message----- It actually appears to be a warning within Outlook 2003. The .displayalerts didn't work on my machine. Are you running Outlook 2003? -----Original Message----- I tested this and it worked in a macro of mine without any prompt. Try this: Application.DisplayAlerts = False ActiveWorkbook.SendMail " Application.DisplayAlerts = True -IA -----Original Message----- In my endless quest to automate my personal files, I'm trying to have a macro email my cells in the body of an email. I've done this using the ActiveWorkbook.SendMail recipients:="Jean Selva" vb command. Works great, just as I wanted. The only problem is that it STILL prompts for user input. A warning pops up saying that a program is automatically sending email on my behalf. I must then wait 5 seconds and press "yes." How can I get rid of this warning. I haven't been able to take vacation time because the data I send out is critical, and I'm trying to get this stuff automated. . . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sending email to several contacts? | Excel Discussion (Misc queries) | |||
Sending a Spreadsheet as an Email Attachment vs. Imbedded in Email | Excel Discussion (Misc queries) | |||
Sending an email with Excel macro | Excel Discussion (Misc queries) | |||
Sending Email through a macro | Excel Worksheet Functions | |||
Email sending | Excel Discussion (Misc queries) |