DanOfEarth
06-02-2010, 06:37 PM
In Excel, I've got a button in a telephone prospect list that will fire up Outlook and shoot out an email using the text written on a spreadsheet as the "body".
It's a bit sloppy. I'd like to copy the entire "body"....formatting and all....out of a word doc instead. I've got all the code to do this, but I'm rigging it a bit.
I've highlighted the whole text part, "bookmarked it" named Get Data, and wrote the following code:
TempString = wrdDoc.Bookmarks("GetData").Range.Text
ReDim Preserve myArray(j)
myArray(j) = TempString
But I don't think it saves the formatting. Anybody know of a better way. The text includes several paragraphs, etc.
It's a bit sloppy. I'd like to copy the entire "body"....formatting and all....out of a word doc instead. I've got all the code to do this, but I'm rigging it a bit.
I've highlighted the whole text part, "bookmarked it" named Get Data, and wrote the following code:
TempString = wrdDoc.Bookmarks("GetData").Range.Text
ReDim Preserve myArray(j)
myArray(j) = TempString
But I don't think it saves the formatting. Anybody know of a better way. The text includes several paragraphs, etc.