Merged Database with Word

  • Thread starter Thread starter CGC
  • Start date Start date
C

CGC

Our office enters info in to an Access database which is
merged with Word to send out billing letters. Apparently
the author improperly set the procedure up using a
database on a now obsolete server, hence, the merge cannot
be accomplished. How do I redirect the merging process to
the correct database (of the same file name) on the
current server?

Thanks,

Chris
 
Hard to tell exactly what the problem is based on the information, but
this may help.

Is there any problems with linked tables? You may need to relink one or
more table.

In Word the merge document may need to find the data file (see Word's
"Find Data Source")

In addition it is possible there may be something hidden in a Word macro
that may have been lost when it lost a "DOT" template file.

Last you may want to check out all the code behind any execution
routines in Access.

If you have someone knowledgeable in Access and Word they may be able to
hunt it down. I may be very helpful for them to take a close look at
another database or two developed by the same person to get a feel for how
they work. We tend to use the same tricks over and over.
 
Open the MailMerge doc in Word and use the MailMerge Helper (in the Menu
Tools / MailMerge ...) to re-assign the DataSource for the Word document.
You may also need the Query Name (or Table Name but more likely a Select
Query) that was used as the DataSource since in an Access database file,
there are many objects that can be used as the DataSource for the MailMerge,
namely Tables & Queries.
 
Back
Top