Hi all ,
I am completely new to VBA Coding , could some one help me How to import emails from my outlook PST and sub-folders.
with Date as another component ( For example = My mail folder has so many mail from 2015 i want only that particular mails to imported to excel when i give date range 09/15/2016 to 10/04/32016. like wise so on .
Outlook message and Excel formats are entirely different from one another. How do you propose the messages are imported into Excel? What is it that you want from the message to be stored in Excel?
Graham Mayor - MS MVP (Word) 2002-2019
Visit my web site for more programming tips and ready made processes
http://www.gmayor.com
Hi Graham.
Thanks for coming back on my request .
I am looking for a code that could preform the job of exporting emails to excel the folder I selected in my outlook.com
I have a code that does the same job . but I unable to interact with few folders . so now I want the code to be more dynamic such that all the mails in the folder I selected should be able to export into excel.
Hope I made my question clear . and sorry for my bad English.
Post the code that you have, so we can see what it is that you are trying to export and to where in Excel.
Graham Mayor - MS MVP (Word) 2002-2019
Visit my web site for more programming tips and ready made processes
http://www.gmayor.com
I have attached excel file with a code in it .. kindly have look for your reference .
I was trying to wrap the code from ribbon options but could not able to.
It is not practical to insert the message bodies into an Excel cell, as you will see from the attached modified version, however the attached will allow you to pick dates and select a folder to process.
Graham Mayor - MS MVP (Word) 2002-2019
Visit my web site for more programming tips and ready made processes
http://www.gmayor.com
thank you mate . this is great !!!!
I have read so many posts from Outlook forum .. you are the best and your advice are the best I have read so far..
anyways thanks for your advice , I wanted you work with you in all my outlook queries . hope I will get in touch with you again.
Mate - I am getting run time error when I was trying to enter dates .
Can you advice .
" Run time error out of memory"
Mate it is my mistake . it is working fine ... I am sorry
Posting Permissions
Reply With Quote
