Mailmerge

Wolfgang,

Thanks for your kind response. I changed DFC() and got past the error but I got a message from WORD:

Error in mailmergeword8(69): OLE IDispatch exception code 0 from Microsoft Word: Word was unable to open the data source.

I am wondering if the message prior (Unable to find FoxPro File ODBCDriver) is the cause?
I have tried putting the ODBC drivers I could find in the Windows and Windows32 folders but it didn't help.
Do you know the proper name of the driver and where it should be located?

I found this code in mailmergeword8 and it seems to be wanting the driver. Why would it be needing the ODBC driver
and connection string when the data source is a local view?

*- attach data file
oDoc.MailMerge.OpenDataSource(THIS.cDataSrc,0,0,0,0,0,"","",0,"","",m.cODBCSource,;
THIS.csqlstmt, THIS.csqlstmt2)

Wolfgang
Sat Jan 31 09:01:35 CST 2004

Hi Richard!
Did you install the OleDriver for Visual Foxpro?

--
_________________

MFG
Wolfgang Schmale

MS Visual FoxPro MVP

--------------------------------
"Richard" <rmellick@earthlink.net> schrieb im Newsbeitrag
news:AC77FF0E-F3F6-4546-ADBC-1C0C23B89C8F@microsoft.com...
> Wolfgang,
>
> Thanks for your kind response. I changed DFC() and got past the error but
I got a message from WORD:
>
> Error in mailmergeword8(69): OLE IDispatch exception code 0 from Microsoft
Word: Word was unable to open the data source.
>
> I am wondering if the message prior (Unable to find FoxPro File
ODBCDriver) is the cause?
> I have tried putting the ODBC drivers I could find in the Windows and
Windows32 folders but it didn't help.
> Do you know the proper name of the driver and where it should be located?
>
> I found this code in mailmergeword8 and it seems to be wanting the driver.
Why would it be needing the ODBC driver
> and connection string when the data source is a local view?
>
> *- attach data file
>
oDoc.MailMerge.OpenDataSource(THIS.cDataSrc,0,0,0,0,0,"","",0,"","",m.cODBCS
ource,;
> THIS.csqlstmt, THIS.csqlstmt2)
>

rmellick
Mon Feb 02 13:41:08 CST 2004

Hi Wolfgang

I have VFPOLEDB.DLL in the system directory. Is that the correct DLL

Thanks
Richard

Rick
Mon Feb 02 14:54:39 CST 2004

Richard,
The current OLEDB Driver is here - =
http://www.microsoft.com/downloads/details.aspx?familyid=3D0f43eb58-7a94-=
4ae1-a59e-965869cb3bc9&displaylang=3Den While it's listed as for VFP =
8.0, it works on ALL versions of FoxPro tables and databases. The =
internal version of VFPOLEDB.DLL I have is 8.0.0.3117. Note: It's in my =
C:\Program Files\Common Files\System\Ole DB\ folder.

Rick

"Richard" <rmellick@earthlink.net> wrote in message =
news:7AC29AF6-4B26-44C8-9C1B-E590FB4DB5BD@microsoft.com...
> Hi Wolfgang,
>=20
> I have VFPOLEDB.DLL in the system directory. Is that the correct DLL?
>=20
> Thanks,
> Richard

Leemi
Mon Feb 02 15:58:46 CST 2004

Hi Richard:

VFPOLEDB.DLL is the file for the VFP OLE DB provider. If you need the VFP
ODBC driver, you need the file called VFPODBC.dll. You can get this file
from the link in this article:

277772 INFO: Visual FoxPro ODBC Driver Not Included in MDAC 2.6 and Later
http://support.microsoft.com/?id=277772


I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
Purchase VFP8 here:
http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retires Sept. 30th, 2003


>Hi Wolfgang,

>I have VFPOLEDB.DLL in the system directory. Is that the correct DLL?

>Thanks,
>Richard

anonymous
Wed Feb 04 17:41:07 CST 2004

Thanks to all..

After much gnashing ot teeth and pulling of hair and downloading dll's, I found out (quite by accident) that if I go through the sequence of getting the "Can't find FoxPro files ODBC..." error and error #1429 in mailmergeword8(69): OLE IDispatch exception code 0 from Microsoft Word: Unable to open the source data... and without leaving the application doing the mailmerge again I get the "Can't find..." message again but Word starts and opens the source data and all is well

I am stumped. The code I am using follows: (cTable) is the view ROSTER

select field

APPEND FROM ARRAY gaMyArray fields fieldnam
DIMENSION gaTemp[gnFieldcount,1
COPY TO ARRAY gaTemp FIELDS fieldnam

SELECT (cTable

WITH THISFORM.mailmerge
.cAppTitle = "DPRS" && application name, used in Alerts
.nWordProc = 1 && word processor (1 = Word 6+; 2 = CommaDelim; or user-defined (see below); default = 1
.nNewDoc = 2 && is it a new doc (1 = new, 2 = existing; default = 1
.cDocName = "c:\mailtest.doc
.nTemplate = 1 && type of main document (Word only, 1 = form letter; 2 = label; 3 = envelope; 4 = catalog; default = 1
.cAlias = ALIAS() && alias of source table or vie
.cDBCTable = (cTable) && table name if table is part of a DB
.cDBCName = DBC() && DBC name if source table is part of a DB
ACOPY(gaTemp, .aAutoFields) && fill in array of field names to be use
.MakeOutput() && do the merg
ENDWIT

thisform.releas

Any help or ideas appreciated... Thanks