While I was working on doing a mail merge through VFP I ran across a problem. I can do a merge if I go in to the Word template and manually set the data source. I would however like to create the data source 'on the fly' through VFP. I know I can do this by using the oWord.MailMergeOpenDataSource("source.dbf") command however it pops up a window in Word that asks to confirm whether data source is Foxpro or Dbase ODBC. Is there someway to pass this information from VFP so that it doesn't pop that dialog box up to the user? Also does anyone know the command to select different documents in Word. I want to close the templates after I do the merge so that only the form letter is left.
Thanks in advance!