Exporting a Loyalty Query

The Loyalty Card Lookup offers you two ways to export your query:

•	Click Export after successfully running a query.

•	Running a query that exceeds the maximum number that you can view in the Member list box.

When you export your query to your local system, you can import it into Excel® for analysis and generate a mailing or email list.

For example, you want to send a coupon to the Loyalty members that signed up in the last two months. First, filter your Loyalty database by ‘Member Sign-Up Date’ and enter the range for the filter, such as 04/01/2004 through 05/31/2004 and click . Your results display in the Member list box. Click and follow the on-screen prompts to save the file to your local system. Now open the file in Excel® and you can export the data into Word® as a mail merge, or even export the data into Outlook to send an email list. Refer to Microsoft™ Excel® Help for more information.

If you run a query and it exceeds the maximum number of members for the Member list box (currently no more than 3000 members), you receive a prompt to download the query. At this time, you can either download the query to your local system, or cancel and refine your query to limit the number of members returned. If you select the ‘Do not display this message in the future’ check box on the prompt, the file starts downloading automatically the next time you run a query that exceeds the maximum number for the Member list box.

The following table represents the field number and corresponding field information. The exported file contains only the information the Loyalty member supplied, or information that you collect when signing up your Loyalty members. For example, you do not collect the birthday of the member; therefore, the column that contains information about birthdays is blank.

Column Number	Contents
1	Card Number
2	Last Name/Surname
3	First Name
4	Last Visit Date
5	Sign-up Date
6	Card Type
7	Birth Date
8	Anniversary Date
9	Street 1
10	Street 2
11	City/Town/Suburb
12	State/Region/Province
13	Postal Code
14	Country
15	Phone Number
16	Other Phone Number
17	Email Address
18	Company
22 - 31	Company Defined Fields 1 through 30
32	Active (This column is only active when you select ‘Show Inactive Members’ on the Welcome to Loyalty Member screen.)