>Hi,
>
>I need some help translating some VBA to open a Foxplus type datasource for a mail merge in WOrd. Here's the code from the macro I recorded:
>
> ActiveDocument.MailMerge.OpenDataSource Name:= _
> "C:\Development\VFP8\SigmaSoft\DMSys 5.0\test.DBF", ConfirmConversions:= _
> False, ReadOnly:=False, LinkToSource:=True, AddToRecentFiles:=False, _
> PasswordDocument:="", PasswordTemplate:="", WritePasswordDocument:="", _
> WritePasswordTemplate:="", Revert:=False, Format:=wdOpenFormatAuto, _
> Connection:= _
> "Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data Source=C:\Development\VFP8\SigmaSoft\DMSys 5.0;Mode=Read;Extended Properties="""";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:Database Password="""";Jet OLEDB:Engine Type=18" _
> , SQLStatement:="SELECT * FROM `test`", SQLStatement1:="", SubType:= _
> wdMergeSubTypeAccess
>
>Can anyone help me sort this out?
>
>Thanks,
>
>Frank.
Frank,
If the source is a foxpro table forget about OpenDataSource(). Instead you might copy to a tab delimited text file and use it as a source.
Cetin