Re: $$Excel-Macros$$ is there option to run macro program to pull data from outlook mail
*You're welcome..Prabhu.* On Wed, Apr 10, 2013 at 11:26 AM, Prabhu Pinky prabhupin...@gmail.comwrote: Hi Pravin Gunjal [?] Wowww its working... thanks a lot lot lot.. you saved my lots of lots of time thanks again for your extraordinary tip. On 10 April 2013 10:04, Pravin Gunjal isk1...@gmail.com wrote: Dear Prabhu By doing this only you will get From, To, Subject, Date Time these field only and not e-mails data/communication in excel file. Pl try and confirm to us. - Pravin. On Wed, Apr 10, 2013 at 7:09 AM, Prabhu Pinky prabhupin...@gmail.comwrote: i do not wants to paste the mails in excel. i want to copy the mail sent time and mail subject only. On 9 April 2013 16:40, Pravin Gunjal isk1...@gmail.com wrote: Directly you can go to the sent box and select all of them and hit Ctrl+C (copy) and then go to excel file and paste. Pl confirm. -- Forwarded message -- From: Prabhu Pinky prabhupin...@gmail.com Date: Tue, Apr 9, 2013 at 12:01 PM Subject: Re: $$Excel-Macros$$ is there option to run macro program to pull data from outlook mail To: excel-macros@googlegroups.com Hi, For testing purpose, i have attached three mail herewith. This is not (.pst), i have copied sent items in my local folder. On 9 April 2013 11:56, Abhishek Jain abhishek@gmail.com wrote: I think MS outlook has only one file (.pst) which has all its folders. Do you mean you saved your sent items in a folder? Can you attach 2-3 of your emails for testing purpose? On Tue, Apr 9, 2013 at 11:54 AM, Prabhu Pinky prabhupin...@gmail.comwrote: Hi Abhishek, It is MS Outlook mails, i just copied sent mails from MS Outlook and copied in local folder. Thanks regards, Prabhu R On 9 April 2013 11:49, Abhishek Jain abhishek@gmail.com wrote: Is it MS Outlook (having .pst in your local folder) ? or Outlook Express (having .dbx in your local folder) ? On Tue, Apr 9, 2013 at 11:46 AM, Prabhu Pinky prabhupin...@gmail.com wrote: Hi everyone, it will be so appreciated if anyone gimme a macro program for my requirement. i have nearly 100 outlook mails saved in my local folder. can i extract all mails sent time and subject in excel sheet one by one by using macro program? Please help because am doing this task manually on every month and its killing my whole day. Thanks Regards Prabhu R -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
Re: $$Excel-Macros$$ is there option to run macro program to pull data from outlook mail
Is it MS Outlook (having .pst in your local folder) ? or Outlook Express (having .dbx in your local folder) ? On Tue, Apr 9, 2013 at 11:46 AM, Prabhu Pinky prabhupin...@gmail.comwrote: Hi everyone, it will be so appreciated if anyone gimme a macro program for my requirement. i have nearly 100 outlook mails saved in my local folder. can i extract all mails sent time and subject in excel sheet one by one by using macro program? Please help because am doing this task manually on every month and its killing my whole day. Thanks Regards Prabhu R -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ is there option to run macro program to pull data from outlook mail
Hi Abhishek, It is MS Outlook mails, i just copied sent mails from MS Outlook and copied in local folder. Thanks regards, Prabhu R On 9 April 2013 11:49, Abhishek Jain abhishek@gmail.com wrote: Is it MS Outlook (having .pst in your local folder) ? or Outlook Express (having .dbx in your local folder) ? On Tue, Apr 9, 2013 at 11:46 AM, Prabhu Pinky prabhupin...@gmail.comwrote: Hi everyone, it will be so appreciated if anyone gimme a macro program for my requirement. i have nearly 100 outlook mails saved in my local folder. can i extract all mails sent time and subject in excel sheet one by one by using macro program? Please help because am doing this task manually on every month and its killing my whole day. Thanks Regards Prabhu R -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ is there option to run macro program to pull data from outlook mail
I think MS outlook has only one file (.pst) which has all its folders. Do you mean you saved your sent items in a folder? Can you attach 2-3 of your emails for testing purpose? On Tue, Apr 9, 2013 at 11:54 AM, Prabhu Pinky prabhupin...@gmail.comwrote: Hi Abhishek, It is MS Outlook mails, i just copied sent mails from MS Outlook and copied in local folder. Thanks regards, Prabhu R On 9 April 2013 11:49, Abhishek Jain abhishek@gmail.com wrote: Is it MS Outlook (having .pst in your local folder) ? or Outlook Express (having .dbx in your local folder) ? On Tue, Apr 9, 2013 at 11:46 AM, Prabhu Pinky prabhupin...@gmail.comwrote: Hi everyone, it will be so appreciated if anyone gimme a macro program for my requirement. i have nearly 100 outlook mails saved in my local folder. can i extract all mails sent time and subject in excel sheet one by one by using macro program? Please help because am doing this task manually on every month and its killing my whole day. Thanks Regards Prabhu R -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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 @
Re: $$Excel-Macros$$ is there option to run macro program to pull data from outlook mail
You can use code2 outlook addins. It does the same work with ease. On Apr 9, 2013 12:01 PM, Prabhu Pinky prabhupin...@gmail.com wrote: Hi, For testing purpose, i have attached three mail herewith. This is not (.pst), i have copied sent items in my local folder. On 9 April 2013 11:56, Abhishek Jain abhishek@gmail.com wrote: I think MS outlook has only one file (.pst) which has all its folders. Do you mean you saved your sent items in a folder? Can you attach 2-3 of your emails for testing purpose? On Tue, Apr 9, 2013 at 11:54 AM, Prabhu Pinky prabhupin...@gmail.comwrote: Hi Abhishek, It is MS Outlook mails, i just copied sent mails from MS Outlook and copied in local folder. Thanks regards, Prabhu R On 9 April 2013 11:49, Abhishek Jain abhishek@gmail.com wrote: Is it MS Outlook (having .pst in your local folder) ? or Outlook Express (having .dbx in your local folder) ? On Tue, Apr 9, 2013 at 11:46 AM, Prabhu Pinky prabhupin...@gmail.comwrote: Hi everyone, it will be so appreciated if anyone gimme a macro program for my requirement. i have nearly 100 outlook mails saved in my local folder. can i extract all mails sent time and subject in excel sheet one by one by using macro program? Please help because am doing this task manually on every month and its killing my whole day. Thanks Regards Prabhu R -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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
Re: $$Excel-Macros$$ is there option to run macro program to pull data from outlook mail
i do not wants to paste the mails in excel. i want to copy the mail sent time and mail subject only. On 9 April 2013 16:40, Pravin Gunjal isk1...@gmail.com wrote: Directly you can go to the sent box and select all of them and hit Ctrl+C (copy) and then go to excel file and paste. Pl confirm. -- Forwarded message -- From: Prabhu Pinky prabhupin...@gmail.com Date: Tue, Apr 9, 2013 at 12:01 PM Subject: Re: $$Excel-Macros$$ is there option to run macro program to pull data from outlook mail To: excel-macros@googlegroups.com Hi, For testing purpose, i have attached three mail herewith. This is not (.pst), i have copied sent items in my local folder. On 9 April 2013 11:56, Abhishek Jain abhishek@gmail.com wrote: I think MS outlook has only one file (.pst) which has all its folders. Do you mean you saved your sent items in a folder? Can you attach 2-3 of your emails for testing purpose? On Tue, Apr 9, 2013 at 11:54 AM, Prabhu Pinky prabhupin...@gmail.comwrote: Hi Abhishek, It is MS Outlook mails, i just copied sent mails from MS Outlook and copied in local folder. Thanks regards, Prabhu R On 9 April 2013 11:49, Abhishek Jain abhishek@gmail.com wrote: Is it MS Outlook (having .pst in your local folder) ? or Outlook Express (having .dbx in your local folder) ? On Tue, Apr 9, 2013 at 11:46 AM, Prabhu Pinky prabhupin...@gmail.comwrote: Hi everyone, it will be so appreciated if anyone gimme a macro program for my requirement. i have nearly 100 outlook mails saved in my local folder. can i extract all mails sent time and subject in excel sheet one by one by using macro program? Please help because am doing this task manually on every month and its killing my whole day. Thanks Regards Prabhu R -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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
Re: $$Excel-Macros$$ is there option to run macro program to pull data from outlook mail
Dear Prabhu By doing this only you will get From, To, Subject, Date Time these field only and not e-mails data/communication in excel file. Pl try and confirm to us. - Pravin. On Wed, Apr 10, 2013 at 7:09 AM, Prabhu Pinky prabhupin...@gmail.comwrote: i do not wants to paste the mails in excel. i want to copy the mail sent time and mail subject only. On 9 April 2013 16:40, Pravin Gunjal isk1...@gmail.com wrote: Directly you can go to the sent box and select all of them and hit Ctrl+C (copy) and then go to excel file and paste. Pl confirm. -- Forwarded message -- From: Prabhu Pinky prabhupin...@gmail.com Date: Tue, Apr 9, 2013 at 12:01 PM Subject: Re: $$Excel-Macros$$ is there option to run macro program to pull data from outlook mail To: excel-macros@googlegroups.com Hi, For testing purpose, i have attached three mail herewith. This is not (.pst), i have copied sent items in my local folder. On 9 April 2013 11:56, Abhishek Jain abhishek@gmail.com wrote: I think MS outlook has only one file (.pst) which has all its folders. Do you mean you saved your sent items in a folder? Can you attach 2-3 of your emails for testing purpose? On Tue, Apr 9, 2013 at 11:54 AM, Prabhu Pinky prabhupin...@gmail.comwrote: Hi Abhishek, It is MS Outlook mails, i just copied sent mails from MS Outlook and copied in local folder. Thanks regards, Prabhu R On 9 April 2013 11:49, Abhishek Jain abhishek@gmail.com wrote: Is it MS Outlook (having .pst in your local folder) ? or Outlook Express (having .dbx in your local folder) ? On Tue, Apr 9, 2013 at 11:46 AM, Prabhu Pinky prabhupin...@gmail.comwrote: Hi everyone, it will be so appreciated if anyone gimme a macro program for my requirement. i have nearly 100 outlook mails saved in my local folder. can i extract all mails sent time and subject in excel sheet one by one by using macro program? Please help because am doing this task manually on every month and its killing my whole day. Thanks Regards Prabhu R -- 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?hl=en . For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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)
Re: $$Excel-Macros$$ is there option to run macro program to pull data from outlook mail
Hi Pravin Gunjal [?] Wowww its working... thanks a lot lot lot.. you saved my lots of lots of time thanks again for your extraordinary tip. On 10 April 2013 10:04, Pravin Gunjal isk1...@gmail.com wrote: Dear Prabhu By doing this only you will get From, To, Subject, Date Time these field only and not e-mails data/communication in excel file. Pl try and confirm to us. - Pravin. On Wed, Apr 10, 2013 at 7:09 AM, Prabhu Pinky prabhupin...@gmail.comwrote: i do not wants to paste the mails in excel. i want to copy the mail sent time and mail subject only. On 9 April 2013 16:40, Pravin Gunjal isk1...@gmail.com wrote: Directly you can go to the sent box and select all of them and hit Ctrl+C (copy) and then go to excel file and paste. Pl confirm. -- Forwarded message -- From: Prabhu Pinky prabhupin...@gmail.com Date: Tue, Apr 9, 2013 at 12:01 PM Subject: Re: $$Excel-Macros$$ is there option to run macro program to pull data from outlook mail To: excel-macros@googlegroups.com Hi, For testing purpose, i have attached three mail herewith. This is not (.pst), i have copied sent items in my local folder. On 9 April 2013 11:56, Abhishek Jain abhishek@gmail.com wrote: I think MS outlook has only one file (.pst) which has all its folders. Do you mean you saved your sent items in a folder? Can you attach 2-3 of your emails for testing purpose? On Tue, Apr 9, 2013 at 11:54 AM, Prabhu Pinky prabhupin...@gmail.comwrote: Hi Abhishek, It is MS Outlook mails, i just copied sent mails from MS Outlook and copied in local folder. Thanks regards, Prabhu R On 9 April 2013 11:49, Abhishek Jain abhishek@gmail.com wrote: Is it MS Outlook (having .pst in your local folder) ? or Outlook Express (having .dbx in your local folder) ? On Tue, Apr 9, 2013 at 11:46 AM, Prabhu Pinky prabhupin...@gmail.com wrote: Hi everyone, it will be so appreciated if anyone gimme a macro program for my requirement. i have nearly 100 outlook mails saved in my local folder. can i extract all mails sent time and subject in excel sheet one by one by using macro program? Please help because am doing this task manually on every month and its killing my whole day. Thanks Regards Prabhu R -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en . For more options, visit https://groups.google.com/groups/opt_out. -- 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 @