10th April 23:38
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,
Thanks in advacne
Posted via http://dbforums.com