Log in

View Full Version : How to import Emails from My PST mail box to EXCEL


Hudson
10-04-2016, 03:57 PM
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 .
gmayor
10-04-2016, 09:22 PM
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?
Hudson
10-05-2016, 05:52 AM
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.
gmayor
10-05-2016, 07:28 AM
Post the code that you have, so we can see what it is that you are trying to export and to where in Excel.
Hudson
10-05-2016, 10:18 AM
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.
gmayor
10-05-2016, 11:59 PM
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.
Hudson
10-06-2016, 11:14 AM
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.:)
Hudson
10-06-2016, 12:16 PM
Mate - I am getting run time error when I was trying to enter dates .

Can you advice .
Hudson
10-06-2016, 12:19 PM
" Run time error out of memory"
Hudson
10-06-2016, 12:25 PM
Mate it is my mistake . it is working fine ... I am sorry :)