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. |
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) |