>I'm having trouble figuring out exactly how to tell Word to open the data for a mail merge. The data file is an Excel spreadsheet.
>
>So far I have...
>oWord.ActiveDocument.MailMerge.
>
>...and have tried...
>oWord.ActiveDocument.MailMerge.DataSource.Name = m.dir+"data\labels.xls"
>oWord.ActiveDocument.MailMerge.OpenDataSource.name=m.dir+"data\labels.xls"
>oWord.ActiveDocument.MailMerge.OpenDataSource.DataSource.Name=m.dir+"data\labels.xls"
>oWord.ActiveDocument.MailMerge.OpenDataSource.ShowWizard.DataSource.Name=m.dir+"data\labels.xls"
>oWord.ActiveDocument.MailMerge.DataSource=m.dir+"data\labels.xls"
>oWord.ActiveDocument.MailMerge.OpenDataSource.DataSource.Name=m.dir+"data\labels.xls"
>
>I've been receiving "'Name' not a by reference property" or "parameter not optional".
>
>Sure hope I'm getting close!
>
>Any suggestions are GREATLY appreciated.
>
>Martha

  oWord.ActiveDocument.MailMerge.OpenDataSource(m.dir+"data\labels.xls")

VFP uses only positional parameters. Office and other products can use named parameters. So you must know the full syntax of the method.