Access Mail Merge with Word

[mcgettrick]

I am using MS Access 2000 and have a customer database. I want to be able to merge individual customer records with a MS Word document. At the moment when I merge an Access customer record with a word mail merge document - the "merge" scrolls through all the Access customers up to the customer record no. that I have input in the mail merge (merge from - to).
Can I bring up the individual customer record in Access and press a mail merge button to merge this customer's record with a word document only

Mant thanks


Mike

 

[Telsa]

This might work... have the record open in a form and attach this to the OnClick event of a button to create document. UniqueID would be the field that makes that record unique to all other records. And of course, D:\word.doc is where you would specify the location and name of the doc to merge.

Dim oApp As Word.Application
Dim strNum As String

DoCmd.GoToControl ("UniqueID&quot

Set oApp = GetObject(, "Word.Application&quot
oApp.Visible = True
oApp.Documents.Open "d:\word.doc"

HTH

Mary