dlookup an MS Access 2003 table record from within MS Word

Hi experts,

Please could somebody advise if I can have a word document in the same folder as an access 2003 database and display text in the word document from a field in a table within the access 2003 database? For example, maybe a DLookup or similar can be done in Word referencing the database table?

Regards

Terry
TerenceHewettAsked:
Who is Participating?
 
Nick67Connect With a Mentor Commented:
There isn't really anything to code.
If you fire up Word Help and search mail merge, it will walk you through doing it.
I'll create a very small db and Word document and post them.
These things get VERY dependent on file location.
Put them both in a folder c:\tempMerge and play with them.
Test-Merge.doc
Merge-Data-Source.mdb
0
 
TerenceHewettAuthor Commented:
From what I am reading on the web, it looks like a mail merge could do this for me, but I am not sure how to code this.  Could anybody either help with the mail merge code or provide other help on the original question?

Thanks

Terry
0
 
TerenceHewettAuthor Commented:
Thanks Nick for your help.  The sample files really helped me understand.

Regards
Terry
0
 
Nick67Commented:
Not a problem.  Is there anything that needs clarifying?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.