Attached is a sample Excel spreadsheet. Column A (yellow highlighted range) has some text across multiple rows. I would like the user to be able to be able to select this text and copy / paste it into Outlook. Currently if I do this, it's pasted into Outlook as a column of rows. I want to be able to paste it as 'normal' email text - formatting preserved.
I thought I could do this my creating a message box, however I can't select message box text to copy it directly to Outlook.
Is there another solution that allows me to copy and paste this text, preserve bolding - but strip out the table formatting?