Workflow for Direct Mailer

The following figure shows the workflow for Direct Mailer.

Direct Mailer workflow diagram

  1. A list of recipients created from an application such as an Analysis report, text file (comma-separated value (CSV)), or SQL Server table is imported into List Manager.
  2. A Direct Mailer job is run from the command line, or a direct mail campaign is created in Commerce Server Business Desk.
  3. The List Manager service populates the DirectMailer database with the list of recipients, passing the DirectMailer database connection string as a parameter.
  4. The DirectMailer service executes the T-SQL OpenRowset command to select data from the Campaigns database.
  5. The list data is populated from the Campaigns database to the DirectMailer database.
  6. The Direct Mail Windows NT Service receives the list data from the Direct Mailer database.
  7. The Direct Mailer service sends the e-mail to the recipients.

Copyright © 2005 Microsoft Corporation.
All rights reserved.