Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Word MailMerge - Office 2000 vs Office XP w/ VFP 6
Message
From
24/01/2002 13:51:19
 
 
To
24/01/2002 13:27:17
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00609065
Message ID:
00609941
Views:
29
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
Map
View

Click here to load this message in the networking platform