Creating Table for Thousands of Emails

[Esquireron]

I have thousands of emails that i need to index by the typical header fields: To, From, Sent, Cc, Bcc, Subject and Date.

They're all in Excel, I need some help creating columns next to each email header. The columns will correspond to the header fields. The text must be extracted from the email headers, into the columns.

I tried to use If and Search functions. I ran into a wall. Any help would be appreciated. Even a screen share is possible if someone has time.

Thanks.

Ron

 

[Marcílio_Lobão]

Esquireron, Good afternoon.

We need to know about the layout of your Excel file to try to help you.

Save a small example of your file at a free sitewww.sendspace.com and put a link here to download.

It will be easier for us to help you.

 

[Esquireron]

Thank you, Marcilio. The site asks me for sender and recipient. I can put in my email as sender. What do I use for recipient?

 

[Marcílio_Lobão]

Esquireron, Good afternoon.

It's so simple.

• At initial page, click at Blue button BROWSE
• Select your file,
• Click at Blue button UPLOAD

• At new page look for a Download Page Link.
• Copy link.
• Paste it here at your post.

Only this.
Nothing more.

I hope it helps.