Hello


Using Office 2002 SP-2, Windows 2000 V5.0 SP-4.

One of my users set up a mailmerge document for printing labels and has
been using this successfully with an Access table created using a Make
Table query. Originally the table used to create the mailmerge table was
an Access table but, due to corruption problems, we had to move it out to
SQL Server 2000.

The Make Table query still runs successfully, producing a correct table.
The problem is that, when the user merges this table to Word, empty values
in the Counter field are replaced with values from this field in other
records. e.g. the last value in the Counter field is 7625, so all records
that do not contain a value in the Counter field are given the value 7625
as well.

I have checked the data source from within Word and the result set looks
normal, i.e. the blank values are blank. however, when you actually run
the merge, Word is refusing to allow these fields to stay blank on the
document.

This problem only began appearing after we changed to a SQL Server table.
The resulting table from the query is still an Access table but now the
merge misbehaves. The Counter field has a numeric type in SQL and a number
type in the resulting Access table.

If anyone has any suggestions I'd be very grateful.

Many thanks

Denise Crawley