Mail Merge Problems

[Jason]

I am using access to perform a mail merge with word, i
export the data from a query, which will always be only
one record, I check the excel file and it writes to it,
but when the mail merge is suppose to happen, word does
not take in teh new data. It instead shows a file that
is old and was teh first file entered in the database, i
have not deleted that file and it still shows in word.
This only happens on one computer. When i used the
database on any other computer, it works fine. Is there
some setting in office or word that i am missing on this
one computer? I appreciate the help in advance. Thanks

 

[Guest]

I am using all office 2003

 

[Cindy M -WordMVP-]

Hi Jason,

I'm not certain I follow exactly what you're doing...

1. Why is there merge being done to Excel, rather than
directly to Access?

2. Does each machine use exactly the same document file as
the main merge document? Or does each have its own file?

3. When you say "the file is old..., I have not deleted
that file": How does the main merge document know to which
file it should merge? Does the user go and pick out the
file name? Or something else?

4. Are all users using version 2003; especially, though, on
this machine?

5. Do you know with which connection method the data is
being linked into the main merge document?

My first reaction is that this main merge document might be
damaged, and the user should get a new copy.

2003
I am using access to perform a mail merge with word, i
export the data from a query, which will always be only
one record, I check the excel file and it writes to it,
but when the mail merge is suppose to happen, word does
not take in teh new data. It instead shows a file that
is old and was teh first file entered in the database, i
have not deleted that file and it still shows in word.
This only happens on one computer. When i used the
database on any other computer, it works fine. Is there
some setting in office or word that i am missing on this
one computer?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail