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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark Barber - 15 Jul 2005 10:22 GMT

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?

Reply to this Message

Rick B - 15 Jul 2005 14:01 GMT

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.

Signature

Rick B

> 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?

Reply to this Message

Mark Barber - 15 Jul 2005 14:37 GMT

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

> 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
[quoted text clipped - 13 lines]
> > 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?

Reply to this Message