Hi ?B?Qm9k?=,

From the sound of it, you're connecting to SQL using ODBC rather than OLE DB?
Have you tried OLE DB?

The SQL ODBC driver + Word mail merge does not recognize unicode (nvarchar).
And there are also problems with date formats.

If you want to continue to connect in this way, include the date formatting
and field type conversion as part of the View definition.

I am using a SQL Server View (combining fields from 3 tables) as the data
source for a Mailmerge. If a field is defined as nvarchar in the SQL table
it does not appear in the merged document, but if the definition is changed
to varchar it merges correctly. Why is this?

Also a field defined as datetime in the SQL table refuses to accept format
switches -

{MERGEFIELD Tx_Date \@ "dd/mm/yyyy"}
{MERGEFIELD Tx_Date \@ "yyyy.mm.dd"} etc...

Always appears in the document as

04/12/2004 00:00:00

Why is this?

(I'm using Office XP (Word 2002) and SQL Server 2000 if that matters)


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