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 -----Original Message----- From: Ankit Mehra <ankitmehr...@gmail.com> Sender: excel-macros@googlegroups.com Date: Thu, 6 Feb 2014 16:21:40 To: <excel-macros@googlegroups.com> Reply-To: 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.
