T
TG
I'm attempting to insert a Word document into the body of an Outlook email
created by the Outlook mail object in an Excel worksheet. Essentially, the
user clicks a name in the workbook and an email pops up with the contents of
a shared Word doc as the body.
Having all sorts of problems with the mail object reading carriage returns
as EOF markers, as well, it can't handle the bulleted list the document's
author really wants to be included. I have experimented (successfully) with
removing the carriage returns, replacing them with "~" in the original txt
file, and then replacing the "~"'s with vbcrlf's once the object is fully
read and into a string variable. Unfortunately, the formatting from the
original text is all but gone using this method. Not good.
Can someone tell me in general terms what tree I should be barking up to to
get this accomplished?
Thanks for any help at all!...Ooogy
created by the Outlook mail object in an Excel worksheet. Essentially, the
user clicks a name in the workbook and an email pops up with the contents of
a shared Word doc as the body.
Having all sorts of problems with the mail object reading carriage returns
as EOF markers, as well, it can't handle the bulleted list the document's
author really wants to be included. I have experimented (successfully) with
removing the carriage returns, replacing them with "~" in the original txt
file, and then replacing the "~"'s with vbcrlf's once the object is fully
read and into a string variable. Unfortunately, the formatting from the
original text is all but gone using this method. Not good.
Can someone tell me in general terms what tree I should be barking up to to
get this accomplished?
Thanks for any help at all!...Ooogy