Combine several RTF texts into one RTF file using VBA

Question

I'm extracting 'task notes' from MS Project using VBA and want to create a MS Word .DOC file and also copy those texts into EXCEL.

If you use the Notes property of the Task objects you only get 255 characters and formatting will not not be retained. In order to keep formatting you can convert the .MPP file into .MPD and extract the notes. These notes have been stored using rtf (see PJDB.HTM look for 'sub getRtf'). This way I can extract all notes and write them into a .rtf file. If I open that file (containing multiple notes [i verified]) using MS Word I ONLY see the first note (and it has been formatted well). Info I gathered from other sites learns only ONE rtf text in a file will be handled and it is NOT trivial to join several rtf texts.

So my question is: does anyone know how to combine several rtf lines into ONE rtf text.

I prefer answers using VBA.

Of course, if anyone knows how to extract notes from MS Project and create a .DOC file preserving formats it's ok as well

Answer 1

This is probably not the right answer but you could do this in VBA :

For each RTF files, open and save to the clipboard as rich text (via API), and paste in word.

It's ugly but it works.