+ Reply to Thread
Results 1 to 3 of 3

pull 8 digit string (number) from the body of email

  1. #1
    Registered User
    Join Date
    07-27-2011
    Location
    Jacksonville, FL
    MS-Off Ver
    Excel 2003
    Posts
    3

    pull 8 digit string (number) from the body of email

    Have my emails populating into Excel rows and need assistance pulling a substring (8 digit number) out of the string(Column E - which is email body) placing in column F, then equipment into G. I think I need loop maybe?

    Have attached a picture of the workbook's data I am working with.

    'need use these for column F and G through VBA, i can only get the first email's number i need entire column.
    '=MID($E2,FIND("N/A",$E2)+6,8) =MID($E2,FIND("N/A",$E2)+25,3)

    I can get the macro to pull the string needed (8 digit number i.e. '88888811' in this case) from the body of the email for the first row but not the rest of the rows.

    Please Login or Register  to view this content.
    I thought the above code would place this into the cell but no.

    So I am using tndrID = Mid(E, myloc + 6, 8)

    Please Login or Register  to view this content.

    This is the code I have modified to find in cell e2 the desired number and place it in column F then the equipment type (dry or reefer) in column G. I believe I've made a mess as it is not placing the MID function into the cell but just the result, so when i fill down the column I am not getting the function to fill down but the extracted string's value.

    Have a feeling I need a loop, i am bad with loops......Please assist,
    Attached Images Attached Images
    Last edited by Leith Ross; 09-07-2011 at 02:49 PM.

  2. #2
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: pull 8 digit string (number) from the body of email

    hi, Kreiz, why not to post sample workbook, it would help us to help you. It would be nice to see original data and result you need to obtain.
    Last edited by watersev; 09-07-2011 at 03:27 PM.

  3. #3
    Registered User
    Join Date
    07-27-2011
    Location
    Jacksonville, FL
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: pull 8 digit string (number) from the body of email

    As well with the whole Tweaking VBA for HTML Table Reading....Can you assist with

    I can login, navigate to needed load page, from here I am looking to search a certain table (dispatch notes) for "Start Rate $") and give me the entire block of data. (see attached picture, I need the yellow block)

    The macro currently:
    1. opens IE navigates to vertexfats.com
    2. Logs in using my user/pass
    3. Navigates to a certain load page.

    After that I am not sure I can query the Dispatch Notes table from the page here in IE or as I saw somewhere months ago but cannot reference or find again, possibly saving this 1 load page, and creating a query for that 1 table, but not sure how to extract that one line and keep this from taking days to run. I have on a regular basis 300 new load pages I have to go in weekly or bi-weekly and pull out the Start Rate for, and it is always in the Dispatch Notes as "START RATE $000"

    Any ideas please let me know.
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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