Customers List

This will provide the mailing address for active customers, this could be used for creating mailing lists.

SELECT contactV6 AS Contact,
       OrganisationV6 AS Company,
       PostalAddress1 AS [Address 1],
       PostalAddress2 AS [Address 2],
       PostalAddress3 AS [City/Town],
       post_code AS [Postal Code],
       StreetState AS [State/Province],
       StreetCountry AS Country
FROM dbo.tblCust
WHERE (DisabledCust = 'N')