How do I link/export an address from Access into Word document?

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

Guest

Streamlining paperwork preparation for a small law office that generates two
kinds of word documents: those that go to clients via snailmail and those
that get put into Adobe Acrobat to send to court electronically.

Current dBase III database will get put into Access 2003. Goal is to reduce
retyping of info such as addresses. The letters that go to clients will stay
in Access, but the letters that will go to court electronically will stay in
Word.

Can I link the Access info directly into the Word document or do I have to
cut and paste?
 
Virginia

You can create a query in Access that returns the Name/Address information,
and use Word merge to "get" the results of that query.

Another approach is to use Access to generate a text file, and Word merge to
read the text file and get the results that way.

A third option is to use automation in Access to open Word, using data from
Access.

How much time do you have? How much experience? All are possible, but some
require much more effort.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top