PublishObjects To A String?
 

We're using PublishObject to generate a htm file from an Excel, that we are
then opening and converting that htm file to a text string to be used as the
..bodyHTML of an Outlook note.

Has anyone figured out a way to specify that the .Filename property of
PublishObjects should somehow be directed to a in-memory object that can
contain the html text string so the write / read of the html file can be
avoided?

Thanks for any insights on this!

James Cox