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.

For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!