Search results

Was I supposed to change something? also I wanted to thank you again for your time that you have taken to look at this.

@Diane Poremsky any new info?

Here are the sample emails. I've replaced any sensitive info with bla text. Thanks again.

when changing to get all i get this: I shrank the cells to fit on one page. Now when I change: For x = 1 To doc.Tables.Count to: For x = 2 To doc.Tables.Count I get rid of the junk rows 1-12. If I change the 2 to a 3 i get rid of the unwanted 13-29 but loose the wanted table directly...

So the link you pointed out I have seen and that one was the closest to what I wanted to achieve. The problem with that one is that 1: it creates a new workbook every time it runs 2: I really wanted to avoid copying the first table.: Here is a little more info on these emails too if this...

Thanks for the reply i'll put it to the test and give you an update. Sometimes the email will contain more than one table. I think the most I've seen so far is 4 of em with the same header

@Diane Poremsky , You were able to help me on another topic, Which again thanks. Now I've come up with another project I'd like to achieve. I get several emails a day (as included here for samples) that I would like to extract to excel. from there I can manipulate the data to my needs. I've...