Overview

You want the email address associated with a customer account or a list of customer accounts.

Solution

Open a Support ticket with the customer account numbers attached to the ticket and Support will provide the associated email addresses to you.

<supportagent>

You should have access to the Jump server for performing the below steps:

1. Login to the Jump server 10.185.40.141.
2. Open Microsoft SSMS and connect to aes.cons.com.
3. Select New Query in the top bar.
4. Run the query:

select c.CustID,c.CustNo,Addr1,Addr2,City,State,Zip,Email
from Customer c
join Address a on a.AddrID = c.MailAddrID
where 1=1
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.

</supportagent>