Mail merger helper not inserting correct data into word document

[susieb]

I am working with Word and Access 2003 now. Have created the use of mail
merger helper and made sure that the word document is attached to the correct
database. However when I use mail merge helper / query options and enter the
appropriate information and then go to Merge - the information merged into
the document is incorrect. Where am I going wrong please?

 

[Peter Jamieson]

What kind of "incorrect" / Is it data from a completely different source, or
are sorts/filters not working how you hope/expect?

If you use the Word 2003 Mail Merge recipients dialog, do you see the
correct data or not?

Peter Jamieson

 

[susieb]

The data is from the correct source but the filter is not working as it
should. It would seem that the information placed into the document is the
first record that was entered into the database.
Susie B

 

[Peter Jamieson]

What sort of filter are you using? (in particular, is it a filter on a date
item)?

Do you use the same data source and filter all the time? If so, are you in a
position to add a query to the database (or can it be done for you) and use
that as the data source?

Peter Jamieson

 

[susieb]

I am trying to put information into an existing mail merge word document. I
bring up the mail merge helper and using query options I then set the field -
comparison- compare to as required. Then OK then merge and then merge to new
document - it is at this stage that the information placed into the document
is incorrect. I cannot understand why it will not work it has always worked
in the earlier version.
susieb

 

[susieb]

To add to my porevious reply - yes one of the filters is a date field - what
particular problems does this bring?
susieb

 

[Peter Jamieson]

There are some problems with filters on date fields with some data sources,
or rather, with some sources when accessed through specific connection
methods.

For any data source, Word constructs an SQL query from the file or database
name, the filter options, and the sort options. However, there are various
different dialects of SQL and Word sometimes does not generate the correct
syntax. Dates are particularly tricky because there are more variations
between the dialects.

In this case, it is almost certainly worth trying changing the connection
method - check Word Tools|Options|General|"Confirm conversion at open", go
through the connection process again, and choose one of the other methods -
if you previously used Word 97 or 2000, the DDE method works in much the
same way, but you may find that ODBC works too.

Peter Jamieson