bro, i want it from .msg file
On Wed, Jun 11, 2014 at 2:23 PM, Vaibhav Joshi <v...@vabs.in> wrote: > Rohan > > you want from .msg file or .pst foder? > > > On Wed, Jun 11, 2014 at 12:45 PM, Rohan Young <rohan.j...@gmail.com> > wrote: > >> Thanks Vaibhav bro its excellent & it will help me in future but my data >> is saved in Folders on Desktop coz I have changed the subject of the mails >> as per the requirements. I need to pick data of mails from my saved folders >> from desktop. >> >> hope u r understanding. Please make correction in it. >> >> Thanks Bro >> >> ROHAN >> >> >> On Wed, Jun 11, 2014 at 11:28 AM, Vaibhav Joshi <v...@vabs.in> wrote: >> >>> Hi >>> >>> Check this, you can select folder one by one. If you want to Import from >>> one folder only then once data is imported press escape key when prompted >>> for second time. >>> >>> Cheers!! >>> >>> >>> On Wed, Jun 11, 2014 at 10:22 AM, Rohan Young <rohan.j...@gmail.com> >>> wrote: >>> >>>> Hi Ravinder, >>>> >>>> I want to save a excel file like logbook of Incoming & Outgoing mails >>>> with details as stated before no need of msg body >>>> >>>> Thanks >>>> >>>> >>>> On Wed, Jun 11, 2014 at 10:16 AM, Ravinder <ravindervbacli...@gmail.com >>>> > wrote: >>>> >>>>> U want to save exl files with name or outlook mails in incoming and >>>>> outgoing folders? >>>>> >>>>> >>>>> >>>>> *From:* excel-macros@googlegroups.com [mailto: >>>>> excel-macros@googlegroups.com] *On Behalf Of *Rohan Young >>>>> *Sent:* Tuesday, June 10, 2014 4:55 PM >>>>> *To:* excel-macros@googlegroups.com >>>>> *Subject:* Re: $$Excel-Macros$$ Outlook Mails log in Excel through >>>>> MACRO >>>>> >>>>> >>>>> >>>>> Hi, >>>>> >>>>> >>>>> >>>>> Thanks Anil & Ravinder but I need to make log in Excel with details of >>>>> To, From, CC, Subject, Date, Time etc. and all data of Outlook mails is >>>>> saved in Hard Drive with the name of Incoming & Outgoing. please look at >>>>> output sample : >>>>> >>>>> >>>>> >>>>> *To* >>>>> >>>>> *CC* >>>>> >>>>> *From* >>>>> >>>>> *Subject* >>>>> >>>>> *Date Received* >>>>> >>>>> *Time of mail* >>>>> >>>>> abc >>>>> >>>>> xyz >>>>> >>>>> 123 >>>>> >>>>> Hello >>>>> >>>>> 10-Jun-14 >>>>> >>>>> 16:51 >>>>> >>>>> >>>>> >>>>> thanks in advance >>>>> >>>>> >>>>> >>>>> Regds >>>>> >>>>> >>>>> >>>>> ROHAN >>>>> >>>>> >>>>> >>>>> On Tue, Jun 10, 2014 at 3:46 PM, finu kodokodan <finux...@gmail.com> >>>>> wrote: >>>>> >>>>> Hi Anil , >>>>> >>>>> >>>>> >>>>> Good work , If the email id added in one column (As per attached ) we >>>>> have to sent detail to corresponding emails . please advise how it will >>>>> work >>>>> >>>>> Eg. here Sony details need to sent x...@gmail.com >>>>> >>>>> and LG details sould be ZZZ@gmail .com etc like that >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> On Tue, Jun 10, 2014 at 1:23 PM, Anil Gawli <gawlianil8...@gmail.com> >>>>> wrote: >>>>> >>>>> Dear Rohan, >>>>> >>>>> Pl find attached. >>>>> >>>>> Warm Regards, >>>>> Gawli Anil/. >>>>> >>>>> >>>>> On Tue, Jun 10, 2014 at 2:19 PM, Rohan Young <rohan.j...@gmail.com> >>>>> wrote: >>>>> > Hi Group, >>>>> > >>>>> > I have two folders of mails (incoming & outgoing) and I need a macro >>>>> to make >>>>> > a log of mails separately of both folders in excel with the following >>>>> > details >>>>> > >>>>> > From, To, CC, Subject, Date, Time >>>>> > >>>>> > Please do the needful ASAP >>>>> > >>>>> > Rgds >>>>> > >>>>> > ROHAN >>>>> > >>>>> > 9818247278 >>>>> > >>>>> > -- >>>>> > 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. >>>>> >>>>> -- >>>>> 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. >>>>> >>>>> >>>>> >>>>> -- >>>>> 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. >>>>> >>>>> >>>>> >>>>> -- >>>>> 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. >>>>> >>>>> -- >>>>> 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. >>>>> >>>> >>>> -- >>>> 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. >>>> >>> >>> -- >>> 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. >>> >> >> -- >> 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. >> > > -- > 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. > -- 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.
