User Lists and Mailing Lists

  • Article

You use the List Manager module in Commerce Server Business Desk to import and export user lists and mailing lists. List Manager requires lists to have a specific format. For information about mailing list format, see Mailing Lists. For information about user list format, see User Lists.

  • Adding lists to List Manager. You can export a Commerce Server Analysis report as a list to List Manager. You can import a list that you created using another application, such as SQL Server (to create a SQL table), Notepad (to create an ASCII text file), Microsoft Excel (to create a spreadsheet), or Microsoft Outlook (to export a .pst file which contains a list of addresses) into List Manager.

    If you have Commerce Server 2002 Service Pack 1, List Manager can import from any OLEDB data source.

    For example, if you have a list of addresses in a Microsoft Excel spreadsheet, you can use List Manager to import the list into Business Desk, and then use the list in a direct mail campaign. If you identify a list of users in an Analysis report, you can export the report results as a list to List Manager, and then use the list in a direct mail campaign. For information about creating mailing lists, see Creating a Mailing List.

    For information about importing a list into List Manager, see Importing and Exporting Lists. For information about exporting a Commerce Server Analysis report to List Manager, see Exporting a Static Report.

  • Using lists from List Manager. You can update your user profiles using a user list from the List Manager module. For example, you run the Commerce Server Customer Sales report to identify users who buy the most products, and then export the report as a list to List Manager. Then in the Users module you update the user profiles in the list by assigning a special value a profile property in the user profiles. You use that value to target specific ads or discount campaigns to the users whose profiles you have modified. For information about using lists in the Users module, see Finding User Profiles in a Mailing List. For information about modifying multiple user profiles, see Editing Multiple User Profiles.

    You can also export the list to another application. For example, you can export a list generated from an Analysis report to a Microsoft Excel spreadsheet. For information about exporting a list to a file, see Importing and Exporting Lists.

This section contains:

Copyright © 2005 Microsoft Corporation.
All rights reserved.