VBA code Excel to Outlook email truncating cells

Hi,

I have some code to create an email in Outlook (which I "stole" and adapted from somewhere else - I don't remember where).

The body of the email comes from some cells in a spreadsheet. It works OK except that the cells are truncated to the width of the cell that they are in (and it loses some formatting but I can live with that).

i.e. the text in the cells is ~190 characters long but only ~ 20 are appearing in the email.

I can't widen the column in the spreadsheet as it looks crap and will affect other parts of the spreadsheet.

Any ideas?

For some reason it won't allow me to post the bit of code that has the email address here - telling me I'm not allowed to post links, images or videos. I have made it so it doesn't look like an email address

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hi,

what if you just widen the columns in the code RangeToHTML in the beginning and in the end of this macro you set it back to normal width?
Then you should have the right text in your email.