excel workbook to copy word document and format in email body

[Dabbler39]

I have been working on this for a week now and can not find a solution in any forums. I am technically a newb and self taught excel'r. I have been working with vb for about 5 years now, but mostly hack my way through it.

I am trying to copy a word document from excel and paste that document in my email body whilst retaining the source formatting from the word document. My current code is as follows and puts the document in the email body but will not format obviously. I have tried so many different options. However, this code works, but does not format it properly. Any help would be much appreciated. The highlighted section is where i crash.

Thanks in advance.

Darren

Please Login or Register  to view this content.

[Dabbler39]

Thank you for any help you may be able to give me on this.