Most companies use a uniform format for their email addresses, either first letter of first name with the last name or first dot last name.
This video shows you how to use Excel functions =left and =concatenate to automatically generate a list of email addresses.