+ Reply to Thread
Results 1 to 4 of 4

Select folder and date range to get emails from Outlook

  1. #1
    Registered User
    Join Date
    06-15-2012
    Location
    Maryland
    MS-Off Ver
    Excel 2010
    Posts
    26

    Select folder and date range to get emails from Outlook

    Hi,

    I have code for a macro so that I could get data from Outlook.

    Please Login or Register  to view this content.
    I can hardcode where I get the data from with:

    Please Login or Register  to view this content.
    However, I was wondering if it was possible to make some kind of button or form so that I can select a folder (Inbox, Sent Items, Archive, etc.) and to select a date range (e.g., if I wanted to see the info for the emails I sent during the last two weeks instead of ALL the emails in the Sent Items folder).

    Would it be easier to do this as a macro from Outlook (export data to Excel) vs. a macro in Excel (import data from Outlook)?

    Thanks!

  2. #2
    Registered User
    Join Date
    06-15-2012
    Location
    Maryland
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: Select folder and date range to get emails from Outlook

    I was able to figure out how to select a folder, but I'm still not sure how to select a date range (am thinking about using a userform but I'm not very familiar with it). Any suggestions? Thanks in advance!

  3. #3
    Valued Forum Contributor
    Join Date
    05-21-2009
    Location
    Great Britain
    MS-Off Ver
    Excel 2003
    Posts
    550

    Re: Select folder and date range to get emails from Outlook

    Cross-posted - http://www.mrexcel.com/forum/excel-q...a-outlook.html
    Post responsibly. Search for excelforum.com

  4. #4
    Registered User
    Join Date
    06-15-2012
    Location
    Maryland
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: Select folder and date range to get emails from Outlook

    Thanks! I didn't know about cross-posting etiquette and I apologize if it was discourteous. I'm fairly new to VBA and Excel forums, and while I've learned a lot through reading, etc., I was also trying to get a solution as quickly as possible.

    I also cross-posted here: http://www.ozgrid.com/forum/showthread.php?t=176570.
    Last edited by 2sqrd; 03-29-2013 at 10:04 AM.

+ 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