Picking Up E-MAil Details

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm trying to write a macro within a spreadsheet which picks up details
whenever a mail is sent to any of my Folders (Microsoft Outlook)

So my Columns are:

From Subject Time

Thanks
 
To trap when a new item is delivered or sent you would need to be running an
ItemAdd and/or Application.Send event handler. That would give you an
immediate event.

Or you could iterate all teh folders you are interested in and maintain a
list of items for each folder. At intervals you would then iterate the
folders again to see what's new.

You don't mention your knowledge of programming Outlook or which version of
Office you're using but you might want to start out by looking at
www.outlookcode.com for lots of sample Outlook code.
 
Back
Top