K
Kingsley
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);
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);