Export file to Word

[HUNG]

I have created a report with boxes, company logo image and shading attributes. When I export this to WORD97 or Rich Text Format, all these attributes disappeared.
How can you export a report into WORD97 without losing your images and boxes defined in the ACCESS report design ?

The save as option with office link do not work.


[This message has been edited by HUNG (edited 01-10-2000).]

[This message has been edited by HUNG (edited 01-10-2000).]

 

[sandet]

Try selecting your report, clicking Tools, Office Links, Publish it MS Word. This worked for us.

 

[Roni Sutton]

I was interested in your answer because I have a similar problem with a report that contains both an Access generated graph as well as text. I tried your suggestion, but the graph did not transfer over to the rich text format file that was created. Anyone have any ideas? If so, it would be GREATLY appreciated.

 

[HUNG]

For my purpose, I was successful with Mail Merge feature within WORD.

 

[lnoles]

I tried this with my report, but, the formatting and lines and boxes did not carry accross.
What I need is for the report to be in a format where I can email it to several people and they can see the report without having to have the entire database.
I suppose I could use Mail Merge, but, I do some calculations on the report that would make it difficult to merge directly from the database to the Word Doc.
Any Suggestions?

 

[intrep11]

export to snapshot

Export the report to a snapshot format and email that there is some code int he forums that will do that for you that is where i got it from to do mine

 

[The_Doc_Man]

Your problem, in a nutshell, is that Access is not a word processor.

When you export a report to Word, it gets exported as .rtf, not as .doc, so it instantly loses anything not supported in .rtf files. Access ain't smart enough to do it the right way. So your observed symptom is correct.

The only way to make a .doc file from Access AND RETAIN FORMATTING is to do a mailmerge operation.

But if nobody needs to actually do anything except look at the file, you could export it as an image. When you do, the image becomes uneditable.

The reason you have to do a mailmerge is a basic principle as applied to this case: The only way to do something right is to do it yourself. The "applied" form of this statement is : The only way to build a Word document right is to let Word build it itself. Which is exactly what a mailmerge does. If you try to let Access do it, you already know that Access gets it wrong.

 

[rbrule]

We had the same problem. Our solution was to get a PDF writer. We used ScanSoft PDF Create. It cost about $40. Now we just save as a PDF and email as an attachment.

rbrule

 

[suepowell]

Hi,

What I love about this forum, is that you can always, well almost always, get the answer you need.

I too have a report that my customer wants to e-mail, and I now know I will have to export as a snapshot, or mail merge.

A few questions to clarify my thoughts on which way to go.

1. Can snapshots be viewed on a PC without access?
2. Can I produce a snapshot programatically, so my customer just has to press a button. If so a pointer to the command would be useful.
3. When mailmerging, I presume I will have to save the source of my access report as a query and merge from that. How would I set the criteria, at the moment the report is called from a form where the criteria are entered.
4. The fields in my report can grow for larger amounts of data, I was thinking a using a custom size label layout for my word document, as I don't want a new page for each record, can this cope with different sized data fields, or do I need a diferent technique.
5. Finally can I mail merge to Word from access programatically, just by putting code behind a button, if so what commmands do I need.

Thanks in anticipation

Sue

 

[xili]

What are you guys talking about Mail Merge? Is that mail merge wizard within the WORD? but that is just used for sending document to a bunch of recipents. How could we use it for keeping format & graphs of my generated report from ACCESS. I didn't get it. Could some one explain how to use this feature? Many thanks!

 

[reclusivemonkey]

It IS possible to get a Rich Text Format report with formatting on from Access. I had created such a export many times and up until recently it had worked fine. All there was on the report other than the data was a logo (.jpg) and lines, both of which appeared on the .rtf exported report (You can try this by putting a picture and some lines in a Word document then save it as .rtf). However, the IT department came along and changed the name of my machine and a whole host of stuff stopped working. I have been upgraded to windows XP now, but this hasn't corrected the exporting to how it was before. Its very frustrating when you know it is possible but there aren't any obvious ways to remedy it.