Without Outlook Running - can I execute a macro?

[kim]

I currently have a macro doing exactly what I need it to do. It saves
a copy of an attachment to the harddrive in a specific folder.

a wsf script then executes hourly to import this data into a database.

All works fine as long as I am at the office with outlook running.

How can I make this happen over the weekend without leaving my outlook
running?

is it possible?


thank you in advance
Kim

 

[Sue Mosher [MVP]]

Outlook VBA macros work only when Outlook is running. Therefore, you need to
leave Outlook running.

 

[kimi]

Hi Sue, Thank you for replying.

I assumed this would be the case - so is there anyway to retrieve mail
and do what the macro is doing without doing it from witihn outlook?

 

[Sue Mosher [MVP]]

Since Outlook will not be downloading any mail unless it is running, no.
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Ken Slovak - [MVP - Outlook]]

PMFJI, but a CDO Session could be logged into and CDO code written to
replicate the macro and use the DeliverNow method to send/receive
email. If Outlook is secured and Session.DeliverNow was locked down
then after the CDO Session was instantiated Redemption's DeliverNow
could be used (www.dimastr.com/redemption). Not as straightforward as
using Outlook macros and Outlook object model code but doable.