I've been fiddling around with automating Word from Excel.
(This is an MS Office forum.)
I just noticed that you said your original file is in .rtf format.
Is this a TextEdit file?

AppleScript might be a better way than VBA.

Could you attach the .rtf document?