Log in

View Full Version : Solved: Autorun The macro



kbsudhir
12-03-2007, 01:44 PM
Hi All,

I have Two questions here.
I want to know -
1. Can we autorun a macro, every time Outlook in opened. I have already kept the security settings to low. If yes, then can someone tell me how..??
2. The same macro should continue to run till the outlook is closed. Provide some guidence on this also.


Sudhir :think:

TonyJollans
12-03-2007, 11:03 PM
There is an Application StartUp Event that you can use to run code at, well, Application Startup.

Not sure about point 2. If a macro is running you can't generally do much else. What are you trying to achieve?

kbsudhir
12-04-2007, 07:52 AM
I am capturing the mails coming to the inbox.i.e The subjet, from, flag status, and putting that data into an ecel sheet.

Right now I have to run the macro manually, then after every few minutes I am rerunning it manually to capture the new mails which has arrived.

I will try out your idea and let u know hoe it is working.

Thank for your help. :friends:
Sudhir

TonyJollans
12-04-2007, 09:40 AM
Why not use a Rule?