inserting ACCESS fields in a word document

[Guest]

I have a WORD letter I use each month. The name of the person to whom it is
directed changes frequently in this (and other letters). Is there a way to
get a field(s) from an ACCESS table - possibly in a drop down box - to
insert in the letter when I get ready to print it? I'm sure it is possible,
but
frankly the info provided by WORD help is not a lot of use.

In addition, what is the best "text" book on WORD 2000 available in
bookstores.

Dot

 

[Doug Robbins]

See the article "How to create a
Userform" at:

http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm


The the following routine will populate a listbox or combobox with data from
an Access database

Private Sub UserForm_Initialize()
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim NoOfRecords As Long
' Open the database
Set db = OpenDatabase("D:\Access\ResidencesXP.mdb")
' Retrieve the recordset
Set rs = db.OpenRecordset("SELECT * FROM Owners")
' Determine the number of retrieved records
With rs
.MoveLast
NoOfRecords = .RecordCount
.MoveFirst
End With
' Set the number of Columns = number of Fields in recordset
ListBox1.ColumnCount = rs.Fields.Count
' Load the ListBox with the retrieved records
ListBox1.Column = rs.GetRows(NoOfRecords)
' Cleanup
rs.Close
db.Close
Set rs = Nothing
Set db = Nothing
End Sub


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP