Hi All,

So I’m using the Mail Merge class that I got off of the “Thread” and it works fine. I do have one problem; Word 2000 comes up with “Confirm Data Source”. This isn’t too much of a problem because all of the choices work. However, it would be nice not to have that come up.

Thanks,
Dennis


Not all of the code but, enough for you to get the drift….


cDSN = "DSN=FoxPro Files;DBQ="+lcDefDir+";DefaultDir="+lcDefDir+";"
cSourceDB = ""
cSourceType = "DBF"
cOther = "DriverId=536;MaxBufferSize=512;PageTimeout=5;"
cDataSource = dbf(lcFreeTable)
cSQLStatement = "SELECT * FROM "+lcFreeTableName+".dbf"

oWordDocument.MailMergeOpenDataSource(cDatasource,,, 1 ,,,,,,,;
,cDSN+cSourceDb+cSourceType+cOther, cSQLStatement) && Open data source - Link to source