Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I found some code online that I'm trying to modify for my needs. We are
using Outlook & Excel 2003 and I'm trying to have Excel send a message without any user interaction. I'm trying to get around the "virus warning" notification and they wont allow us to install any 3rd party apps. Here is a sample of the code. With OutMail .To = " .CC = "" .BCC = "" .Subject = "Daily Run is Complete" .Body = strbody .Send ' virus msg pops up after this line Application.Wait (Now + TimeValue("0:00:04")) Application.SendKeys "{TAB}{TAB}", True ' Application.SendKeys "{LEFT}", True Application.SendKeys "{ENTER}", True End With I don't know if I have the correct syntax for the send keys, but I'm trying to wait 4 seconds for the "Yes" option to become available, then either hit the left arrow once or the tab key twice before hitting Enter. The problem is that the VBA code doesn't continue processing anything after the ".Send" line while that dialog box is up. Is there anyway around this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to remove the outlook confirm window when use excel to send email from outlook? | Excel Programming | |||
send email macro with Outlook running | Excel Programming | |||
How to send a single page email from excel 2000 using outlook xp | Excel Worksheet Functions | |||
Send an email attachment (pdf file) from Excel 2003 using Outlook Express | Excel Programming | |||
***** PLEASE HELP **** Send an email from Excel to outlook with an automatic macro | Excel Discussion (Misc queries) |