+ Reply to Thread
Results 1 to 12 of 12

List of email addresses from inbox

  1. #1
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    489

    Post List of email addresses from inbox

    Hello All,
    Is there any way to get the list of email addresses from outlook inbox which I received in last one year?
    Please make the Post as solved, when you get your answer & Click * if you like my suggestion

  2. #2
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: List of email addresses from inbox

    Try this macro;
    Put your start date and end date of the emails you want to retrieve in A1 and B1. Email sender address in column C and date received in column D
    Note the comment on the second line (Tools>References in your VBA window)

    Please Login or Register  to view this content.
    Last edited by Croweater; 02-06-2023 at 03:16 AM.

  3. #3
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    489

    Re: List of email addresses from inbox

    I am not getting the email address.Just the dates. Is there something i need to modify?

  4. #4
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: List of email addresses from inbox

    Can you make this one line addition to the code and tell me what it says in column E?

    Please Login or Register  to view this content.
    Last edited by Croweater; 02-06-2023 at 05:12 AM.

  5. #5
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    489

    Re: List of email addresses from inbox

    excelforum.xlsm
    here is the sample file

  6. #6
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: List of email addresses from inbox

    See edited post #4

  7. #7
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    489

    Re: List of email addresses from inbox

    SMTP & ET in column E

  8. #8
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: List of email addresses from inbox

    I cannot test properly as I don't get emails from an Internal Exchange, but try this modification;
    Please Login or Register  to view this content.
    Last edited by Croweater; 02-06-2023 at 05:43 AM.

  9. #9
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    489

    Re: List of email addresses from inbox

    Still not.
    its ok, I will try to explore with the code you gave. Thanks

  10. #10
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: List of email addresses from inbox

    No problem. You may have to step through the code and see what is happening in there.

    I'm surprised it is not working for the internet emails though...it picked all of mine out.

    Let me know how it goes. I'll try to help more if I can.

  11. #11
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    489

    Re: List of email addresses from inbox

    I got this from another server and is fetching the id.
    https://www.mrexcel.com/board/thread...ok-vba.444863/

  12. #12
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: List of email addresses from inbox

    OK...glad you got it sorted out.

+ 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. Need to know who was removed or added from a list of email addresses
    By dorlow in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-15-2020, 02:05 AM
  2. Replies: 0
    Last Post: 02-11-2019, 08:45 AM
  3. Replies: 3
    Last Post: 11-29-2014, 07:30 AM
  4. Extract Inbox/Sent Items emails addresses from following fields: FROM, TO, CC, BCC
    By ana.ciofrangeanu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-05-2014, 08:00 AM
  5. Removing email addresses from list
    By excelquestion1 in forum Excel General
    Replies: 12
    Last Post: 08-16-2013, 05:47 AM
  6. Look up a list of email addresses?
    By akopp in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-25-2008, 05:54 PM
  7. Excel List of Email Addresses
    By Jenny in forum Excel General
    Replies: 3
    Last Post: 05-23-2006, 05:25 AM

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