Reply
 
Thread Tools Display Modes
  #1   Report Post  
Gelatinous_Blob
 
Posts: n/a
Default Mailmerge Recipients doesn't work with SQL Server

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?

  #2   Report Post  
Gelatinous_Blob
 
Posts: n/a
Default

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?

"Gelatinous_Blob" wrote:

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?

  #3   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

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

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Moved files to new computer and macros don't work Tserch Microsoft Word Help 2 December 29th 04 11:29 PM
How To Make Numbering Work Right? Peyton Todd Page Layout 2 December 17th 04 07:53 PM
Trying to make numbering work... Peyton Todd Microsoft Word Help 5 December 16th 04 08:12 PM
The remote server machine does not exist or is unavailable on Mail Merge Vic Spainhower Mailmerge 7 December 6th 04 04:03 PM
Mailmerging data from SQL Server tables Bod Mailmerge 2 December 5th 04 08:29 PM


All times are GMT +1. The time now is 10:52 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"