+ Reply to Thread
Results 1 to 4 of 4

Outlook Folder Contents to Export to Excel

  1. #1
    Registered User
    Join Date
    03-07-2019
    Location
    Jacksonville
    MS-Off Ver
    2016
    Posts
    33

    Outlook Folder Contents to Export to Excel

    I have the below in Outlook and no emails are populating on my desktop spreadsheet. This is a test. I need to have 7 mailbox folders to export to 7 worksheets in an email tracking workbook. Maybe there is something incorrect in the below. Any help would be appreciated, thank you.
    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    03-07-2019
    Location
    Jacksonville
    MS-Off Ver
    2016
    Posts
    33

    Re: Outlook Folder Contents to Export to Excel

    Solved using Excel, the below will bring in from an active outlook folder

    Please Login or Register  to view this content.
    Last edited by Pepe Le Mokko; 12-27-2019 at 05:08 AM.

  3. #3
    Registered User
    Join Date
    03-07-2019
    Location
    Jacksonville
    MS-Off Ver
    2016
    Posts
    33

    Re: Outlook Folder Contents to Export to Excel

    How do I add the field "Flag Completed Date"?

  4. #4
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Outlook Folder Contents to Export to Excel

    Hi,

    Take a look at:
    Please Login or Register  to view this content.
    If that is not what you want, put a breakpoint on one of the olItem lines, View Locals and open up olItem which may show you the correct property to look at.

    Lewis

+ 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. Export Outlook Folder Emails to excel -- need body separated
    By BG1983 in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 07-04-2017, 02:11 PM
  2. Macro to export excel files from outlook folder and consolidate
    By xxxnac in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2014, 02:18 PM
  3. Export from Excel to Outlook, Outlook has to be running?
    By christian2012 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-10-2013, 07:01 PM
  4. outlook data export to EXCEL
    By peobody in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-19-2012, 11:37 AM
  5. Export emails from Outlook to Excel
    By ExcelStud in forum Outlook Programming / VBA / Macros
    Replies: 1
    Last Post: 01-03-2012, 11:22 AM
  6. Excel macro - export to Outlook .ics
    By JeppeC in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-04-2011, 04:09 AM
  7. Outlook to Excel Export
    By Brokovich in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-09-2010, 05:38 PM

Tags for this Thread

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