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