+ Reply to Thread
Results 1 to 3 of 3

VBA extract Data from specific location in body of Outlook To Excel

  1. #1
    Registered User
    Join Date
    08-12-2020
    Location
    USA
    MS-Off Ver
    2016
    Posts
    18

    VBA extract Data from specific location in body of Outlook To Excel

    Hello Team,

    I currently have a Mail Merge Setup in Word which will sent out emails to and email list. The attached Capture.PNG is the template of what that Mail merge looks like. The employees will reply filling the boxes with numbers chooses. The attached Reply.PNG is a sample of what that looks like.

    What I need the VBA to do is extract Employee number in Sheet say column D (next Blank row)
    Then to pull data from the boxes into column E and on

    Using the Reply.PNG as an example the data should be as below.

    D E F G H I J K L M N
    123456 15 22 38 40 55 60 90 150 19 20

    Would like this to happen to all unread email under Inbox/BID folder in outlook. so each email should be on the next blank row in the sheet.

    any help is greatly appreciated.
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    08-12-2020
    Location
    USA
    MS-Off Ver
    2016
    Posts
    18

    Re: VBA extract Data from specific location in body of Outlook To Excel

    this form is crossed reference at Mrexcel.com form number 1143920 will not allow me to post links

  3. #3
    Registered User
    Join Date
    08-12-2020
    Location
    USA
    MS-Off Ver
    2016
    Posts
    18

    Re: VBA extract Data from specific location in body of Outlook To Excel

    Please Login or Register  to view this content.
    How can I modify the above code to Pull number after "employee#:" from Outlook
    Last edited by korekurd; 08-31-2020 at 10:11 AM.

+ 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. Extract multiple lines of text from Outlook email body into Excel
    By Ranger75 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-07-2018, 03:47 PM
  2. Replies: 2
    Last Post: 04-12-2017, 04:27 AM
  3. Extract Subject and Body of an Outlook Message into Excel
    By Saarang84 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2016, 12:31 AM
  4. Replies: 0
    Last Post: 09-07-2015, 04:05 PM
  5. Replies: 0
    Last Post: 08-17-2015, 11:00 PM
  6. Macro to extract body data from Outlook messages in to Excel
    By gangup in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-23-2012, 12:21 PM
  7. Extract outlook message body text with VBA from Excel
    By jamsta1972 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-31-2012, 05:43 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