Exporting report to Word "template"?

[bluedollar]

I have a report that I export to word, using the following line of code:

DoCmd.OutputTo acOutputReport, "po", acFormatRTF, file_name, True

However when the report is exported the graphics that I have in my headers and footers of the report do not show up in the word doc.

What I would like to do to resolve this is:

1) find a way to succesfully export graphics from reports to word docs

OR

2) export the report into a word doc "template", that has headers and footers set up, and then 'save as' that doc as the variable file_name.

I really don`t want to go down the route of having to do this in mail merge, it would save loads of time if I could succesfully export the report, that I already have working.

Any help/ideas would be greatly appreciated.

NB. I am using access 2000.

Thanks

Dan

 

[fredk]

I don't know if you need to use word, I use the snapshot format which leaves all of the formatting in place - only two problems with this:

1. cannot be modified
2. everyone you send it to must have the snapshot viewer

There are no big deal to me and it works fine. Actually, I have on recipient who likes to chop up my data and he can't - this is a good thing in my situation since I would rather him not be able to chop it up and re-use it.

Fred

 

[bluedollar]

Fred thanks for the help, but in this situation the users want the report to be:

1) exported into word, so that they can make small formatting changes etc...

2) for that word document to be saved automatically as a variable that is called file_name.

This is what they want, and in the company that I am developing it for the users are king

Thanks

Dan

 

[fredk]

sorry I could not help - I have seen previous posts asking the same question and have not seen anyone reply with a solution -

Sorry I could not help -

Fred

 

[RoyVidar]

Did a quick keyword search here on TT.

This thread seams to have a couple of links to approaches that might be used.

thread703-525420

HTH Roy-Vidar

 

[bluedollar]

Thanks for the help, looks like it is impossible to do what the users want to do, unless I use mail merge.

I wonder why microsoft have not got this working?

Thanks

Dan

 

[TomCologne]

RoyVidar is right. In that thread is a link to Stephen Leban's site with a lot of useful sample dbs for download.
Look here:

http://www.lebans.com/toc.htm

under "Export to Word".

TomCologne