Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When joining tables, table sections shift left or right. | Tables | |||
Merge data into one document from several tables in Access. | Mailmerge | |||
How do you merge two Access databases into one set of tables | Microsoft Word Help | |||
Linking Excel data to tables in Word | Tables | |||
Merge Data Source path | Mailmerge |