Opening datasource for MailMerge

From: Kingsley (Kingsley_at_discussions.microsoft.com)
Date: 02/28/05 

Date: Mon, 28 Feb 2005 09:57:04 -0800

Any idea on how to use MailMerge with SQLServer wiil be appreciated. The ff
code results in error mesage that DataSource can't be opened.

object sDBConnection = "server=(local);database=Northwind;Integrated
Security=SSPI;";
object query = "select * from [Customers]";
string DSName = "C:\\Program Files\\Microsoft SQL
Server\\MSSQL\\Data\\northwnd.mdf";

WordDoc.MailMerge.OpenDataSource(DSName,ref format,ref Unknown,ref
Unknown,ref TRUE,ref Unknown, ref Unknown,ref Unknown,ref Unknown,ref
Unknown,ref Unknown,ref sDBConnection,ref query,ref Unknown,ref Unknown,ref
SubType);

Loading