Mailmerge Recipients doesn't work with SQL Server

[Gelatinous_Blob]

I am attempting to filter records from a View in an SQL Server database using
the Mail Merge Recipients window in Word 2002 (SP3). I am attempting to
filter on a date range (e.g. registration_date > 01/08/2004).

None of the query options get applied - instead Word returns all records in
the table. Is anyone aware of a work around? Is this a known issue with Word
2002? Or am I overlooking something obvious?

 

[Gelatinous_Blob]

I see now that it is a problem with date formatted fields. But I still don't
know how to format the fields correctly in the SQL View in order to get them
into a format that Word 2002 can read successfully.

Any ideas?

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?R2VsYXRpbm91c19CbG9i?=,

I am attempting to filter records from a View in an SQL Server database using
the Mail Merge Recipients window in Word 2002 (SP3). I am attempting to
filter on a date range (e.g. registration_date > 01/08/2004).

None of the query options get applied - instead Word returns all records in
the table. Is anyone aware of a work around? Is this a known issue with Word
2002? Or am I overlooking something obvious?

01/08 as in month/day, or day/month (American or European data format)?

You should be able to go through the "Advanced" selection in a Recipients
dropdown list, select the data field under the "Filter" tab of the Query
Options, then specify a date. As I recall SQL Server requires dates be specified
in American date format (mm/dd/yyyy); but I could be misremembering. If that's
the case, then try yyyy-mm-dd. You do need to specify the year.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
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