+ Reply to Thread
Results 1 to 4 of 4

Extract Email Body Info using Excel VBA

  1. #1
    Forum Contributor
    Join Date
    08-07-2014
    Location
    London
    MS-Off Ver
    10
    Posts
    148

    Extract Email Body Info using Excel VBA

    Hi all

    I was wondering if I could get some help with this. I use the following code to extract information from the subject line from an email. However, I also want to pull some information from the body of the same email. I want to either extract specific data or the full information from the email body and put it in column 9 of the worksheet.

    Can anyone help me amend the following code to do this?

    Any help would be greatly appreciated. Thank you in advance.

    Please Login or Register  to view this content.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Extract Email Body Info using Excel VBA

    Is this not essentially an Outlook programming question?

    If so I'll move it to the dedicated Outlook sub forum.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor
    Join Date
    08-07-2014
    Location
    London
    MS-Off Ver
    10
    Posts
    148

    Re: Extract Email Body Info using Excel VBA

    Hello

    Would it not stay in here because I am the coding is in Excel and not Outlook?

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Extract Email Body Info using Excel VBA

    I understood the request was to get information from an Outlook email for Excel.

    Getting information is usually the hardest part, putting it somewhere is trivial. It therefore seemed more logical that the essential coding would involve VBA for Outlook rather than VBA for Excel, although of course I accept the result ends up in Excel.

    Your choice really - it just seemed to me that those members who know more about Outlook VBA would be reached more easily if it was in a dedicated Outlook forum

+ 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. RE: Extract body from email
    By djtprior in forum Access Programming / VBA / Macros
    Replies: 3
    Last Post: 12-11-2015, 08:36 AM
  3. Replies: 1
    Last Post: 01-20-2014, 09:31 AM
  4. [SOLVED] Excel can send mail with multiple cells info as email body and subject, befr 3 day of due
    By ExcelUser2707 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-19-2013, 06:49 AM
  5. [SOLVED] Excel can send mail with multiple cells info as email body and subject, befr 3 day of due
    By ExcelUser2707 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-13-2013, 04:29 AM
  6. Extract info from Notes Email to Excel 2003
    By tpictech in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-20-2013, 10:34 AM
  7. [SOLVED] Add info into main body of email
    By Noemi in forum Excel General
    Replies: 0
    Last Post: 05-09-2006, 08:10 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