Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to run this subroutine from an Excel Macro in a Scheduled job.
Private Sub SendMessage() Dim OutApp As Object Dim OutMail As Object 'ToStr, Subject and strBody are globals in the Excel VB Module. Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(0) With OutMail .To = ToStr .CC = "xxx@yyy" 'Real address obscured here. .BCC = "" .Subject = Subject .Body = strbody .Send End With End Sub It works perfectly when triggered by opening the spreadsheet which has an auto run macro which invokes the code. Either manually from Excel or by running the Command Line "C:\Program Files\Microsoft Office\Office12\Excel.exe" /r "C:\Users\Alan\Documents\HSC\Fence Check\Fence Check Auto Run.xlsm" Normally the scheduled task that runs the same code (there is a bit more to it) runs perfectly but when it hits the above it is failing and as a result screwing up the scheduled job which then fails to complete and subsequently will not run until after a reboot and re-registering the task. Can anybody help or suggest a workaround. P.S. I always have Outlook Open on my Desktop and I hate having to late bind the Objects in this code. (Also posted in Outlook and Developer discussions but not got much response.) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Send Mail - Code to test whether Lotus Notes / Outlook is used | Excel Programming | |||
How can I use Outlook express to send mail rather than Outlook by VBA code | Excel Programming | |||
How can I use Outlook express to send mail rather than Outlook by VBA code | Excel Programming | |||
Running an Excel Macro as a Scheduled Task | Excel Programming | |||
loop trough e-mail address list to send task lists with outlook | Excel Discussion (Misc queries) |