Hi Cetin,
I can't use a text delimited file as there are memo fields involved (I did use that initially and cut the memo field to 250 characters but the user wasn't happy).
What I've been doing is copying to foxplus type and trying to use that. Will that not work either?
>>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