The sample document SMSTRAIN.DOC (using the macros in the SMS.DOT template and the ODBC functions in WBODBC.WLL) reads the site database and finds all inventoried software packages. After you select one of these packages, the macro finds all of the computers that have the package installed and generates a letter for the user of each computer informing the user about training information for that package. You can generate these messages to another Word document, to a printer, or to Microsoft® Mail messages.
When the users complete this form, they report their name, electronic mail, and other information with their computer inventories. The macro used by SMS.DOT uses the information in the electronic-mail attribute to send the messages as mail messages to the users of the package.
The Connection Information dialog box appears.
Note that the SQL login identifier must have dbo permission on the site database.
By default, this directory is the template directory used by your Microsoft Word installation.
The Training Notification dialog box appears.
This string will be used as the name for the course or package in the form letters.
The macro will query the site database to get all computers with the software package installed. The macro will search for computers with the Personal Computer architecture with the attribute Software Name equal to the selected package in the Software group (group class MICROSOFT|SOFTWARE|1.0).
If you choose Merge To Document, a Word document will be created for each computer user with the software package.
If you choose Merge To Mail, a Microsoft Mail message will be created for each computer user with the software package and the messages will be sent to the users.
If you choose Merge To Printer, the Print dialog box appears. Select the print options you want, and click OK. A letter will be printed for each computer user with the software package.