Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > MailMerge OpenDataSource Connection
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 10th April 23:38
binqing
External User
 
Posts: 1
Default MailMerge OpenDataSource Connection


I am trying to use the OpenDataSource function and Connection argument
to access the SQL Server to get data for a MailMerge. The options I
found is using OLEDB, ODBC, DDE, and ODSO, but none from them is my
option - my application needs to be installed in the final user machine,
so set up ODBC connection for each every of them is really not a good
idea. So it is very much appreciated if any one here can provide some
advice on non-ODBC connection in this situation.

strCon = "DSN=myDSN;DATABASE=myDB;uid=myuser;pwd=mypass ;"

objDoc.MailMerge.OpenDataSource Name:="", Connection:=strCon,
SQLStatement:=strSQL, subtype:=wdMergeSubTypeWord2000

Thanks in advacne


--
Posted via http://dbforums.com
  Reply With Quote


  sponsored links


Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666