When a school, club, or small team sets up accounts, someone has to turn a list of names into a list of email addresses, all in the same format. Doing it by hand is slow and full of typos. This guide shows how to generate email addresses from a name list cleanly, for people in your own team or class, with one format applied to every name.
The pattern every address follows
Most organisations use one pattern for everyone, such as firstname.lastname@domain, or firstname-lastname@domain. The pattern has three parts: the first name, the last name, and the domain, joined by a separator such as a dot or a hyphen. Keeping one pattern matters, because mixed formats cause failed logins, bounced mail, and confusion. Before you start, decide the pattern, the domain, and the separator, and write them down. Also decide what to do about duplicate names: two people named Alex Smith cannot share one address, so plan a rule, such as adding a number or a middle initial, before you generate the list.
How to generate email addresses from a name list
- Prepare two matching lists. Make one .txt file of first names, one per line, and one .txt file of last names, in the same order, one per line. The order must match exactly, line by line.
- Check the lists line up. Count the lines in both files. If one file has 40 names and the other has 39, stop and find the missing name before you continue.
- Pick your domain and separator. Enter the domain, such as your school or club domain, and choose the separator, such as a dot or a hyphen.
- Generate the addresses. The tool pairs the names line by line and writes one address per pair, in your chosen format, ready to copy.
- Check for duplicates and odd spellings. Scan the result for repeated addresses and names with unusual characters, and fix them before you import the list anywhere.
- Use the list only for your own people. This method is for accounts and rosters you manage. Do not use it to guess the addresses of strangers or to build lists for unsolicited mail.
A worked example
A club has 25 new members. The organiser makes a first-name file with 25 lines and a last-name file with 25 lines, in the same order. She picks the club domain and a dot separator. The tool pairs them line by line and produces 25 addresses, such as ana.garcia@club.example and tom.lee@club.example. She spots two members both named Sam Patel, so she adjusts one to sam.patel2@club.example before importing. The whole job takes minutes, where typing 25 addresses by hand would invite at least one typo.
Mistakes to avoid
- Do not let the two lists fall out of order. One swapped line pairs every following name with the wrong surname.
- Do not skip the duplicate check. Duplicate addresses cause account clashes that are painful to untangle later.
- Do not use a real public domain you do not control as your test domain. Use your own organisation’s domain.
- Do not generate addresses for people who have not agreed to be contacted. Consent comes before any list.
Try it faster with the free tool
The free Online Email Generation Tool below builds email addresses in one set format from two name lists you upload: give it a .txt file of first names and a matching .txt file of last names, pick a domain and a separator, and it pairs the names line by line and writes one address per pair, ready to copy.
Try it here: Online Email Generation Tool.
Two matching lists, one pattern, and a duplicate check at the end. That is how a clean address list gets made, without the typos.