CustomerID  Type       Method
12          Invoice    Fax
12          Satement   Fax
12          OrderConf  Email
12          Newsletter Text

SELECT 
      B.CustomerID
    , A.[full name] 
    , A.[business phone] 
    , A.[mobile phone] 
    , 'No'
    , 'Not Yet'
    , A.[e-mail 1] 
    , case
		when type = 'Invoices' then C.method
      end as Invoices 
    , case
		when type = 'Statements' then C.method
      end as Statements 
    , case
		when type = 'Order Confirmations' then C.method
      end as Order_Confirmations 
    , case
            when type = 'Packing Slips' then C.method
      end as Packing_Slips 
    , 'N'
    , GetDate()
    , 'Frankt@Gmail.com'
    , 'message' --<message, varchar(400),>
FROM Server.ContactsDetail A
	JOIN Server.ContactsView B 
		ON A.cntctid = B.contactid
	JOIN Server.Communication C 
		ON B.bsicustomerid = C.dealerno
WHERE B.bsicustomerid <> ''
AND A.[full name] <> ''

CustomerID  Newletter  Invoice  OrderConf  Statement
12          Fax        Email    Fax        Text