Vba create table in outlook email html. This code sends only a one cell not a range. I know i need to use html tags but i'm not sure how. It works well but the next step is to make it look more professional. The data always begin on row 2 but the row containing the last data needs to be dynamic. Jun 24, 2013 ยท Hi - I am trying to create an automatic email mailing for a report. I am struggling to place the values into proper columns. My code looks like this: This code all works great. Let us assume, I have multiple tables in my Excel worksheet. You could use VBA to setup a temporary excel spreedsheet that formats the table in the correct format. Suppose you want to use VBA to copy the ‘SalesSummary’ range below on ‘Sheet1’ to an email body in Outlook as an HTML table. jxp uxpsiyp kbq bmc wntid hjxs xsbohz ffop qqquvkyp ezgxufik