+ Reply to Thread
Results 1 to 3 of 3

Extract Subject and Body of an Outlook Message into Excel

  1. #1
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Extract Subject and Body of an Outlook Message into Excel

    I'm looking to code a macro in Excel using VBA that connects to Outlook and extracts the details of Mail Subject, (Msg) Received Date and the Message Body extracted into different columns. The messages I need to export are available inside a subfolder under Managed Folders.

    How can this be done ? Can someone help ?
    If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.

    If your requirement has been solved please mark your thread as Solved.
    In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".

    Kindly use [FORMULA] or [CODE] tags when posting your code.

    Regards,
    Sarang

  2. #2
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812
    Quote Originally Posted by Saarang84 View Post
    I'm looking to code a macro in Excel using VBA that connects to Outlook and extracts the details of Mail Subject, (Msg) Received Date and the Message Body extracted into different columns. The messages I need to export are available inside a subfolder under Managed Folders.

    How can this be done ? Can someone help ?

    Bumping Thread ...

  3. #3
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    Re: Extract Subject and Body of an Outlook Message into Excel

    Hi,

    I came across this post (in this forum) which needs a bit of tweaking to suit my needs.

    Export Outlook Messages To Excel

    There is limited response to this post, can someone help me fulfill my need ?

+ 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. Replies: 0
    Last Post: 09-07-2015, 04:05 PM
  2. Cross reference Outlook message subject with Excel list.
    By Karl Kennedy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-20-2014, 10:12 AM
  3. I want to open up an outlook e-mail with info. pre-set in the subject and body...
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-22-2014, 10:47 AM
  4. Body of outlook message to Excel
    By dougmorgan in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 05-19-2013, 09:11 AM
  5. 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
  6. Copy Subject and Body from Outlook to Excel
    By ccstorey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-16-2010, 11:54 AM
  7. Adding message subject AND body to a hyperlink
    By Alltmor in forum Excel General
    Replies: 2
    Last Post: 08-19-2007, 07:22 AM

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