Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19
  1. #16
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,264
    I' m not sure what he wants to do now TBH😔
    It would be easier enough to show what the link contains and post that, rather than the link?

  2. #17
    DMT Dave is offline VIP
    Windows 10 Access 2016
    Join Date
    May 2018
    Posts
    1,329
    Hi Vlad, yes, this a slightly different project than welshgasmans version of saving attachments, the saving attachments that welshgasman displayed how to achieve was fantastic, thats working great but on another project, totally different events but with similarities to saving email items is we receive images where a client can upload to our web server, this comes up as a link called open file (if 6 files the it will say open file on each upload, so i was wondering if it's easy to follow that link called (Open File) via vba and save the images from the link to a temp folder and use follow hyperlink from vba to open all 6 images or 4 images or however many have been uploaded to that email

    Hope this all makes sense, so welshgasman file attachment saving works great but this is a different project but again its about saving from mail item

  3. #18
    DMT Dave is offline VIP
    Windows 10 Access 2016
    Join Date
    May 2018
    Posts
    1,329
    thank you guys once again, just checking the links out you sent, im going play around with that and give it a go

    Kindest

  4. #19
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,235
    Yes, that is what I thought you meant. So my comments should provide you a place to start. You need to save the body of the email in a string variable, use Mid with InStr to isolate the part containing the links (Mid(strEmailBody,Instr("Photo Upload 1:")....use Split to get an array then loop and get the individual paths. Using one of the functions in the links I posted earlier would get your files downloaded; you cannot use FollowHyperlink as that would just open the files in whatever default application you have and automating third party apps is quite difficult as it will involve API calls and the like.
    If you get stuck maybe you can post a sample email with the exact wording and links.

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 08-08-2019, 11:03 AM
  2. Saving attachment to folder
    By ino_mart in forum Programming
    Replies: 3
    Last Post: 10-29-2015, 07:53 AM
  3. Replies: 4
    Last Post: 03-11-2015, 12:01 PM
  4. Replies: 13
    Last Post: 03-25-2013, 02:04 PM
  5. Replies: 2
    Last Post: 04-26-2012, 02:55 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums