+ Reply to Thread
Results 1 to 3 of 3

How do I generate an excel spread sheet from my outlook email subject lines?

  1. #1
    Registered User
    Join Date
    02-15-2019
    Location
    Melbourne, FL
    MS-Off Ver
    365
    Posts
    2

    Exclamation How do I generate an excel spread sheet from my outlook email subject lines?

    I have hundreds of email, many duplicates. I would like to export the subject lines and received dates into a spread sheet so that I can sort through them. Is this something that I can do through excel?

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: How do I generate an excel spread sheet from my outlook email subject lines?

    Here is some code I have in my toolbox to do a more complicated process. I stripped away the pieces that didn't fit your requirement and added a little bit more.

    This application looks at your inbox and gets date received, Sender and Subject. All you have to do is enter your inbox mailbox name and click the button.
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    02-15-2019
    Location
    Melbourne, FL
    MS-Off Ver
    365
    Posts
    2

    Re: How do I generate an excel spread sheet from my outlook email subject lines?

    Thank you! But my boss told me he didn't need the information after all! Have a great day!

+ 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: 7
    Last Post: 12-19-2018, 03:21 PM
  2. vba pull data from outlook body of email through email or subject of mail into excel
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-01-2014, 04:37 AM
  3. Replies: 8
    Last Post: 05-17-2013, 01:53 AM
  4. export outlook 2007 email into excel with subject and body of email
    By akulka58 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-25-2013, 02:37 PM
  5. Auto generate email with that inputs excel spread
    By ckolawall in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-26-2013, 04:02 PM
  6. Problem amending email subject in Outlook using Excel VBA
    By madbloke in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-24-2012, 12:09 PM
  7. Using Excel VBA to generate an email in outlook
    By BrianDegnan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-01-2010, 12:14 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