Share via

Mail Merge Object Foundation Class

Category Automation
Default Catalog Visual FoxPro Catalog\Foundation Classes\Automation
Class mailmerge
Base Class Custom
Class Library mailmrge.vcx
Parent Class automation
Sample ...\Samples\Solution\Ffc\Automate.scx

Remarks

This custom class uses the Mail Merge Wizard engine to generate a Microsoft Word Mail Merge document.

To use, drop the class on a project or form or, from the Component Gallery Item Shortcut Menu, select Add to Project or Add to Form. When you add the class to a form, specify the FROM table (cDataPath), the location and version of Word (cExe and cWordVersion), and other appropriate properties values. When you drop the class on a project, you can choose between adding the class or creating a subclass.

Properties, Events, Methods Description
aWPMrg[2,0] property An array of procedures for handling various merge styles.
Default: .F.
cDataFile property A FoxPro 2.6 copy of a Visual FoxPro 3.0 or later table.
Default: ""
cDataPath property Specifies the path to the FROM table.
Default: ""
cDataSrc property Specifies the data source for the ODBC connection.
Default: ""
cDocName property Default: ""
Specifies the name of the existing .doc file.
cExe property Specifies the full path to the Word application.
Default: ""
cODBCSource property Specifies the ODBC connection string.
Default: ""
cSaveFile property Specifies the file for holding merged data.
Default: ""
CSQLstmt property A SQL statement for extracting data.
Default: ""
CSQLstmt2 property Specifies an additional SQL statement, if cSQLStmt is greater than 255 characters (for Word).
Default: ""
cWordVersion property Specifies the version of Word that is installed (for example, '8').
Default: ""
lAlerted property Specifies whether a failure alert was issued.
Default: .F.
lEnglish property Verifies whether Word recognizes English Word Basic commands.
Default: .F.
lHasVerWord property Verifies the presence of Word.
Default: .F.
nNewDoc property Indicates whether a new document will be used (see Mailmrge.h).
Default: 1
nTemplate property Specifies the main document type. Applies to Word only. See Mailmrge.h.
Default: 1
nWordProc property Specifies the selected word processor. See Mailmrge.h.
Default: 1
SysCh property Specifies a DDE channel.
Default:-1
CheckVer method Verifies the version of Word being used.
Internal to the class.
Syntax: CheckVer( )
Return: none
Arguments: none
GetMSW method Retrieves the Word command line from the registry.
Syntax: GetMSW(m.cversion)
Return: the full path to Word
Arguments:
m.cversion specifies the version of Word being used.
MrgCommaDel method Generates a comma-delimited text file from data.
Syntax: MrgCommaDel( )
Return: a comma-delimited file
Arguments: none
MrgWord method Determines the versions of Word to be used in the merge.
Syntax: MrgWord( )
Return: none
Arguments: none
MSWerr method The error handler for use while AppleScript is being run.
Syntax: MSWerr( )
Return: none
Arguments: none
GetSQLst method Retrieves the SQL statement for extracting data. Internal to the class.
Syntax: GetSQLst( )
Return: none
Arguments: none
PrepData method Determines the kind of data source that is being used for the mail merge and normalizes the data for processing, Internal to the class.
Syntax: PrepData( )
Return: none
Arguments: none
SaveSQL method Generates a table of SQL results. Internal to the class.
Syntax: SaveSQL( )
Return: none
Arguments: none
WzMMData method Copies data to a text file. Internal to the class.
Syntax: WzMMData( )
Return: none
Arguments: none
MakeFieldList    Internal to the class.
MailMergeWord8 Internal to the class.
MailMergeWord6 Internal to the class.
MSWmldlg Internal to the class.
Startword Internal to the class.
MailMergeMacWord6 Internal to the class.
MMCleanup method Closes files - Internal to the class.

See Also

Guidelines for Using Visual FoxPro Foundation Classes | Visual FoxPro Foundation Classes A-Z | Visual FoxPro Foundation Class Samples