International Customer only email list?

peakskishop · by **peakskishop** » Fri May 03, 2013 9:31 am

Hi- Can you suggest how to query the customer email report so that it only shows me the names/email addresses for my international customers? I do have the proper country indicated in each customer's billing address.
Thanks,
Tracy

by **RetailEdge Moderator** » Tue May 07, 2013 11:27 am

You can use the wildcard to filter the report to have it show you just customers who have a value in a particular field. So in your case you would filter on the Customer Country field containing either % or _. % is any character. _ is any character in a particular position. RetailEdge automatically adds the % to the end of the set filter. So if you filtered on Country = 'A' RetailEdge will actually find any country beginning with A (since it puts the % after the A it is actually filtering on A%. If you filter on %A, RetailEdge will find any country containing the letter A in the name. And if you filter on A_C, RetailEdge will find any country ABC, ADC, AAC, etc.

Hope this helps but let us know if you need more.

peakskishop wrote:Hi- Can you suggest how to query the customer email report so that it only shows me the names/email addresses for my international customers? I do have the proper country indicated in each customer's billing address.
Thanks,
Tracy

RetailEdge Discussion Forums