Hi, I used to work at a health food store and they used to run "Quicksell Commerce" when I was there. Now they've migrated to MRMS on all new machines. We don't have access to the old computers. The owner of the store wants to generate a .qrp report with the customer's emails. Just like QC, MRMS has an option to pull the email in the report but it doesn't actually show up in the report. Now on QC, we changed the "Customer - Customer List.qrp" file to list the email in the reports and it worked great! Problem now is, I can't remember the name of the field for email in the SQL server. It was something, like, "Customer.email" but that doesn't work. Is there any way of listing the names of the fields in SQL? Or, does someone know the name of that SQL field? Thanks in advance!
Need help finding "Field" name
May 22, 2007
2 Replies
You also might want to take a look at customer source. MS has made a reports library available and there are several customer reports - including email lists & phone/address lists that you might find useful. You must be on an active MS Maintenance Plan to access Customer Source.
Glenn Adams Tiber Creek C> Well, with a little more searching I managed to find my answer on the board.
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required