Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Programming VBA / July 2005

Tip: Looking for answers? Try searching our database.

Picking Up E-MAil Details

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
teresa - 27 Jul 2005 13:32 GMT
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
Ken Slovak - [MVP - Outlook] - 27 Jul 2005 14:31 GMT
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.

Signature

Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm

> Hi,
>
[quoted text clipped - 6 lines]
>
> Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.