Outlook VBA - Get Details Of Current Active (Or Open) Email

vba outlook
Kezzer picture Kezzer · Feb 8, 2010 · Viewed 33.7k times · Source

I am completely stuck as to how to retrieve details of an email which is either currently selected or open. In fact, I can't find any details on how to access an email. It seems you can traverse the entire folder structure and get all emails, but that doesn't really help me.

I don't suppose I can get some pointers?

And yes, I hate VBA as much as the next developer, but unfortunately about 0.1% of my work involves integration with Outlook.

Cheers.

Answer

76mel picture 76mel · Feb 8, 2010

To get the currently selected emails by looking at the Selection object of the Explorer.

Dim myOlExp As Outlook.Explorer
Dim myOlSel As Outlook.Selection

Set myOlExp = Application.ActiveExplorer
Set myOlSel = myOlExp.Selection

The selection object can contain many items and also contain Items that are of other types than mail (IPM.Note) i.e calendar apps etc. So if you only want mail items you can take a look at the item MessageClass

As for the current email that is trickier as you can multuiple of these open if you just want the top most you can use the Application.ActiveInspector otherwise you should look at the Inspectors Collection of the Application object. You can then get the "item" from the CurrentItem property off the Inspector(remember these can be non mails as well)

Hope full that will get you going

Related questions

Save attachments to a folder and rename them

I'm trying to get a VBA macro in Outlook that will save an email's attachment to a specific folder and add the date received to the file name. My googling has gotten me this far: Public Sub saveAttachtoDisk (itm As …

Read More
How to add default signature in Outlook

I am writing a VBA script in Access that creates and auto-populates a few dozen emails. It's been smooth coding so far, but I'm new to Outlook. After creating the mailitem object, how do I add the default signature to …

Read More
How to copy Outlook mail message into excel using VBA or Macros

I'm a newbie in VBA and Macros. If someone helps me with VBA code and macros, it will be helpful. Daily I'll receive around 50-60 mails with one standard subject: "Task Completed". I have created a rule to all those …

Read More