To view all customer store credits go to Print, Contact, Mailing Lists.
In Step 1 click the button "No Names" this clears out the list generator, which you can check by looking at the grey box.
Currently in the grey box it shows that their is a total of 0 Selected.
Valid means how many have valid mailing addresses.
Emails means how many have valid email addresses.
To generate all contacts for the list, in Step 1 uncheck all the boxes and then click on the button for "All Names".
In the above example you can see there is a total of 833 contacts, 790 of them have mailing addresses, and 501 of them have email addresses.
Skip down to Step 3 and uncheck all boxes except for "Merge File" and then click on the "Start" button.
This will open a Save As window.
In the "Save In" choose where on the computer you want to
save the list.
In the "Copy To" name the list.
In the "Save As Type" choose XLS for Microsoft Excel.
Click the Save button to save the list.
It will ask you if you want to filter out names with invalid or no address, click "No" so you will save the full list.
It will then give you a message that it has created the file. Click on OK.
You can now minimize Masterpiece and go to where you saved the file and open it.
If you scroll to the right on the list you will see a column for "Credit", you can sort Excel and be able to see who has a store credit and who does not.
To sort the list, click the box above Row 1, this should highlight everything on the sheet.
Now go to Data and then Sort.
Click on the button "Descending" and then choose the drop down for "Sort By" and click on "credit", now click the OK button. This will sort your list from highest store credit to lowest.