Problem querying SQL Server View as mail merge source

Hi,

I'm using the following code to perform a mail merge from an Access project:

With docMailMergeSource.MailMerge
..MainDocumentType = wdFormLetters
..OpenDataSource Name:=datasource path, _
Format:=wdOpenFormatAuto, ReadOnly:=True, LinkToSource:=False, _
ConfirmConversions:=False, _

SQLStatement:="SELECT * FROM dbo.WelcomeLetterMailMerge_V WHERE
AgreementDate = 'Sep 1, 2001'", _

Connection:="DRIVER=SQLServer;SERVER=SOMESVR;UID=d eveloper;PWD=;APP=Microsoft Data Access Components"

..Destination = wdSendToNewDocument
..Execute
..MainDocumentType = wdNotAMergeDocument
End With


The problem I'm having is with the SQLStatement. As is, I get a word is
unable to open datasource error. If I change it to "SELECT * FROM
dbo.WelcomeLetterMailMerge_V WHERE 1=1", everything works fine, but I don't
have any date constraint. Am I representing the date in an incorrect format?
If I paste the query into Query Analyzer, it runs just fine. I've tried
using # marks, and double quotes to surround the date, but haven't had any
luck.

Any Suggestions?

Thanks,

Todd

Well, it depends on how the date is formatted in your
table. My format is usually __/__/__, so the criteria
will show up in the SQL statement as follows:

((yourdatefield)="1/1/04")

If it's as text and believe me I've seen it done, you
would need to make sure that how you type it is exactly
how it is in the database. In order to get a parameter
value window open to choose what dates you want I usually
just put [Date] or Between [StartDate] and [End Date] in
the criteria field.

If you are worried about how your date will look in your
merge fields once merged into Word, here's a tip.
{MERGEFIELD YOURDATEFIELD \@ "MMMM d, yyyy"}
How to add this formatting to your Word Doc, hit Alt + F9.


-----Original Message-----
Hi,

I'm using the following code to perform a mail merge from
an Access project:

With docMailMergeSource.MailMerge
..MainDocumentType = wdFormLetters
..OpenDataSource Name:=datasource path, _
Format:=wdOpenFormatAuto, ReadOnly:=True,
LinkToSource:=False, _
ConfirmConversions:=False, _

SQLStatement:="SELECT * FROM
dbo.WelcomeLetterMailMerge_V WHERE
AgreementDate = 'Sep 1, 2001'", _

Connection:="DRIVER=SQLServer;SERVER=SOMESVR;UID= developer
;PWD=;APP=Microsoft Data Access Components"

..Destination = wdSendToNewDocument
..Execute
..MainDocumentType = wdNotAMergeDocument
End With


The problem I'm having is with the SQLStatement. As is,
I get a word is
unable to open datasource error. If I change it
to "SELECT * FROM
dbo.WelcomeLetterMailMerge_V WHERE 1=1", everything works
fine, but I don't
have any date constraint. Am I representing the date in
an incorrect format?
If I paste the query into Query Analyzer, it runs just
fine. I've tried
using # marks, and double quotes to surround the date,
but haven't had any
luck.

Any Suggestions?

Thanks,

Todd

.