I have a problem with creating a auto mail merge feature from VFP to word 97 (word 2000 works ok).
the problem is i get an error 1429 unable to open data source.
I am working on code that i did not write and have very little knowledge of the word basic commands.
the problem seems to stem from the fact if the folder where the data source is has a space in it then the error occurs otherwise it seems to work fine.
following is the code that is used, where lctemplatedirectory holdes the directory name is there a way to enclose in quotes or something similar
.MailMergeOpenDataSource(lcTableName + ".DBF",0,0,1,0,"", ;
"",0, "","","DSN=visual foxpro tables;DBQ="+lcTemplateDirectory+";DefaultDir="+lcTemplateDirectory, ;
"SELECT * FROM " + lcTableName + ".DBF","")
TIA
Wayne
Wayne Williams
Developer VFP