Forum

Thanks Mynda pointing out the problem and methodology of the calculating method in the PT. But, please help further demonstrate using Power Query...

Thanks Philip will try on this!

But still not sure where to check the name of the Account in outlook ? Would it be ng.david.wl

in use with email address :[email protected]

just the file in the Folder

Yes. But still not working Dim Folder As Object Dim Email As Variant Dim i As Integer Set OutlookApp = CreateObject("Outlook.Application...

So sorry , where to find email account name? As far as I know the Email account name is: GKJ00OH004

So sorry , but how to find Account name in the Outlook.ost, then update to the VBA?

Account Name : GKJ00OH004

Sorry pls refer this attach.

Thanks Philip, pls refer attach Screen shot of my PC Pls help modify macro for use BTW , my 365 Outlook.Ost kept in : D:GKJ00OH004Email….OST

I tried but the extract data seems from my old Outlook.pst Inbox Folder. Can we run the same macro but extract from Outlook.ost file Inbox Folder; ...

Thanks millions Philip, will try on this.