PDA

View Full Version : Use text from embedded object



Texasd
07-17-2008, 11:16 AM
Hi All!

I have an Excel workbook with code to generate an Outlook email. The body text of the email is predefined and needs to be in a specific format. Copying and pasting the text from Excel does not retain the formatting. HTML retains the formatting but is not user friendly for changing fields within the body. I need both capabilities.

I added the text into an embedded Word Document which does retain the formatting but am unable to copy the text and paste into the email with my limited knowledge.

I can get the code to open the object but then I am stuck!

Is this possible?

Thank you,

Donna