Generate Email List from Attendees
As an Event Planner, I often need to send follow-up emails or invitations to all attendees. Manually copying and pasting each email address into Outlook is time-consuming and prone to errors. I need a quick way to combine a column of attendee email addresses into a single semi-colon separated string that I can directly paste into the 'To', 'Cc', or 'Bcc' field in Outlook.
=TEXTJOIN(";",TRUE,B2:B5) How it works: The TEXTJOIN function is perfect for this task because it allows you to combine text from multiple ranges or strings with a specified delimiter. Here, we use a semi-colon (`;`) as the delimiter, which is the standard separator for multiple email addresses in Outlook. The `TRUE` argument tells TEXTJOIN to ignore any empty cells within the specified range, ensuring your output doesn't have unnecessary delimiters. The range `B2:B5` specifies all the email addresses you want to combine.
Data Setup
| Attendee Name | Email Address |
|---|---|
| Alice Smith | alice.smith@example.com |
| Bob Johnson | bob.j@example.com |
| Charlie Brown | charlie.b@example.com |
| Diana Prince | diana.p@example.com |
Step-by-Step Guide
Identify the column containing the attendee email addresses (e.g., Column B).
Select an empty cell where you want the combined email list to appear (e.g., C2).
Enter the formula: `=TEXTJOIN(";",TRUE,B2:B5)`
Press Enter to see the combined email string.
Copy the result from cell C2 and paste it directly into the 'To', 'Cc', or 'Bcc' field of your email client (e.g., Outlook).