Reading Email Headers using VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nigel - 05 Jun 2005 11:18 GMT

From Excel I wish to choose a selected outlook folder and read the email
header information (from to subject etc) and create the list in an Excel
worksheet. Is this possible? If so how can I determine the list of
folders, whether they contain email items, and then access the details?
TIA

Signature

Cheers
Nigel

Reply to this Message

Michael Bauer - 07 Jun 2005 07:55 GMT

Hi Nigel,

all top folders are availabe via Application.Session.Folders. Each
folder in turn contains a folders collection (expect Searchfolders in
OL03).

You could check a folder´s DefaultItemType property but that´s no
guarantor for its content in fact. For getting a list of all MailItems
in a folder you could use the Items.Restrict function and search for
MessageClass="IPM.Note".

Signature

Viele Gruesse / Best regards
Michael Bauer - MVP Outlook

> From Excel I wish to choose a selected outlook folder and read the email
> header information (from to subject etc) and create the list in an Excel
> worksheet. Is this possible? If so how can I determine the list of
> folders, whether they contain email items, and then access the details?
> TIA

Reply to this Message

Nigel - 08 Jun 2005 20:16 GMT

many thanks

Signature

Cheers
Nigel

> Hi Nigel,
>
[quoted text clipped - 15 lines]
> details?
> > TIA

Reply to this Message