Without Outlook Running - can I execute a macro?

  • Thread starter Thread starter kim
  • Start date Start date
K

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
 
Outlook VBA macros work only when Outlook is running. Therefore, you need to
leave Outlook running.
 
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?
 
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
 
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.
 
Back
Top