Create a Table within a For loop that gets placed into an E-mail Macro

Hello,

So I've got a bit of a conundrum on my hands and am unsure if this is even possible. So I currently have a worksheet with a bunch of rows and columns and my macro is a For loop and based off of certain criteria, it pulls information from the worksheet and places it into an email to send to another party. Now, this party has a very specific way of wanting to view the data (in a tabular format), so they would like it to look like a standard table separated by borders (Excel Table Style Light 15 is close enough). The table would is 2 columns and 12 rows, with each row (except the last) based on values in the worksheet. So the output would look something like this:

Capture.PNG

Is there any possible way to do this? As always, any help is greatly appreciated

Yes, it is.
It's a pitty, you have not shown code you use, because answer partially depends on ir.

If you generate TXT type body of mail (your outmail.body) you shall change this to HTMLBody


then somewhere in a body you shall have tags like

Please Login or Register  to view this content.

all tags have to be betwen "less than" and "greather than" characters, but as software of our forum do not like it I skipped them.
and here your first value shall be concatenated with the rest of the body
Sample of such approach is shown for instance here: https://stackoverflow.com/questions/...excel-contents note for instance how variable FinalRatioLCR is inserted into HTMLBody of OutMail (in your case not just variable, but your cell.columns(i).value)