Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
May be Word issue; suppress Confirm Data Source window
Message
From
04/05/2007 11:41:06
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
 
To
04/05/2007 08:50:41
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01222455
Message ID:
01222525
Views:
17
>This may be a Word (2000) issue, but I need to suppress the Confirm Data Source window in a merge document and default it to use Foxpro. Anyone know how to do this? Thanks!
>
>Update:
>
>This is the code in Foxpro that is making the call...
>
>
>WITH .ActiveDocument.MailMerge
>	.OpenDataSource(m_temp_dir+'FeeSlip.dbf')
>	.Execute()
>ENDWITH
>
>
>Maybe there is something else I can send with it?

The Solution:
WITH .ActiveDocument.MailMerge
	.OpenDataSource(tDataSource,,.F.,.F.,.T.,.F.,"","",.F.,"","", ;
"DSN=Foxpro Files - Word;SourceDB="+m_temp_dir+";SourceType=DBF;Exclusive=Yes;Null=No;Deleted=No", ;
"SELECT * FROM "+tDataSource) 
	.Execute()
ENDWITH
Previous
Reply
Map
View

Click here to load this message in the networking platform