Pasting Excel Table into Body of Outlook reply

I know I am realllllllly close to getting this to work.

The problem that I am having is revolving around the code

Please Login or Register  to view this content.

Basically what the whole process will be is a Rule runs in Outlook and when a specific email comes in the attachment is saved in the the TPS Reports folder, then opened.... and then a couple vlookups are run on that attachment against data saved in the workbook VBDCdata.xlsx.

Then I need the data from the attachment after the vlookups have been run to be copied and pasted into the body of a reply email to the original senders.

I have this working in a text format only.... but i need that actual table format from excel. I am thinking that the error is coming from a problem with variable declarations, but not sure what it should be declared as if it should be declared?

Full code that is in outlook is below. Any help is appreciated.

Please Login or Register  to view this content.

Thank you!

i should have replied to this as I was able to figure out a solution as well

Please Login or Register  to view this content.