+ Reply to Thread
Results 1 to 4 of 4

Download Excel Workbooks linked in Outlook Body URL

  1. #1
    Registered User
    Join Date
    01-09-2019
    Location
    Utah, USA
    MS-Off Ver
    o365
    Posts
    2

    Download Excel Workbooks linked in Outlook Body URL

    I've been trying to get this to work since Monday and have seen some amazing results come out of this community - planning to learn from this.
    The goal is to download the Excel workbook linked within the body of the e-mail to a specific folder to be processed in Excel. The Excel part is complete, but this first portion of transferring the data is not.
    The code below works until the comment line "Crashed from here on down"; I'm able to loop through the e-mails and flag them, so I know it works until that point. Please help

    P.S. I had to change the actual e-mail to "sender" in the line below as it picked it up as a URL and prevented my post
    If obj.SenderEmailAddress = "sender" Then

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    02-06-2014
    Location
    N/A
    MS-Off Ver
    N/A
    Posts
    373

    Re: Download Excel Workbooks linked in Outlook Body URL

    After the code below,
    Please Login or Register  to view this content.
    if you add
    Please Login or Register  to view this content.
    do you get the correct URL?

    Does
    Please Login or Register  to view this content.
    function work independently? Try to download one file as a test? Could be a network layer issue.

  3. #3
    Registered User
    Join Date
    01-09-2019
    Location
    Utah, USA
    MS-Off Ver
    o365
    Posts
    2

    Re: Download Excel Workbooks linked in Outlook Body URL

    Thanks for the quick reply.
    I tried the MsgBox function and it displays a blank box - appears Hyperlink is not picking up the URL
    The e-mail being scanned has the URL towards the top and is summarized in a caption, e.g. "Report A"

    How can I get it to pick up the actual Address behind the "Report A" Hyperlink? adding the .Address to the below did not work

    Please Login or Register  to view this content.
    Last edited by ceqiu; 01-09-2019 at 01:14 PM.

  4. #4
    Valued Forum Contributor
    Join Date
    02-06-2014
    Location
    N/A
    MS-Off Ver
    N/A
    Posts
    373

    Re: Download Excel Workbooks linked in Outlook Body URL

    Hi,

    I think because you are referencing the string text shown in the e-mail body as plain text, you are not getting the HTML behind the body.

    I think if you change

    Please Login or Register  to view this content.
    to

    Please Login or Register  to view this content.
    You should be able to parse the "href" part of the hyperlink and build your string

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. outlook to excel body of information
    By bruno2580 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 01-14-2018, 10:20 AM
  2. Download Excel attachment from Outlook
    By E5254730 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-28-2017, 09:08 AM
  3. [SOLVED] Copy URL from Excel to Outlook body
    By Southernw2002 in forum Outlook Formatting & Functions
    Replies: 3
    Last Post: 05-17-2014, 06:26 PM
  4. [SOLVED] Outlook Email with Body from Excel
    By dreicer_Jarr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2013, 03:57 AM
  5. Body of outlook message to Excel
    By dougmorgan in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 05-19-2013, 09:11 AM
  6. Outlook Email Body to Excel
    By Sciortmj in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-14-2012, 02:10 PM
  7. import MS Outlook body into Excel
    By wfdude in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2011, 10:14 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1