Develop VBA macro to download HTML hyperlinks from Outlook mails

Hi there, I am using outlook as default email client. As a routine I receive specific system generated mail (with HTML body) which may contain a hyperlink (sometimes hyperlink can be broken) of a PDF document. I need a macro that can open that hyperlink and save PDF document with specific name as per email subject (i.e. [url removed, login to view]). Once download is completed macro should mark that email as read.

Macro should work within excel as I want to keep track of all files downloaded in a single record (Sr No, Email Title, Download Time, PDF File Name, Email Body), I will provide more details over a call once I finalize the developer.

Skills: Excel, Microsoft Outlook, VB.NET, Visual Basic

See more: vba code automatically forward incoming outlook message, vba macro text html, vba macro download historical stock quotes yahoo , outlook vba find hyperlink in body, excel vba download file from hyperlink, extract data from outlook email body, automatically open hyperlink in outlook, outlook vba open hyperlink, insert hyperlink in outlook using vba, outlook 2010 vba open hyperlink, vba open link in email, vba macro download data website, outlook 2003 vba save email html, outlook vba macro process mails, vba macro download historical stock quotes, excel vba macro download yahoo stock data, vba macro outlook, download html page using vba, extract html data outlook using vba, outlook vba macro creation task

Project ID: #16504593