I am trying to use an old Ron Bruin function to paste an Excel range into Outlook, but it's losing some of the formatting. It's an autoformatted table and while the header is formatting ok, the two tone table format is not (rows are just blank with values).

Any idea how I can paste these across?