IsValidEmail ( theEmail )

check extended list of valid email domains (updated April 2021)
Be the first to rate this function Log in to vote
Peter Sijmons - Show more from this author
Szienz
http://www.szienz.com
Sample input:
IsValidEmail ( "johndoe@dotcom.com" )
Sample output:
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Let (
    [
    _validDomainCharacters = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789-." ;
    _invalidLocalCharacters = "!\"#$%&'*,/:;<>?@[\]^`{}|~" ; // from http://www.remote.org/jochen/mail/info/chars.html
    _theLocalPart = Left ( theEmail ; Position ( theEmail ; "@" ; 1; 1 ) - 1 ) ;
    _theDomainPart =  Right ( theEmail ; Length ( theEmail ) - Position ( theEmail ; "@" ; 1; 1 )  ) ;
    _theTopLevelDomain = RightWords ( Substitute ( _theDomainPart ; "." ; " " ) ; 1 ) ;
    _ValidTopLevelDomains = "AAA¶AARP¶ABARTH¶ABB¶ABBOTT¶ABBVIE¶ABC¶ABLE¶ABOGADO¶ABUDHABI¶AC¶ACADEMY¶ACCENTURE¶ACCOUNTANT¶ACCOUNTANTS¶ACO¶ACTOR¶AD¶ADAC¶ADS¶ADULT¶AE¶AEG¶AERO¶AETNA¶AF¶AFAMILYCOMPANY¶AFL¶AFRICA¶AG¶AGAKHAN¶AGENCY¶AI¶AIG¶AIRBUS¶AIRFORCE¶AIRTEL¶AKDN¶AL¶ALFAROMEO¶ALIBABA¶ALIPAY¶ALLFINANZ¶ALLSTATE¶ALLY¶ALSACE¶ALSTOM¶AM¶AMAZON¶AMERICANEXPRESS¶AMERICANFAMILY¶AMEX¶AMFAM¶AMICA¶AMSTERDAM¶ANALYTICS¶ANDROID¶ANQUAN¶ANZ¶AO¶AOL¶APARTMENTS¶APP¶APPLE¶AQ¶AQUARELLE¶AR¶ARAB¶ARAMCO¶ARCHI¶ARMY¶ARPA¶ART¶ARTE¶AS¶ASDA¶ASIA¶ASSOCIATES¶AT¶ATHLETA¶ATTORNEY¶AU¶AUCTION¶AUDI¶AUDIBLE¶AUDIO¶AUSPOST¶AUTHOR¶AUTO¶AUTOS¶AVIANCA¶AW¶AWS¶AX¶AXA¶AZ¶AZURE¶BA¶BABY¶BAIDU¶BANAMEX¶BANANAREPUBLIC¶BAND¶BANK¶BAR¶BARCELONA¶BARCLAYCARD¶BARCLAYS¶BAREFOOT¶BARGAINS¶BASEBALL¶BASKETBALL¶BAUHAUS¶BAYERN¶BB¶BBC¶BBT¶BBVA¶BCG¶BCN¶BD¶BE¶BEATS¶BEAUTY¶BEER¶BENTLEY¶BERLIN¶BEST¶BESTBUY¶BET¶BF¶BG¶BH¶BHARTI¶BI¶BIBLE¶BID¶BIKE¶BING¶BINGO¶BIO¶BIZ¶BJ¶BLACK¶BLACKFRIDAY¶BLOCKBUSTER¶BLOG¶BLOOMBERG¶BLUE¶BM¶BMS¶BMW¶BN¶BNPPARIBAS¶BO¶BOATS¶BOEHRINGER¶BOFA¶BOM¶BOND¶BOO¶BOOK¶BOOKING¶BOSCH¶BOSTIK¶BOSTON¶BOT¶BOUTIQUE¶BOX¶BR¶BRADESCO¶BRIDGESTONE¶BROADWAY¶BROKER¶BROTHER¶BRUSSELS¶BS¶BT¶BUDAPEST¶BUGATTI¶BUILD¶BUILDERS¶BUSINESS¶BUY¶BUZZ¶BV¶BW¶BY¶BZ¶BZH¶CA¶CAB¶CAFE¶CAL¶CALL¶CALVINKLEIN¶CAM¶CAMERA¶CAMP¶CANCERRESEARCH¶CANON¶CAPETOWN¶CAPITAL¶CAPITALONE¶CAR¶CARAVAN¶CARDS¶CARE¶CAREER¶CAREERS¶CARS¶CASA¶CASE¶CASH¶CASINO¶CAT¶CATERING¶CATHOLIC¶CBA¶CBN¶CBRE¶CBS¶CC¶CD¶CENTER¶CEO¶CERN¶CF¶CFA¶CFD¶CG¶CH¶CHANEL¶CHANNEL¶CHARITY¶CHASE¶CHAT¶CHEAP¶CHINTAI¶CHRISTMAS¶CHROME¶CHURCH¶CI¶CIPRIANI¶CIRCLE¶CISCO¶CITADEL¶CITI¶CITIC¶CITY¶CITYEATS¶CK¶CL¶CLAIMS¶CLEANING¶CLICK¶CLINIC¶CLINIQUE¶CLOTHING¶CLOUD¶CLUB¶CLUBMED¶CM¶CN¶CO¶COACH¶CODES¶COFFEE¶COLLEGE¶COLOGNE¶COM¶COMCAST¶COMMBANK¶COMMUNITY¶COMPANY¶COMPARE¶COMPUTER¶COMSEC¶CONDOS¶CONSTRUCTION¶CONSULTING¶CONTACT¶CONTRACTORS¶COOKING¶COOKINGCHANNEL¶COOL¶COOP¶CORSICA¶COUNTRY¶COUPON¶COUPONS¶COURSES¶CPA¶CR¶CREDIT¶CREDITCARD¶CREDITUNION¶CRICKET¶CROWN¶CRS¶CRUISE¶CRUISES¶CSC¶CU¶CUISINELLA¶CV¶CW¶CX¶CY¶CYMRU¶CYOU¶CZ¶DABUR¶DAD¶DANCE¶DATA¶DATE¶DATING¶DATSUN¶DAY¶DCLK¶DDS¶DE¶DEAL¶DEALER¶DEALS¶DEGREE¶DELIVERY¶DELL¶DELOITTE¶DELTA¶DEMOCRAT¶DENTAL¶DENTIST¶DESI¶DESIGN¶DEV¶DHL¶DIAMONDS¶DIET¶DIGITAL¶DIRECT¶DIRECTORY¶DISCOUNT¶DISCOVER¶DISH¶DIY¶DJ¶DK¶DM¶DNP¶DO¶DOCS¶DOCTOR¶DOG¶DOMAINS¶DOT¶DOWNLOAD¶DRIVE¶DTV¶DUBAI¶DUCK¶DUNLOP¶DUPONT¶DURBAN¶DVAG¶DVR¶DZ¶EARTH¶EAT¶EC¶ECO¶EDEKA¶EDU¶EDUCATION¶EE¶EG¶EMAIL¶EMERCK¶ENERGY¶ENGINEER¶ENGINEERING¶ENTERPRISES¶EPSON¶EQUIPMENT¶ER¶ERICSSON¶ERNI¶ES¶ESQ¶ESTATE¶ET¶ETISALAT¶EU¶EUROVISION¶EUS¶EVENTS¶EXCHANGE¶EXPERT¶EXPOSED¶EXPRESS¶EXTRASPACE¶FAGE¶FAIL¶FAIRWINDS¶FAITH¶FAMILY¶FAN¶FANS¶FARM¶FARMERS¶FASHION¶FAST¶FEDEX¶FEEDBACK¶FERRARI¶FERRERO¶FI¶FIAT¶FIDELITY¶FIDO¶FILM¶FINAL¶FINANCE¶FINANCIAL¶FIRE¶FIRESTONE¶FIRMDALE¶FISH¶FISHING¶FIT¶FITNESS¶FJ¶FK¶FLICKR¶FLIGHTS¶FLIR¶FLORIST¶FLOWERS¶FLY¶FM¶FO¶FOO¶FOOD¶FOODNETWORK¶FOOTBALL¶FORD¶FOREX¶FORSALE¶FORUM¶FOUNDATION¶FOX¶FR¶FREE¶FRESENIUS¶FRL¶FROGANS¶FRONTDOOR¶FRONTIER¶FTR¶FUJITSU¶FUN¶FUND¶FURNITURE¶FUTBOL¶FYI¶GA¶GAL¶GALLERY¶GALLO¶GALLUP¶GAME¶GAMES¶GAP¶GARDEN¶GAY¶GB¶GBIZ¶GD¶GDN¶GE¶GEA¶GENT¶GENTING¶GEORGE¶GF¶GG¶GGEE¶GH¶GI¶GIFT¶GIFTS¶GIVES¶GIVING¶GL¶GLADE¶GLASS¶GLE¶GLOBAL¶GLOBO¶GM¶GMAIL¶GMBH¶GMO¶GMX¶GN¶GODADDY¶GOLD¶GOLDPOINT¶GOLF¶GOO¶GOODYEAR¶GOOG¶GOOGLE¶GOP¶GOT¶GOV¶GP¶GQ¶GR¶GRAINGER¶GRAPHICS¶GRATIS¶GREEN¶GRIPE¶GROCERY¶GROUP¶GS¶GT¶GU¶GUARDIAN¶GUCCI¶GUGE¶GUIDE¶GUITARS¶GURU¶GW¶GY¶HAIR¶HAMBURG¶HANGOUT¶HAUS¶HBO¶HDFC¶HDFCBANK¶HEALTH¶HEALTHCARE¶HELP¶HELSINKI¶HERE¶HERMES¶HGTV¶HIPHOP¶HISAMITSU¶HITACHI¶HIV¶HK¶HKT¶HM¶HN¶HOCKEY¶HOLDINGS¶HOLIDAY¶HOMEDEPOT¶HOMEGOODS¶HOMES¶HOMESENSE¶HONDA¶HORSE¶HOSPITAL¶HOST¶HOSTING¶HOT¶HOTELES¶HOTELS¶HOTMAIL¶HOUSE¶HOW¶HR¶HSBC¶HT¶HU¶HUGHES¶HYATT¶HYUNDAI¶IBM¶ICBC¶ICE¶ICU¶ID¶IE¶IEEE¶IFM¶IKANO¶IL¶IM¶IMAMAT¶IMDB¶IMMO¶IMMOBILIEN¶IN¶INC¶INDUSTRIES¶INFINITI¶INFO¶ING¶INK¶INSTITUTE¶INSURANCE¶INSURE¶INT¶INTERNATIONAL¶INTUIT¶INVESTMENTS¶IO¶IPIRANGA¶IQ¶IR¶IRISH¶IS¶ISMAILI¶IST¶ISTANBUL¶IT¶ITAU¶ITV¶JAGUAR¶JAVA¶JCB¶JE¶JEEP¶JETZT¶JEWELRY¶JIO¶JLL¶JM¶JMP¶JNJ¶JO¶JOBS¶JOBURG¶JOT¶JOY¶JP¶JPMORGAN¶JPRS¶JUEGOS¶JUNIPER¶KAUFEN¶KDDI¶KE¶KERRYHOTELS¶KERRYLOGISTICS¶KERRYPROPERTIES¶KFH¶KG¶KH¶KI¶KIA¶KIM¶KINDER¶KINDLE¶KITCHEN¶KIWI¶KM¶KN¶KOELN¶KOMATSU¶KOSHER¶KP¶KPMG¶KPN¶KR¶KRD¶KRED¶KUOKGROUP¶KW¶KY¶KYOTO¶KZ¶LA¶LACAIXA¶LAMBORGHINI¶LAMER¶LANCASTER¶LANCIA¶LAND¶LANDROVER¶LANXESS¶LASALLE¶LAT¶LATINO¶LATROBE¶LAW¶LAWYER¶LB¶LC¶LDS¶LEASE¶LECLERC¶LEFRAK¶LEGAL¶LEGO¶LEXUS¶LGBT¶LI¶LIDL¶LIFE¶LIFEINSURANCE¶LIFESTYLE¶LIGHTING¶LIKE¶LILLY¶LIMITED¶LIMO¶LINCOLN¶LINDE¶LINK¶LIPSY¶LIVE¶LIVING¶LIXIL¶LK¶LLC¶LLP¶LOAN¶LOANS¶LOCKER¶LOCUS¶LOFT¶LOL¶LONDON¶LOTTE¶LOTTO¶LOVE¶LPL¶LPLFINANCIAL¶LR¶LS¶LT¶LTD¶LTDA¶LU¶LUNDBECK¶LUXE¶LUXURY¶LV¶LY¶MA¶MACYS¶MADRID¶MAIF¶MAISON¶MAKEUP¶MAN¶MANAGEMENT¶MANGO¶MAP¶MARKET¶MARKETING¶MARKETS¶MARRIOTT¶MARSHALLS¶MASERATI¶MATTEL¶MBA¶MC¶MCKINSEY¶MD¶ME¶MED¶MEDIA¶MEET¶MELBOURNE¶MEME¶MEMORIAL¶MEN¶MENU¶MERCKMSD¶MG¶MH¶MIAMI¶MICROSOFT¶MIL¶MINI¶MINT¶MIT¶MITSUBISHI¶MK¶ML¶MLB¶MLS¶MM¶MMA¶MN¶MO¶MOBI¶MOBILE¶MODA¶MOE¶MOI¶MOM¶MONASH¶MONEY¶MONSTER¶MORMON¶MORTGAGE¶MOSCOW¶MOTO¶MOTORCYCLES¶MOV¶MOVIE¶MP¶MQ¶MR¶MS¶MSD¶MT¶MTN¶MTR¶MU¶MUSEUM¶MUTUAL¶MV¶MW¶MX¶MY¶MZ¶NA¶NAB¶NAGOYA¶NAME¶NATURA¶NAVY¶NBA¶NC¶NE¶NEC¶NET¶NETBANK¶NETFLIX¶NETWORK¶NEUSTAR¶NEW¶NEWS¶NEXT¶NEXTDIRECT¶NEXUS¶NF¶NFL¶NG¶NGO¶NHK¶NI¶NICO¶NIKE¶NIKON¶NINJA¶NISSAN¶NISSAY¶NL¶NO¶NOKIA¶NORTHWESTERNMUTUAL¶NORTON¶NOW¶NOWRUZ¶NOWTV¶NP¶NR¶NRA¶NRW¶NTT¶NU¶NYC¶NZ¶OBI¶OBSERVER¶OFF¶OFFICE¶OKINAWA¶OLAYAN¶OLAYANGROUP¶OLDNAVY¶OLLO¶OM¶OMEGA¶ONE¶ONG¶ONL¶ONLINE¶OOO¶OPEN¶ORACLE¶ORANGE¶ORG¶ORGANIC¶ORIGINS¶OSAKA¶OTSUKA¶OTT¶OVH¶PA¶PAGE¶PANASONIC¶PARIS¶PARS¶PARTNERS¶PARTS¶PARTY¶PASSAGENS¶PAY¶PCCW¶PE¶PET¶PF¶PFIZER¶PG¶PH¶PHARMACY¶PHD¶PHILIPS¶PHONE¶PHOTO¶PHOTOGRAPHY¶PHOTOS¶PHYSIO¶PICS¶PICTET¶PICTURES¶PID¶PIN¶PING¶PINK¶PIONEER¶PIZZA¶PK¶PL¶PLACE¶PLAY¶PLAYSTATION¶PLUMBING¶PLUS¶PM¶PN¶PNC¶POHL¶POKER¶POLITIE¶PORN¶POST¶PR¶PRAMERICA¶PRAXI¶PRESS¶PRIME¶PRO¶PROD¶PRODUCTIONS¶PROF¶PROGRESSIVE¶PROMO¶PROPERTIES¶PROPERTY¶PROTECTION¶PRU¶PRUDENTIAL¶PS¶PT¶PUB¶PW¶PWC¶PY¶QA¶QPON¶QUEBEC¶QUEST¶QVC¶RACING¶RADIO¶RAID¶RE¶READ¶REALESTATE¶REALTOR¶REALTY¶RECIPES¶RED¶REDSTONE¶REDUMBRELLA¶REHAB¶REISE¶REISEN¶REIT¶RELIANCE¶REN¶RENT¶RENTALS¶REPAIR¶REPORT¶REPUBLICAN¶REST¶RESTAURANT¶REVIEW¶REVIEWS¶REXROTH¶RICH¶RICHARDLI¶RICOH¶RIL¶RIO¶RIP¶RMIT¶RO¶ROCHER¶ROCKS¶RODEO¶ROGERS¶ROOM¶RS¶RSVP¶RU¶RUGBY¶RUHR¶RUN¶RW¶RWE¶RYUKYU¶SA¶SAARLAND¶SAFE¶SAFETY¶SAKURA¶SALE¶SALON¶SAMSCLUB¶SAMSUNG¶SANDVIK¶SANDVIKCOROMANT¶SANOFI¶SAP¶SARL¶SAS¶SAVE¶SAXO¶SB¶SBI¶SBS¶SC¶SCA¶SCB¶SCHAEFFLER¶SCHMIDT¶SCHOLARSHIPS¶SCHOOL¶SCHULE¶SCHWARZ¶SCIENCE¶SCJOHNSON¶SCOT¶SD¶SE¶SEARCH¶SEAT¶SECURE¶SECURITY¶SEEK¶SELECT¶SENER¶SERVICES¶SES¶SEVEN¶SEW¶SEX¶SEXY¶SFR¶SG¶SH¶SHANGRILA¶SHARP¶SHAW¶SHELL¶SHIA¶SHIKSHA¶SHOES¶SHOP¶SHOPPING¶SHOUJI¶SHOW¶SHOWTIME¶SI¶SILK¶SINA¶SINGLES¶SITE¶SJ¶SK¶SKI¶SKIN¶SKY¶SKYPE¶SL¶SLING¶SM¶SMART¶SMILE¶SN¶SNCF¶SO¶SOCCER¶SOCIAL¶SOFTBANK¶SOFTWARE¶SOHU¶SOLAR¶SOLUTIONS¶SONG¶SONY¶SOY¶SPA¶SPACE¶SPORT¶SPOT¶SR¶SRL¶SS¶ST¶STADA¶STAPLES¶STAR¶STATEBANK¶STATEFARM¶STC¶STCGROUP¶STOCKHOLM¶STORAGE¶STORE¶STREAM¶STUDIO¶STUDY¶STYLE¶SU¶SUCKS¶SUPPLIES¶SUPPLY¶SUPPORT¶SURF¶SURGERY¶SUZUKI¶SV¶SWATCH¶SWIFTCOVER¶SWISS¶SX¶SY¶SYDNEY¶SYSTEMS¶SZ¶TAB¶TAIPEI¶TALK¶TAOBAO¶TARGET¶TATAMOTORS¶TATAR¶TATTOO¶TAX¶TAXI¶TC¶TCI¶TD¶TDK¶TEAM¶TECH¶TECHNOLOGY¶TEL¶TEMASEK¶TENNIS¶TEVA¶TF¶TG¶TH¶THD¶THEATER¶THEATRE¶TIAA¶TICKETS¶TIENDA¶TIFFANY¶TIPS¶TIRES¶TIROL¶TJ¶TJMAXX¶TJX¶TK¶TKMAXX¶TL¶TM¶TMALL¶TN¶TO¶TODAY¶TOKYO¶TOOLS¶TOP¶TORAY¶TOSHIBA¶TOTAL¶TOURS¶TOWN¶TOYOTA¶TOYS¶TR¶TRADE¶TRADING¶TRAINING¶TRAVEL¶TRAVELCHANNEL¶TRAVELERS¶TRAVELERSINSURANCE¶TRUST¶TRV¶TT¶TUBE¶TUI¶TUNES¶TUSHU¶TV¶TVS¶TW¶TZ¶UA¶UBANK¶UBS¶UG¶UK¶UNICOM¶UNIVERSITY¶UNO¶UOL¶UPS¶US¶UY¶UZ¶VA¶VACATIONS¶VANA¶VANGUARD¶VC¶VE¶VEGAS¶VENTURES¶VERISIGN¶VERSICHERUNG¶VET¶VG¶VI¶VIAJES¶VIDEO¶VIG¶VIKING¶VILLAS¶VIN¶VIP¶VIRGIN¶VISA¶VISION¶VIVA¶VIVO¶VLAANDEREN¶VN¶VODKA¶VOLKSWAGEN¶VOLVO¶VOTE¶VOTING¶VOTO¶VOYAGE¶VU¶VUELOS¶WALES¶WALMART¶WALTER¶WANG¶WANGGOU¶WATCH¶WATCHES¶WEATHER¶WEATHERCHANNEL¶WEBCAM¶WEBER¶WEBSITE¶WED¶WEDDING¶WEIBO¶WEIR¶WF¶WHOSWHO¶WIEN¶WIKI¶WILLIAMHILL¶WIN¶WINDOWS¶WINE¶WINNERS¶WME¶WOLTERSKLUWER¶WOODSIDE¶WORK¶WORKS¶WORLD¶WOW¶WS¶WTC¶WTF¶XBOX¶XEROX¶XFINITY¶XIHUAN¶XIN¶XXX¶XYZ¶YACHTS¶YAHOO¶YAMAXUN¶YANDEX¶YE¶YODOBASHI¶YOGA¶YOKOHAMA¶YOU¶YOUTUBE¶YT¶YUN¶ZA¶ZAPPOS¶ZARA¶ZERO¶ZIP¶ZM¶ZONE¶ZUERICH¶ZW" 
    ] ;

    Case (
        IsEmpty ( theEmail ) ; "" ;
        PatternCount ( theEmail ; "@" ) <> 1 ; "invalid address" ; 
        PatternCount ( _theDomainPart ; "." ) = 0 ; "invalid formatting" ;
        Length ( Filter ( _theLocalPart ; _invalidLocalCharacters ) ) ;
            "invalid characters in the local part" ;
        Length ( Filter ( _theDomainPart ; _validDomainCharacters ) ) <> Length ( _theDomainPart ) ;
            "invalid characters in the domain part" ;
        Left ( _theLocalPart ; 1) = "." or
            Right ( _theLocalPart ; 1 ) = "." or
            Left ( _theDomainPart ; 1 ) = "." or
            Right ( _theDomainPart ; 1 ) = "." ;
            "invalid formatting" ;
       IsEmpty ( FilterValues ( _theTopLevelDomain ; _ValidTopLevelDomains ) ) ; "invalid top level domain" ;
        
        1
    )
)


/*
Name:
EmailIsValid

History:
Created by Paul Turnbull
Creation Date: 13-10-2005
Modified Date: 13-11-2005 paul@fourofus.ca - fixed numerous bugs.
Modified Date: 29-01-2008 peter@labscores.com  - no message when theEmail is empty
Modified Date: 22-04-2021 peter@szienz.com  extended list of valid email domains with version 2021042200 (link below)

Purpose: Returns True if the email supplied is valid an error message if it is not.

Parameters:
theEmail

Important Notes:
List of TLDs from http://data.iana.org/TLD/tlds-alpha-by-domain.txt
Will not handle urls in the form contact@domain.com/some.name although you could edit to handle this if you like.
*/
Original CF by Paul Turnbull (2005) but the domain list has extended considerably since then.
Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.
IsValidEmail ( theEmail )

Comments

Support this website.

Support this website.
