Re: $$Excel-Macros$$ Re: Outlook Mail Details to Excel

2015-05-27 Thread Sundarvelan N
We have option to export from outlook. But in that export there is no date, if that possible my problem would be solved. Thanks N.Sundarvelan 9600160150 On Wed, May 27, 2015 at 7:01 PM, Mandeep Baluja wrote: > Mail is too huge to reside in a cell. > > On Wednesday, May 27, 2015 at 6:58:27 PM U

Re: $$Excel-Macros$$ Re: Outlook Mail Details to Excel

2015-05-27 Thread Mandeep Baluja
Mail is too huge to reside in a cell. On Wednesday, May 27, 2015 at 6:58:27 PM UTC+5:30, Sundarvelan wrote: > > Sorry, > > Im getting the attached error. > > Thanks > N.Sundarvelan > 9600160150 > > On Wed, May 27, 2015 at 6:44 PM, Mandeep Baluja > wrote: > >> check this out >> >> Regards, >> Ma

Re: $$Excel-Macros$$ Re: Outlook Mail Details to Excel

2015-05-27 Thread Mandeep Baluja
check this out Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/groups/825221420889809/ https://www.linkedin.com/profile/view?id=312532939 On Wednesday, May 27, 2015 at 6:11:07 PM UTC+5:30, Sundarvelan wrote: > > Sorry, I'm getting error. > > I expecting file like the attach

Re: $$Excel-Macros$$ Re: Outlook Mail Details to Excel

2015-05-27 Thread Sundarvelan N
Sorry, I'm getting error. I expecting file like the attached. Could you please include Body of the mail in the attached macro file. Thanks N.Sundarvelan 9600160150 On Wed, May 27, 2015 at 5:02 PM, Mandeep Baluja wrote: > Working find just enable microsoft outlook 14.0 librarary and set the da

Re: $$Excel-Macros$$ Re: Outlook Mail Details to Excel

2015-05-27 Thread Mandeep Baluja
Working find just enable microsoft outlook 14.0 librarary and set the date as per your requirement basically what the code is doing to fetch details of mails of last two days. On Wednesday, May 27, 2015 at 4:53:57 PM UTC+5:30, Sundarvelan wrote: > > I'm using this code in Outlook > > Thanks > N.

Re: $$Excel-Macros$$ Re: Outlook Mail Details to Excel

2015-05-27 Thread Sundarvelan N
I'm using this code in Outlook Thanks N.Sundarvelan 9600160150 On Wed, May 27, 2015 at 4:19 PM, Mandeep Baluja wrote: > send me the file with this code then I can understand the problem. > > Regards, > Mandeep Baluja > > > > > On Wednesday, May 27, 2015 at 3:37:00 PM UTC+5:30, Sundarvelan wrote

Re: $$Excel-Macros$$ Re: Outlook Mail Details to Excel

2015-05-27 Thread Mandeep Baluja
send me the file with this code then I can understand the problem. Regards, Mandeep Baluja On Wednesday, May 27, 2015 at 3:37:00 PM UTC+5:30, Sundarvelan wrote: > > Dear Mandeep, > > I'm getting error in the below line. > > Please help. > >lr = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Of

Re: $$Excel-Macros$$ Re: Outlook Mail Details to Excel

2015-05-18 Thread Mandeep Baluja
Enable outlook library in reference and use this code. you can change the date criteria to get the updated mails. Sub GetFromInbox() Dim olApp As Outlook.Application Dim olNs As Namespace Dim Fldr As MAPIFolder Dim olMail As Variant Dim i As Integer Set olApp = New Outl

Re: $$Excel-Macros$$ Re: Outlook Mail Details to Excel

2015-05-18 Thread Sundarvelan N
But I want Macro Excel File that will auto update all mail details in excel periodically. Please help!!! Thanks N.Sundarvelan 9600160150 On Mon, May 18, 2015 at 2:11 PM, Sundarvelan N wrote: > Thanks Mandeep!!! > > Thanks > N.Sundarvelan > 9600160150 > > On Mon, May 18, 2015 at 11:21 AM, Mande

Re: $$Excel-Macros$$ Re: Outlook Mail Details to Excel

2015-05-18 Thread Sundarvelan N
Thanks Mandeep!!! Thanks N.Sundarvelan 9600160150 On Mon, May 18, 2015 at 11:21 AM, Mandeep Baluja wrote: > Go to file option Click on open then export it to excel , you can export > any folder to a excel file. > > Regards, > Mandeep Baluja > > > > > On Monday, May 18, 2015 at 10:47:24 AM UTC+5

$$Excel-Macros$$ Re: Outlook Mail Details to Excel

2015-05-17 Thread Mandeep Baluja
Go to file option Click on open then export it to excel , you can export any folder to a excel file. Regards, Mandeep Baluja On Monday, May 18, 2015 at 10:47:24 AM UTC+5:30, Sundarvelan wrote: > > Dear Friends, > > Is there any possibilities copy, Subject, From Name with email Address, >