Hello All,
Is there any way to get the list of email addresses from outlook inbox which I received in last one year?
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
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.
I am not getting the email address.Just the dates. Is there something i need to modify?
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.
excelforum.xlsm
here is the sample file
See edited post #4
SMTP & ET in column E
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.
Still not.
its ok, I will try to explore with the code you gave. Thanks
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.
I got this from another server and is fetching the id.
https://www.mrexcel.com/board/thread...ok-vba.444863/
OK...glad you got it sorted out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks