How to validate email addresses in sheets (For mail merge)
In this video I show you how to quickly validate emails. You can use this with Gmail's Mail Merge tool or free alternatives.
Chapters:
0:00 Intro
0:46 Validate emails
1:31 Second method for larger lists
2:40 validation breakdown
2:52 Help with mail merge
3:22 grades formula
3:57 mail merge
5:07 Final personalised email
Other useful vids:
Intro to Mail Merge - • How to Send Bulk Emails in Gmail WITHOUT E...
Form Mule (Free alternative) • Use Form Mule to Mail Merge (Email Merge) ...
Key formula:
=IF(REGEXMATCH(C2, "^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,}$"), "Valid", "Invalid")
The final Spreadsheet: https://docs.google.com/spreadsheets/...