Consulting

Results 1 to 2 of 2

Thread: Download File in Hyperlink placed in Body Email and save to Spesific folder

  1. #1
    VBAX Newbie
    Joined
    Sep 2019
    Posts
    1
    Location

    Download File in Hyperlink placed in Body Email and save to Spesific folder

    Hi Guys,

    I am very new to VBA and still learning by browsing, please kindly help on this

    Everyday I received an email which has hyperlink in it. The hyperlink is quite long so that it makes multiple line in the body email

    Instead of clicking on it and download the file everyday, I intend to create a vba put in outlook which can detect this email by the subject, click on that hyperlink in the email body, download the file and put it in specific folder

    I have tried so many vba code by browsing, but no one can work properly, that's why I not able to shared my code here

    I attach the email screenshot
    outlook_t.jpg

    Thanks a lot
    Attached Images Attached Images

  2. #2
    For someone new to VBA, you picked a difficult area of coding to start with, and you have made it almost impossible for anyone to help by not posting a working link. I can however understand why that might not be advisable in a public forum.

    What EXACTLY happens when you click that link?
    What is the filename of the report? Is it the same filename each time?

    If clicking the link downloads the named file without further user involvement, it should be possible to achieve this easily enough. If not, it may not be so simple.
    Graham Mayor - MS MVP (Word) 2002-2019
    Visit my web site for more programming tips and ready made processes
    http://www.gmayor.com

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •