MsAccess And MSWord

[Milan]

I have an access database which has a table with names and address . This table is bound to a form which i use to navigate through the records. What i want to do is when i am on the current record i want to be able to transfer the current name and address fields to Microsoft word using a command button. This button will open word and insert the current record in word. which would save me having to type the name and address in word once i have found the name and address of the person i am looking for. Any Bright Ideas!!!!


Many Thanks!!!

 

[Fornatian]

Output a parameter query to a delimited text file then set up your merge document to merge with the delimited text file.

Set the button code to: a) output query to textfile b) hyperlink to your word document using Application.FollowHyperlink "PathToFile"

 

[cogent1]

You can also use Automation to enter fields into bookmarks in a Word template. In one operation, you can open Word, insert the fields, print the document and save it. This might be worth investigating if you are only seeking to print one letter at a time.