Scheduled Task Doesn't work with Outlook 2007

Status
Not open for further replies.
C

CaptainBly

I have a small Access application that runs, initiates an instance of

Outlook, creates necessary emails, and exits. This is running on a

server as a scheduled task.

This worked fine with Outlook 2003. Client did a server upgrade and

upgraded to Outlook 2007. Now this task fails. If Outlook is open,

it runs fine but it fails if outlook is closed.

Is there a way to do this in Outlook 2007 without having Outlook open?

Any help is greatly appreciated.

Here is snippets of the code. It bombs on the recipients.add line.

If Outlook is open though, it runs without issue. Just not super

practical on a server with a scheduled task.

Set olookApp = New Outlook.Application

> .

> . some other unrelated code here, setting up a while loop etc...

> .

emailto = artsenddetail![emailaddress]

Set olookMsg = olookApp.CreateItem(olMailItem)

With olookMsg

Set olookRecipient = .Recipients.Add(emailto)

olookRecipient.Type = olTo

> Subject = "Art Verification - Project: " & artsend!

[BudgetNum] & " " & artsend![BudgetName]

> Body = control![ArtVerifyBody] & newline & newline &

standardclosing

If Not (IsNull(control![CompanyEmail])) Then

> ReplyRecipients.Add (control![CompanyEmail])

End If

Set olookAttach = olookMsg.Attachments.Add(filenamedest)

olookMsg.Send

End With
 
Further information... The error I get is 287 - Application-defined

or object-defined error
 
Status
Not open for further replies.
< Outlook 2007 Meeting Item Send Button | separate signatures for different accounts >
Similar threads
Thread starter Title Forum Replies Date
M Running Outlook as Scheduled task Outlook VBA and Custom Forms 1
O Scheduled Task Fails running Code to send Outlook Mail from Excel. Outlook VBA and Custom Forms 9
Fozzie Bear Shared Calendar For Scheduled Tasks Using Outlook.com accounts in Outlook 3
V Scheduled backup of imap account Using Outlook 7
T Scheduled footer change Using Outlook 2
S Scheduled backup for BCM Database Tool BCM (Business Contact Manager) 1
C How do you add an attendee to a already scheduled meeting? Using Outlook 3
S Create Outlook Task from Template and append Body with Email Body Outlook VBA and Custom Forms 4
D Copy Appointment Body to Task Body Outlook VBA and Custom Forms 0
K Daily Task List Minimized Cannot Display Using Outlook 5
wayneame Changing the Form Used by Existing Task Items in a Folder Outlook VBA and Custom Forms 4
S Outlook 2016 Understand and customize prepended behavior of recurring task Using Outlook 0
B Outlook 365 Populate Outlook Task UDFs from a UDF text string Outlook VBA and Custom Forms 2
K Multiple copies of task being created Using Outlook 2
P Short Date Format when typing in a task Using Outlook 2
C Outlook 2013 Task Recurrence - Third Friday After the Second Tuesday Using Outlook 2
P Task display now leaves little room for notes Using Outlook 10
C-S-R How to clear an Outlook (To Do) Task Flag? Using Outlook 8
G Event when creating task from mailitem Outlook VBA and Custom Forms 2
P Changing the font that the task view shows Using Outlook 5
D How To Combine Share Task Folders in just one Folder Using Outlook 0
P Can I create a Rule that sends me an email when I get a Task? Using Outlook 2
G Arggh, weakness of reminder for every Task recurrence Using Outlook 0
P Can't paste an image into a task Using Outlook 3
F Validation on custom task form after task acceptance Outlook VBA and Custom Forms 1
J Office 365 erased all of my task views Using Outlook 3
T Report For Task Recurrance Outlook VBA and Custom Forms 4
E Can't accept or decline task (no button appears) Using Outlook 2
Z VBA to convert email to task, insert text of email in task notes, and attach copy of original email Outlook VBA and Custom Forms 4
Z Task Filter Not Working When I add too many criteria Using Outlook 0
X If you change expiration date of repeated task it dupplicates Using Outlook 1
Z How to show concatenated categories in list task view? Using Outlook 2
Z VBA to Collapse Task Folder Groups Outlook VBA and Custom Forms 1
E To convert imported data to custom fields in Task list Outlook VBA and Custom Forms 1
I Help with dates in task list. Using Outlook 5
Y Outlook Task View - Table Format - Customize Reminder Time to Drop-Down Selection Using Outlook 2
M Daily Task List Minimized Cannot Display Using Outlook 2
D Using a VBA Custom Form to Send Reoccurring Email Upon Task Completion Outlook VBA and Custom Forms 4
P Add a contact to the New Task in Outlook 2016 Using Outlook 2
S Codes for "Mark Complete" the task Outlook VBA and Custom Forms 2
W Deleting Sent Task Email, Deletes the task from my list Using Outlook 1
K Task priority modification Using Outlook 4
F Search folder for tasks in all task folders Using Outlook 1
JohnViuf Export task list view settings to other pc Outlook VBA and Custom Forms 16
V Changing default date for task follow-up buttons Using Outlook 2
K outlook workflow: automated task generation Outlook VBA and Custom Forms 4
U HTML Task Alternate Home Page View Control Using Outlook 3
F How to assign a task to a public task folder? Using Outlook 1
J Marketing task MS BCM BCM (Business Contact Manager) 10
copperberry How to view all tasks across task folders Using Outlook 3

Similar threads

Back
Top