Using the Microsoft Word SMSVIEW Sample

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.

    To set up Microsoft Word for using the sample with Microsoft Mail
  1. Install Microsoft Mail on the computer where you are using the sample document SMSTRAIN.DOC.
  2. Users of SMS computers must complete the UINFO.XNF form that is automatically distributed to SMS client computers.

    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.

    To set up the Word sample
  1. Before you run the Word sample, make sure that your site database contains inventory for one or more software packages.
  2. Copy SMS.DOT and WBODBC.WLL from the SDK\TEMPLATE directory on the SMS CD-ROM to the template directory used by Microsoft Word (usually, the template directory is the TEMPLATE subdirectory of the Word root directory).
  3. Copy SMSTRAIN.DOC from the SDK directory on the SMS CD-ROM to the directory on your hard disk where you want to place the sample.
    To use the Word sample
  1. Start Microsoft Word.
  2. Open SMSTRAIN.DOC.

    The Connection Information dialog box appears.

  3. In the ODBC Connection Name box, type sms data.
  4. In the SQL Login ID and Password boxes, type the SQL login identifier and password for the SQL Server containing the site database.

    Note that the SQL login identifier must have dbo permission on the site database.

  5. In the Location Of The Word Template Directory box, type the directory containing SMS.DOT and WBODBC.WLL.

    By default, this directory is the template directory used by your Microsoft Word installation.

  6. Click OK.

    The Training Notification dialog box appears.

  7. In the top entry box, type the name that you want to use in the form letters to refer to your training course or the new package.

    This string will be used as the name for the course or package in the form letters.

  8. From the list box, select the software package that you want to use to search for SMS computers.

    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).

  9. From the Notification Method box, select the method to use to notify the computer users of the package.

    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.