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 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 <rocke...@gmail.com > <javascript:>> wrote: > >> 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.Sundarvelan >>> 9600160150 >>> >>> On Wed, May 27, 2015 at 4:19 PM, Mandeep Baluja <rocke...@gmail.com> >>> 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: >>>>> >>>>> Dear Mandeep, >>>>> >>>>> I'm getting error in the below line. >>>>> >>>>> Please help. >>>>> >>>>> lr = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row >>>>> >>>>> Thanks >>>>> N.Sundarvelan >>>>> 9600160150 >>>>> >>>>> On Mon, May 18, 2015 at 2:11 PM, Sundarvelan N <nsun...@gmail.com> >>>>> wrote: >>>>> >>>>>> Thanks Mandeep!!! >>>>>> >>>>>> Thanks >>>>>> N.Sundarvelan >>>>>> 9600160150 >>>>>> >>>>>> On Mon, May 18, 2015 at 11:21 AM, Mandeep Baluja <rocke...@gmail.com> >>>>>> 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:30, Sundarvelan wrote: >>>>>>>> >>>>>>>> Dear Friends, >>>>>>>> >>>>>>>> Is there any possibilities copy, Subject, From Name with email >>>>>>>> Address, Body of the mail and attachements. >>>>>>>> >>>>>>>> with customized From Date - To Date >>>>>>>> >>>>>>>> >>>>>>>> Thanks >>>>>>>> N.Sundarvelan >>>>>>>> 9600160150 >>>>>>>> >>>>>>> -- >>>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>>>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>>>>> https://www.facebook.com/discussexcel >>>>>>> >>>>>>> FORUM RULES >>>>>>> >>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>>>> Advice will not get quick attention or may not be answered. >>>>>>> 2) Don't post a question in the thread of another member. >>>>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>>>> measure. >>>>>>> 4) Acknowledge the responses you receive, good or bad. >>>>>>> 5) Jobs posting is not allowed. >>>>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>>>> >>>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>>>>> and members are not responsible for any loss. >>>>>>> --- >>>>>>> You received this message because you are subscribed to the Google >>>>>>> Groups "MS EXCEL AND VBA MACROS" group. >>>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>>> send an email to excel-macros...@googlegroups.com. >>>>>>> To post to this group, send email to excel-...@googlegroups.com. >>>>>>> Visit this group at http://groups.google.com/group/excel-macros. >>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>> >>>>>> >>>>>> >>>>> -- >>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>> https://www.facebook.com/discussexcel >>>> >>>> FORUM RULES >>>> >>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>>> will not get quick attention or may not be answered. >>>> 2) Don't post a question in the thread of another member. >>>> 3) Don't post questions regarding breaking or bypassing any security >>>> measure. >>>> 4) Acknowledge the responses you receive, good or bad. >>>> 5) Jobs posting is not allowed. >>>> 6) Sharing copyrighted material and their links is not allowed. >>>> >>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>> and members are not responsible for any loss. >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "MS EXCEL AND VBA MACROS" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to excel-macros...@googlegroups.com. >>>> To post to this group, send email to excel-...@googlegroups.com. >>>> Visit this group at http://groups.google.com/group/excel-macros. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros...@googlegroups.com <javascript:>. >> To post to this group, send email to excel-...@googlegroups.com >> <javascript:>. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Get outlook emails automatically .xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
