MS access to RTF, How do I use normal.dot

[Mark Barber]

I currently use Access to produce letters to using send report to word RTF,
this is problematic as it does not use our Normal.DOT template, and our
formating is lost when text is removed - how do I overcome this?

 

[Rick B]

RTF formats of reports are NOT "word" formats, they are "Rich text formats"
Many style elements will be lost. RTF was not intended to preserve all the
formatting.

As far as I know, there is no way to open a report in Word and have Word
automatically change it to the normal.dot settings. You could run a macro
in Word to apply formatting after you open the report in Word. You could
copy the text once it is in Word and then paste it into a new blank document
(maybe).

Hopefully someone else will have a suggestion, but I think you may be out of
luck.

 

[Mark Barber]

I would have to do this programmatically, as this database has many users and
we produce many letters, and automated from within Access VBA to copy/paste
into template. But don't know how