Duplicate files returned when performing merge with a parameter query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve - 21 Apr 2004 15:21 GMT

When I perform a mail merge with a parameter query using
Word and Access 2002, I get the first line duplicated. I
have looked at Knowledge Base Article 286847 and this is
not what I am getting. The query extracts data from a
table in access. The table has only one entry for the
first line.

Reply to this Message

Cindy M -WordMVP- - 21 Apr 2004 17:43 GMT

Hi Steve,

I guess the first question we need to ask is: are you
explicitly using a DDE connection for this merge?

The next would be: when you view the query result directly
in Access, do you see the correct result?

Could you go into the SQL view of the query and copy/paste
the SQL statement into your answer, please?

> When I perform a mail merge with a parameter query using
> Word and Access 2002, I get the first line duplicated. I
> have looked at Knowledge Base Article 286847 and this is
> not what I am getting. The query extracts data from a
> table in access. The table has only one entry for the
> first line.

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

:-)

Reply to this Message

- 21 Apr 2004 20:38 GMT

Hi Cindy,
I do see the correct answer when I view the query in
Access. I did figure out that if I unselect the "view
table names" in query options it stops the duplication. I
am using a DDE connection explicitly. This work around
suits my needs. Do you still want me to paste the SQL
view? Hopefully this may help someone else. Thanks a
millon for helping!

Steve

>-----Original Message-----
>Hi Steve,
[quoted text clipped - 26 lines]
>
>.

Reply to this Message

Cindy M -WordMVP- - 22 Apr 2004 17:59 GMT

> I do see the correct answer when I view the query in
> Access. I did figure out that if I unselect the "view
> table names" in query options it stops the duplication. I
> am using a DDE connection explicitly. This work around
> suits my needs. Do you still want me to paste the SQL
> view?

Actually, yes, please. I can't remember ever hearing about
this happening, before. I just tested on Word 2003, didn't
see the problem, so then tried Word 2002 and still didn't
have the problem. So maybe the SQL (of the original, problem
query - IF it's still happening when you change back) might
help track down what's going on.

Also, could you please check Help/About in either application
and note down the exact build, version and SP numbers?

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 :-)

Reply to this Message