How to copy table from Outlook mail body in to text file

Hi,

I am using a vba script in excel to copy a table form a worksheet on to an outlook email with its formatting intact. After having sent the email, I receive a reply along with the same table still in the body of the email; however, when I use the code below to write the body of the email to a text file, each cell in the table is written to a new line which ends up as a very long and scattered text file. Is there a way to copy each row as a line as opposed to each cell as a line?

Thanks in advance.

Please Login or Register  to view this content.