How to split multiple e-mails in one record into separate lines?
We are creating a query based on these tables.
- Customer Table
- EMailAddress
- NotifyEMail (there can be multiple emails in one record. I believe they are separated by semicolon;)
- CustUPSEmail Table
- EmailAddress (there can be multiple records, or none, related to a customer)
- ShipTo Table
- EMailAddress
- NotifyEMail (there can be multiple emails in one record. I believe they are separated by semicolon;)
- ShipToUPSEml Table
- EmailAddress (there can be multiple records, or none, related to a customer)