General information
Category:
COM/DCOM and OLE Automation
It is not a problem with Word XP
I had the user record a MACRO of attaching the DataSource and no errors occured.
** MACRO FROM WORD XP
ActiveDocument.MailMerge.MainDocumentType = wdFormLetters
ActiveDocument.MailMerge.OpenDataSource Name:= _
"C:\WINDOWS\TEMP\ATTORNEYS.DBF", ConfirmConversions:=False, ReadOnly:= _
False, LinkToSource:=True, AddToRecentFiles:=False, PasswordDocument:="", _
PasswordTemplate:="", WritePasswordDocument:="", WritePasswordTemplate:= _
"", Revert:=False, Format:=wdOpenFormatAuto, Connection:= _
"DSN=FoxPro Files Word;UID=;PWD=;SourceDB=C:\WINDOWS\TEMP;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=MACHINE;Null=Yes;Deleted=Yes;" _
, SQLStatement:="SELECT * FROM ATTORNEYS.DBF", SQLStatement1:="", SubType:=wdMergeSubTypeOther
** From Object Browser in XP
Sub OpenDataSource(Name As String, [Format], [ConfirmConversions], [ReadOnly], [LinkToSource], [AddToRecentFiles], [PasswordDocument], [PasswordTemplate], [Revert], [WritePasswordDocument], [WritePasswordTemplate], [Connection], [SQLStatement], [SQLStatement1], [OpenExclusive], [SubType])
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only