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
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