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......
