Auto Copy Outlookfields into Excel

Hi All,

Thanks to all the members of this Forum for helping all the people, really appreciate your effort and time.

In a day i receive approx 500 mails in a day, I need to copy it and paste it on excel to capture outlook fields i.e. Sender, Subject, Date& Time, PFA the excel file for reference.

Can we autocopy these Outlook fields into excel on regular intervals.

Appreciate you reply on this mail.

I am sure that you can wrap your code in some sort of timing loop, but that means keeping the application open and running at all times. You might do better running the application under the windows task scheduler, You can specify a start time and then run every X hours or minutes thereafter.

Here's an article to get you started with the task scheduler. It's one of many ways to do it: http://www.utteraccess.com/wiki/inde...a_Macro_to_Run

Hi,


Will this copy outlook details into excel

One problem with the task scheduler is that it is generally ignorant of its environment. You have to do things like specify full path names instead of mapped drive names. It doesn't know where to find Excel, so you have to tell it that too. This is especially true if you are running tasks while the user is not logged in. However, if the user is logged in, it should work. I run a program on a computer that reads a mailbox and produces a report. It runs from the task scheduler on a machine that's left logged in. And, FYI, Outlook is installed on this machine, but is not launched.

I am not sure if the article makes this clear, but in the script make sure that the path to the Excel executable is correct for your version of Excel.