Linking Access Query or Table to MS Word document

[mburns]

Hello all-

I was wondering if it is possible to link an Access query or table to a Word document and pull specific information into Word by manually entering a unique identifier, which would then pull all related fields from Access to the Word document. My goal is to develop a Word template that pulls certain fields from an Access query or table. For example, some of the fields I would like to pull from Access are [Last Name] [First Name] [SSN] [Address] [Company] etc..... But I would like to pull the information into Word based on a unique identifier like [SSN].

Is there a way to manually enter an individuals [SSN] into the Word template and then the other fields [Last Name] [First Name] [Address] [Company] related to the [SSN] pull in automatically to the Word document?

The best way I can explain it is like this.... using a lookup function from Access to Word (or Word to Access).... Lookup the [SSN] and pull in all related fields for that specific client.

Side note – I have very little experience using VB…. I apologize for my ignorance….

Thank you for your help......

[ADezii]

You may want to look into a Word Mail Merge.

[NeoPa]

As ADezii says, Mail Merge (a standard component of MS Word) will handle all this and more for you. Welcome to Bytes!