{"id":9114,"date":"2025-01-01T17:15:28","date_gmt":"2025-01-01T17:15:28","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/huong-dan-tao-email-tu-ten-don-gian\/"},"modified":"2025-01-01T17:15:28","modified_gmt":"2025-01-01T17:15:28","slug":"huong-dan-tao-email-tu-ten-don-gian","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/huong-dan-tao-email-tu-ten-don-gian\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn t\u1ea1o Email t\u1eeb t\u00ean \u0111\u01a1n gi\u1ea3n"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft tr\u01b0\u1edbc, H\u1ecdc Excel Online \u0111\u00e3 h\u01b0\u1edbng d\u1eabn b\u1ea1n <em><a href=\"http:\/\/blog.ezworkapp.com\/lay-ten-tu-dia-chi-email-don-gian.html\">c\u00e1ch t\u00e1ch t\u00ean t\u1eeb Email \u0111\u01a1n gi\u1ea3n<\/a>.<\/em>\u00a0V\u1edbi b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch t\u1ea1o danh s\u00e1ch Email c\u00e1 nh\u00e2n t\u1eeb t\u00ean \u0111\u1ec3 s\u1eed d\u1ee5ng trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p m\u00e0 kh\u00f4ng ph\u1ea3i t\u1ed1n th\u1eddi gian ngh\u0129 ng\u1ee3i m\u1ed7i l\u1ea7n \u0111\u1ee9ng tr\u01b0\u1edbc b\u1ea3ng h\u1ecfi \u201c<strong>Email b\u1ea1n mu\u1ed1n \u0111\u1eb7t l\u00e0 g\u00ec?\u201d<\/strong><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6775782fd112d\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-tao-email-tu-ten-don-gian.html#Thiet_lap_du_lieu_ban_dau\" title=\"Thi\u1ebft l\u1eadp d\u1eef li\u1ec7u ban \u0111\u1ea7u\">Thi\u1ebft l\u1eadp d\u1eef li\u1ec7u ban \u0111\u1ea7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-tao-email-tu-ten-don-gian.html#Su_dung_ham_tao_Email_tu_ten_don_gian\" title=\"S\u1eed d\u1ee5ng h\u00e0m t\u1ea1o Email t\u1eeb t\u00ean \u0111\u01a1n gi\u1ea3n\">S\u1eed d\u1ee5ng h\u00e0m t\u1ea1o Email t\u1eeb t\u00ean \u0111\u01a1n gi\u1ea3n<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Thiet_lap_du_lieu_ban_dau\"><\/span>Thi\u1ebft l\u1eadp d\u1eef li\u1ec7u ban \u0111\u1ea7u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Gi\u1ea3 s\u1eed ta s\u1ebd l\u1eadp tr\u01b0\u1edbc kho\u1ea3ng 10 gmail d\u00f9ng d\u1ea7n. \u0110\u1ec3 d\u1ec5 nh\u1edb, ta c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp quy t\u1eafc gmail:<\/p>\n<p><strong><em>Ch\u1eef c\u00e1i \u0111\u1ea7u c\u1ee7a h\u1ecd + T\u00ean &amp; T\u00ean \u0111\u1ec7m + 1 s\u1ed1 ng\u1eabu nhi\u00ean<\/em><\/strong><\/p>\n<p><em>Nh\u1edb l\u00e0 vi\u1ebft kh\u00f4ng d\u1ea5u nh\u00e9!<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25578\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tao-email-tu-ten-1.png\" width=\"291\" height=\"248\" title=\"tao-email-tu-ten-1\"><\/p>\n<p>\u00a0<\/p>\n<p>\u2013<strong>H\u1ecd, t\u00ean \u0111\u1ec7m v\u00e0 t\u00ean<\/strong>: Ta s\u1eed d\u1ee5ng Autofill k\u00e9o th\u1ea3 \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c b\u1ea3ng d\u1eef li\u1ec7u<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-9.gif\" title=\"ex101_92019-nho-9\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u2013<strong>S\u1ed1:\u00a0<\/strong>S\u1eed d\u1ee5ng\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-randbetween-chon-ngau-nhien-trong-excel.html\">h\u00e0m RANDBETWEEN<\/a><\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Su_dung_ham_tao_Email_tu_ten_don_gian\"><\/span>S\u1eed d\u1ee5ng h\u00e0m t\u1ea1o Email t\u1eeb t\u00ean \u0111\u01a1n gi\u1ea3n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 t\u1ea1o m\u1ed9t email ta s\u1ebd k\u1ebft h\u1ee3p\u00a0<strong>h\u00e0m LOWER<\/strong> v\u00e0\u00a0<strong>h\u00e0m LEFT\u00a0<\/strong>nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=LOWER(LEFT(H\u1ecd)&amp;T\u00ean&amp;S\u1ed1)&amp;\u201dT\u00ean mi\u1ec1n\u201d<\/strong><\/p>\n<\/blockquote>\n<p>Ho\u1eb7c theo v\u00ed d\u1ee5:<\/p>\n<blockquote>\n<p><strong>=LOWER(LEFT(A2)&amp;B2&amp;C2)&amp;\u201d@gmail.com\u201d<\/strong><\/p>\n<\/blockquote>\n<p>K\u1ebft qu\u1ea3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25579\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tao-email-tu-ten-2.png\" width=\"397\" height=\"242\" title=\"tao-email-tu-ten-2\"><\/p>\n<p>\u00a0<\/p>\n<p>V\u1eady l\u00e0 ta \u0111\u00e3 t\u1ea1o \u0111\u01b0\u1ee3c m\u1ed9t m\u1eabu email c\u00f3 s\u1eb5n t\u1eeb t\u00ean r\u1ed3i. Ngo\u00e0i ra b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam c\u00e1c b\u00e0i vi\u1ebft kh\u00e1c:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-lower-trong-excel.html\"><strong>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m LOWER trong Excel<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-left-right-va-cach-su-dung-ham-left-right-trong-excel.html\"><strong>H\u00e0m LEFT, RIGHT v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng<\/strong><\/a><\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/lay-ten-tu-dia-chi-email-don-gian.html\">H\u01b0\u1edbng d\u1eabn l\u1ea5y t\u00ean t\u1eeb \u0111\u1ecba ch\u1ec9 Email<\/a><\/strong><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-9.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9115,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9114","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9114","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=9114"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9114\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9115"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9114"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}