Here's a handy 'SQL Query' which you can copy and paste into GoldMine to locate/display all Contact Records with no Primary (or Main Address) E-mail Address indicated. This 'could' make any e-mail marketing you do from GoldMine a bit of a challenge until these records are corrected.
Select CS.Accountno, Cs.Address2 + ' <'+IsNull(CS.ContSupref,'')+IsNull(CS.Address1,'')+'>' [E-mail Address], C1.Company, C1.Contact From ContSupp CS Left Join Contact1 C1 On CS.Accountno = C1.Accountno Where CS.rectype = 'P' and CS.U_Contact = 'E-mail Address' and (IsNull(Substring(CS.Zip,2,1),'') = '' or IsNull(Substring(CS.Zip,2,1),'') = '0' ) and CS.Accountno not in (Select Accountno From Contsupp where rectype = 'P' and U_Contact = 'E-mail Address' and Substring(Zip,2,1) = '1') Order by C1.Company, C1.Contact
Go to Tools...SQL Query in GoldMine and paste in the above Query.
Comments