Any luck with exporting access to a word doc

[Joe8915]

Has anyone had good luck exporting from access to a word doc? I have several standard letters, that has to go out to various contacts, with differen't information per contact.

As usual, I have all the info in access, now I have to export to word doc. I know there is some software that will do it, but I am sure someone has done this before in access and word.

 

[statsman]

Create a report in the form of a letter. Export it as an .rtf file. You can open in Word.

Easier way would be to create a Query that meets your needs. You can do a mail merge in Word and insert the appropriate fields.

 

[Steve R.]

Actually, I do the reverse. I have set-up word templates and imported the data FROM ACCESS into WORD. Depending on what you are doing, this may be a simpler approach.

 

[Len Boorman]

I generally just dreate a report in Access. That way if it is a standard letter I can create them on demand with no exporting, merging or other bits that can go wrong
L

 

[The_Doc_Man]

Joe, as long as it is a simple letter or maybe at most contains a tabular report, you have several approaches.

Don't forget that while it is not necessarily meant as a word processor, Access can indeed do simple paragraph formatting. So you could build,for example, a big Memo box - with no special borders or background - if all you wanted was verbiage. Then put that in your report header and/or trailer.

But if you are talking "mix and max" insertion of text in the body of your paragraph, Mail Merge is the way to go.

 

[Joe8915]

I think you are right, working on the Mail Merge now.

Thanks for everyone input