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