+ Reply to Thread
Results 1 to 3 of 3

export outlook messages to an excel workbook

  1. #1
    Registered User
    Join Date
    05-10-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    49

    Question export outlook messages to an excel workbook

    Hi,
    Does anyone know how to export email messages from outlook to an excel workbook? Preferrably using a VBA macro to do it faster.

    Thanks in advance!
    Fernando

  2. #2
    Registered User
    Join Date
    08-06-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    80

    Re: export outlook messages to an excel workbook

    Depends what you mena by export email messages. You can easily transfer details, such as headers, sender name and so on. If that's what your after then here's a basic bit of VB to get you going.

    (Make sure you've got the Excel Object selected in the references menu)

    Please Login or Register  to view this content.
    Cheers
    Last edited by Cutter; 08-06-2012 at 09:05 AM. Reason: Added code tags

  3. #3
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: export outlook messages to an excel workbook

    @ Jockney

    Welcome to the forum. Great to see you assisting others right away.

    Please notice that code tags have been added to your post. The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
    Thanks.

+ 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