Merging Access data into Word

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I need to generate performance standards for my employees. I have 9
employees, each having multiple performance standards. I have created an
Access database that reflects this structure.

I would like to merge this data into a Word document so that each employee's
name appears in the document with the list of performance standards for that
employee. I have been messing with this for hours and cannot seem to get it
to work.

Thanks,
John
 
You can do it using bookmarks in words

Create A word document, insert book marks where you want the value from
access should be insert, and then run this code

Public Sub PrintToWord()
Dim wd As Word.Application
Dim myDoc As Word.Document

Set wd = New Word.Application
wd.Documents.Add DOTpath & reportName & ".dot" ' The name and path
Set myDoc = wd.ActiveDocument
With wd.Selection
.GoTo wdGoToBookmark, Name:=BookMarkName ' The name of the book
mark
.Font.Bold = True ' You can choose if bold
.Font.Underline = False ' or underline
.TypeText Text:=ValueToInsertInTheBookMark ' insert values
End With
wd.Visible = True

End Sub
 
Back
Top