View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Remembering associated database

Take the steps to eliminate the SQL warning and then save the mail merge
main document after attaching the data source to it.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Allison" wrote in message
news
XP Professional SP2, Word 2003 SP2:

I have a mail merge document created in Word 2003 that calls fields from
an
Access 2003 database.

Each time the document is opened, I have to reconnect the database to the
document. Nobody else uses either file but me.

Both the database and the merge document are in the same directory/folder.

I get the SQL warning, which is okay (and I saw the KB article on how to
disable that). But, when pressing "Yes" to allow the connection, I'm then
presented with a dialog box where I have to browse to my database each
time
to establish a connection.

Could you please point me in the direction of where to find a solution for
permanently connecting the source data to the merge document? Thank you.