Open specific emails in outlook based on subject name in cell value

**nate.oyen** · 02-18-2020, 06:55 PM

Can't seem to find any solutions on google.

I would like to open an outlook email that was created within excel, with specific subject names.

For example:

my named range "subject" has "Outgoing Inspection for PO#3452"
I want to search and open this email in outlook.

Anyone have a solution?

Thank you in advance!

**PaulSP8** · 02-19-2020, 08:37 AM

Try this;

Please Login or Register  to view this content.

I've used A1 as the Cell Reference for your subject, change to what you need it to be.

Please note you'll need to add the Outlook Object Library Reference in the VBE (Tools > References > Microsoft (xx.x) Object Libary (xx.x will change depending on your Excel version)).

**nate.oyen** · 02-20-2020, 04:28 PM

Thank You !~

Open specific emails in outlook based on subject name in cell value

LinkBack

Thread Tools

Rate This Thread

Display

Open specific emails in outlook based on subject name in cell value

Re: Open specific emails in outlook based on subject name in cell value

Re: Open specific emails in outlook based on subject name in cell value

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Outlook, rename subject of selected emails, VBA

Outlook, rename subject of selected emails, VBA

[SOLVED] Autoforward incoming emails with specific words in subject.

vba code to extract 5 sentences from outlook body to excel for emails that have subject li

Outlook - prevent sending of emails without a subject matter

[SOLVED] Search and Flag the Emails in Outlook based on the Data in Excel (Subject column)

Extracting data from all emails with a specific subject

Bookmarks

Bookmarks

Posting Permissions