You want the email address associated with a customer account or a list of customer accounts.
Open a Support ticket with the customer account numbers attached to the ticket and Support will provide the associated email addresses to you.
You should have access to the Jump server for performing the below steps:
- Login to the Jump server 10.185.40.141.
- Open Microsoft SSMS and connect to
New Queryin the top bar.
- Run the query:
from Customer c
join Address a on a.AddrID = c.MailAddrID
and c.CustNo in (<Customer Account Number 1>,<Customer Account Number 2>,...)
The customer account numbers in the above query should be retrieved from the list that is provided by the client.
The result of the query should be sent to the client on the ticket.