Hello,
I have a macro which works correctly to import data into an outlook email. The one issue is that the spacing of the imported data is often off by a few characters.
For example, this is how it would display now:
But I would like it to display like this, as if they were TABBED with all the beginnings aligned with the headers.
I am using HTML to have the data in my code and the spaces are generated using " ". It is in this format:
Any suggestions on how to accomplish this?
Thanks!
I have a macro which works correctly to import data into an outlook email. The one issue is that the spacing of the imported data is often off by a few characters.
For example, this is how it would display now:
But I would like it to display like this, as if they were TABBED with all the beginnings aligned with the headers.
I am using HTML to have the data in my code and the spaces are generated using " ". It is in this format:
VBA Code:
TempBodyItems = TempBodyItems & "   " & .Cells(Arr(Cnt), Range("Cases_Ordered").Column) & "       " & .Cells(Arr(Cnt), Range("Product_Code").Column) & "     " & .Cells(Arr(Cnt), Range("Product_Description").Column) & "<br>"
Any suggestions on how to accomplish this?
Thanks!