Outlook Email Fields from Excel

[eblake]

I am using a modified version of the code from this post to count emails in an Outlook folder
http://www.mrexcel.com/forum/showthread.php?t=293671

My problem is I can't seem to access the fields I need to get the data I need, Does anyone have some code that will list all the available fields in an email?

We have a couple of custom fields that I can't seem to access as well and i'm wondering if they might be named something other than what we see them as.

 

[jimrward]

what fields are you after from outlook

 

[eblake]

Sorry for the delay in getting back on this, boss dropped another project on me.

I just need the basic fields: DateTime Recvd, DateTime Replied, From, To, CC, BCC, Subject, Attachments

The boss wants me to look into a way to have outlook process all incoming emails to stick the information in a SQL table and build a web based front end for it. (Admins wont let me link SQL directly to exchange so it has to be client side)

From everything i've been reading and done in the past, this is possible I just need to figure out how to grab the field information. That's where i'm stuck. I can't seem to figure out the field names that vba wants me to use to get the information from the email.

Thanks

 

[jimrward]

Sub extractinfo()
'
' setup what we require
'
Dim msg As MailItem

Set olExp = Outlook.ActiveExplorer
Set olCurrentFolder = olExp.CurrentFolder
Set myOlSel = olExp.Selection

'
' Process each message selected
'
' just need the basic fields: DateTime Recvd, DateTime Replied, From, To, CC, BCC, Subject, Attachments

For Each msg In myOlSel
    mRTime = msg.ReceivedTime
    mBcc = msg.BCC
    mCC = msg.CC
    mTo = msg.To
    mFrom = msg.SenderEmailAddress
    mSubj = msg.Subject
'
'****
' if you start a line with say fred = msg.
' you will get a dropdown of available fields you can pull, attachments is a bit strange
' i will look out some code on home machine to do this
' you will have to decide how you store these like appending to a text file, delimited
' so that SQL or excel can import it
'****
'

    Set msg = Nothing
Next

End Sub

 

[jimrward]

by the way the code just posted is for Outlook VBA so it is driven from Outlook, you select which emails you want to process with the mouse then execute the macro