Hi Ashish, Thank you for your response. I have been able to write a macro which will copy table information from outlook mail body and paste the same in the excel file.
However, i am curious to know if the mails that have been worked upon by the macro could be moved to any other sub-folder so that those mails information is not copied again in the file. Please suggest. Thanks, Ankit Mehra On 7 Feb 2014 00:01, <koul.ash...@gmail.com> wrote: > Hi Ankit > > Save the outlook mail as word document and then open the document and copy > content and paste it in excel > > You need to automate above steps > Sent on my BlackBerry(R) from Vodafone > ------------------------------ > *From: * Ankit Mehra <ankitmehr...@gmail.com> > *Sender: * excel-macros@googlegroups.com > *Date: *Thu, 6 Feb 2014 16:21:40 +0530 > *To: *<excel-macros@googlegroups.com> > *ReplyTo: * excel-macros@googlegroups.com > *Subject: *$$Excel-Macros$$ Export table data from outlook body to excel > files > > Dear Experts, > > I have a query related to email that i receive in my outlook. The below > mentioned table is part of the body of the email. I am looking for the > following solution: > > 1. Copy the table contents from the body of the outlook email and paste > the same in an excel file. > 2. There are 4 existing workbooks in which i would like to get this data > pasted based on the Entity Name. For Example: If Entity name contains US, > it should be copied to Workbook A, if Entity name contains GB, it should be > copied to Workbook B and so on. > > Request you to kindly assist me in getting a VBA code which could do this > task for me automatically once i run the macro through Outlook. > > Please let me know in case you have any questions. > > > > *Entity* > > *Invoice no* > > *Amount* > > *Due date* > > *Paid date* > > *US005* > > 20566856 > > $71,780.98 > > 10-Jan-14 > > 23-Jan-14 > > *US007* > > 20566847 > > $266,827.6 > > 10-Jan-14 > > 13-Jan-14 > > *US015* > > 20566848 > > 165,797.27 > > 10-Jan-14 > > 14-Jan-14 > > *US023* > > 20566852 > > $120,297.86 > > 10-Jan-14 > > 20-Jan-14 > > *US077* > > 20566850 > > $266,247.26 > > 10-Jan-14 > > 10-Jan-14 > > > > Thanks & Regards > > Ankit Mehra > > -- > 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/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. > 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. For more options, visit https://groups.google.com/groups/opt_out.
