Develop VBA macro to download HTML hyperlinks from Outlook mails
₹600-1500 INR
In Progress
Posted about 6 years ago
₹600-1500 INR
Paid on delivery
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. [login to view URL]). 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.
I have excellent command on MS Excel and know how to integrate Excel with Outlook, access mails and save files through Excel. I have completed complex projects in Excel before . For instance
- Get match details, odds and stats of tennis matches and place bet automatically on betfair, pinnacle and tennisinsight websites
- Built a POS and inventory management system
- Built a hotel price comparison that pulls data using the website's API
- Built a complex shift allowance calendar and calculator
You can see the reviews of the same in my profile
Hello there, after reading your project description and with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office especially excel vba, i can do the best job in the least time starting right now. I will do all and extra to ensure that you won't regret giving me this project.
Please, message me and let us discuss more about your project.
Thanks
I am not a random bidder... Could you please ping me if you interested with my proposal and share more details about the emails.. share some sample emails to check.. Thank you..
Available Immediately | MS Excel Expert | MBA | Assured accuracy and minimum turnaround time | Outlook client experience | Please check my jobs history for the same.
hello! if i have been i would satisfy you with my contribution to the project
Relevant Skills and Experience
know vb, Excel,outlook,even can data entry
Namaste!
I am familiar with excel vba macro as I have been using it for my final year project. I am capable to complete the task in probably 1 to 3 days time, as I need to consider testing of the codes.
Here's a couple of questions for you:
1. Is the hyperlink used for the opening of online pdf document? Is that what you mean?
2. Can you provide me a sample of mail?
Anything can just contact me through chats, and inform me for details. Hope that I can learned from you and this project as I am still new to freelancer.com.
Thank you!