Outlook Mailo Items

Hi

I have to extract different parts of an email.

I have the subject and body so far using
sSubject = objMailItem.Subject
sBody = objMailItem.Body

How do I get the Author, To:, CC:, Sent Date items?

Is there a list of the items that make up each email?

Thanks

Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Patrick MatthewsConnect With a Mentor Commented:
Hi murbro,
> How do I get the Author, To:, CC:, Sent Date items?

objMailItem.SenderName
objMailItem.To
objMailItem.CC
objMailItem.SentOn

To see all the properties, open the VB Editor from Outlook, hit F1 to show the help file, and look for the entry on the
MailItem object.

Regards,

Patrick
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks Patrick
0
 
Patrick MatthewsCommented:
You're welcome :)
0
All Courses

From novice to tech pro — start learning today.