Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Bod
 
Posts: n/a
Default Mailmerging data from SQL Server tables

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)

Cheers
 
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
When joining tables, table sections shift left or right. JEB01 Tables 1 January 17th 05 07:57 PM
Merge data into one document from several tables in Access. Professor Wise Mailmerge 1 December 2nd 04 10:40 PM
How do you merge two Access databases into one set of tables Charles, UVA Health System Microsoft Word Help 0 December 2nd 04 09:25 PM
Linking Excel data to tables in Word KSit Tables 3 November 26th 04 09:36 PM
Merge Data Source path Peter Jamieson Mailmerge 0 November 25th 04 07:15 PM


All times are GMT +1. The time now is 10:01 AM.

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"