{"id":8457,"date":"2024-12-22T14:38:37","date_gmt":"2024-12-22T14:38:37","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/tong-hop-cach-gui-email-tu-excel-bang-vba\/"},"modified":"2024-12-22T14:38:37","modified_gmt":"2024-12-22T14:38:37","slug":"tong-hop-cach-gui-email-tu-excel-bang-vba","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/tong-hop-cach-gui-email-tu-excel-bang-vba\/","title":{"rendered":"T\u1ed5ng h\u1ee3p c\u00e1ch g\u1eedi Email t\u1eeb Excel b\u1eb1ng VBA"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>B\u00e0i vi\u1ebft n\u00e0y s\u1ebd t\u1ed5ng h\u1ee3p c\u00e1c code VBA \u0111\u1ec3 g\u1eedi email t\u1eeb Excel cho c\u00e1c b\u1ea1n. Link download c\u00e1c v\u00ed d\u1ee5 \u1edf cu\u1ed1i b\u00e0i. N\u1ebfu b\u1ea1n \u0111\u00e3 like <a href=\"https:\/\/www.facebook.com\/www.hocexcel.online\/\" target=\"_blank\" rel=\"noopener noreferrer\">fanpage H\u1ecdc Excel Online<\/a> th\u00ec b\u1ea1n c\u00f3 th\u1ec3 nh\u00ecn th\u1ea5y n\u1ed9i dung n\u00e0y v\u00e0 download v\u1ec1 d\u00f9ng ngay, n\u1ebfu ch\u01b0a th\u00ec ch\u1ec9 c\u1ea7n b\u1ea5m n\u00fat like l\u00e0 s\u1ebd download \u0111\u01b0\u1ee3c t\u1ea5t c\u1ea3 c\u00e1c v\u00ed d\u1ee5 sau \u0111\u00e2y:<\/p>\n<ul>\n<li>01 \u2013 G\u1eedi Email c\u1ea3 workbook \u0111ang s\u1eed d\u1ee5ng<\/li>\n<li>02 \u2013 G\u1eedi 1 sheet qua email<\/li>\n<li>03 \u2013 G\u1eedi nhi\u1ec1u sheet qua email<\/li>\n<li>04 \u2013 G\u1eedi 1 v\u00f9ng ch\u1ecdn trong Excel qua Email<\/li>\n<li>05 \u2013 G\u1eedi t\u1ea5t c\u1ea3 b\u1ea3ng t\u00ednh c\u00f3 ch\u1ee9a \u0111\u1ecba ch\u1ec9 email trong \u00f4 A1<\/li>\n<li>06 \u2013 G\u1eedi Email cho nhi\u1ec1u ng\u01b0\u1eddi k\u00e8m theo nhi\u1ec1u file \u0111\u00ednh k\u00e8m<\/li>\n<\/ul>\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-6768246cd092e\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/gui-email-tu-excel-bang-vba.html#Chuan_bi_Outlook_de_co_the_chay_duoc_code\" title=\"Chu\u1ea9n b\u1ecb Outlook \u0111\u1ec3 c\u00f3 th\u1ec3 ch\u1ea1y \u0111\u01b0\u1ee3c code\">Chu\u1ea9n b\u1ecb Outlook \u0111\u1ec3 c\u00f3 th\u1ec3 ch\u1ea1y \u0111\u01b0\u1ee3c code<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/gui-email-tu-excel-bang-vba.html#Download_cac_truong_hop_gui_thu_di_tu_Excel\" title=\"Download c\u00e1c tr\u01b0\u1eddng h\u1ee3p g\u1eedi th\u01b0 \u0111i t\u1eeb Excel\">Download c\u00e1c tr\u01b0\u1eddng h\u1ee3p g\u1eedi th\u01b0 \u0111i t\u1eeb Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/gui-email-tu-excel-bang-vba.html#Lam_the_nao_de_chay_code_theo_y_cua_ban\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ch\u1ea1y code theo \u00fd c\u1ee7a b\u1ea1n?\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ch\u1ea1y code theo \u00fd c\u1ee7a b\u1ea1n?<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Chuan_bi_Outlook_de_co_the_chay_duoc_code\"><\/span>Chu\u1ea9n b\u1ecb Outlook \u0111\u1ec3 c\u00f3 th\u1ec3 ch\u1ea1y \u0111\u01b0\u1ee3c code<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tr\u01b0\u1edbc khi ch\u1ea1y code, b\u1ea1n ph\u1ea3i chu\u1ea9n b\u1ecb outlook 1 ch\u00fat \u0111\u1ec3 c\u00f3 th\u1ec3 th\u00e0nh c\u00f4ng.<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: Ch\u1ea1y Outlook v\u1edbi quy\u1ec1n Admin\u00a0b\u1eb1ng c\u00e1ch b\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng Outlook v\u00e0 ch\u1ecdn Run as administrator<\/p>\n<figure id=\"attachment_880\" aria-describedby=\"caption-attachment-880\" style=\"width: 784px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-10-28-at-19-16-43.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-880\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-10-28-at-19-16-43.png\" alt=\"Ch\u1ea1y Outlook v\u1edbi quy\u1ec1n Admin\" width=\"784\" height=\"544\" title=\"screen-shot-2016-10-28-at-19-16-43\"><\/a><figcaption id=\"caption-attachment-880\" class=\"wp-caption-text\">Ch\u1ea1y Outlook v\u1edbi quy\u1ec1n Admin<\/figcaption><\/figure>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: S\u1eed d\u1ee5ng Programmatic Access cho Outlook. Ch\u1ecdn th\u1ebb File &gt; Options &gt; Trust Center &gt; Trust Center Settings &gt; Th\u1ebb Programmatic Access &gt; B\u1ea5m d\u1ea5u t\u00edch v\u00e0o \u201cNever warn me about suspicious activity (not recommended) r\u1ed3i b\u1ea5m OK<\/p>\n<figure id=\"attachment_881\" aria-describedby=\"caption-attachment-881\" style=\"width: 672px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screenflow.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-881\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screenflow.gif\" alt=\"B\u1eadt Programmatic Access cho Outlook\" width=\"672\" height=\"550\" title=\"screenflow\"><\/a><figcaption id=\"caption-attachment-881\" class=\"wp-caption-text\">B\u1eadt Programmatic Access cho Outlook<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Download_cac_truong_hop_gui_thu_di_tu_Excel\"><\/span>Download c\u00e1c tr\u01b0\u1eddng h\u1ee3p g\u1eedi th\u01b0 \u0111i t\u1eeb Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/drive.google.com\/open?id=1izlGr0CcyY_TtxhYtxmGuK47LJu7FgPp\" target=\"_blank\" rel=\"noopener noreferrer\">Download t\u1ea5t c\u1ea3 v\u00ed d\u1ee5 t\u1eeb 01 \u0111\u1ebfn 06<\/a><\/p>\n<p>01 \u2013 G\u1eedi Email c\u1ea3 workbook \u0111ang s\u1eed d\u1ee5ng<\/p>\n<p>02 \u2013 G\u1eedi 1 sheet qua email<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-345.gif\" title=\"vba101_92019-nho-345\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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\/2024\/12\/ex101_92019-nho-777.gif\" title=\"ex101_92019-nho-777\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>03 \u2013 G\u1eedi nhi\u1ec1u sheet qua email<\/p>\n<p>04 \u2013 G\u1eedi 1 v\u00f9ng ch\u1ecdn trong Excel qua Email<\/p>\n<p>05 \u2013 G\u1eedi t\u1ea5t c\u1ea3 b\u1ea3ng t\u00ednh c\u00f3 ch\u1ee9a \u0111\u1ecba ch\u1ec9 email trong \u00f4 A1<\/p>\n<p>06 \u2013 G\u1eedi Email cho nhi\u1ec1u ng\u01b0\u1eddi k\u00e8m theo nhi\u1ec1u file \u0111\u00ednh k\u00e8m<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_chay_code_theo_y_cua_ban\"><\/span>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ch\u1ea1y code theo \u00fd c\u1ee7a b\u1ea1n?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: Download file excel b\u1ea1n c\u1ea7n \u1edf ph\u00eda tr\u00ean<\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: M\u1edf tr\u00ecnh so\u1ea1n th\u1ea3o VBA b\u1eb1ng c\u00e1ch b\u1ea5m ph\u00edm t\u1eaft <strong>ALT + F11<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 3<\/strong>: Thay Email trong code b\u1eb1ng Email c\u1ea7n d\u00f9ng \u1edf t\u1ea5t c\u1ea3 c\u00e1c v\u1ecb tr\u00ed <strong>.to = \u201c&lt;email&gt;\u201d, <\/strong>thay ti\u00eau \u0111\u1ec1 (Subject) v\u00e0 n\u1ed9i dung th\u01b0 (Body), \u2026<\/p>\n<p><strong>B\u01b0\u1edbc 4:\u00a0<span style=\"color: #ff0000\">Tr\u01b0\u1edbc khi ch\u1ea1y code, \u0111\u00f3ng Outlook!<\/span><\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 5<\/strong>: N\u1ebfu mu\u1ed1n thay \u0111\u1ed5i ho\u1eb7c s\u1eeda code theo \u00fd mu\u1ed1n, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-lap-trinh-vba-trong-excel\">l\u1edbp h\u1ecdc\u00a0VBA\u00a0\u1edf H\u00e0 N\u1ed9i<\/a>.<\/p>\n<figure id=\"attachment_882\" aria-describedby=\"caption-attachment-882\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2016\/10\/Screen-Shot-2016-10-28-at-19.30.40.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-882\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2016-10-28-at-19-30-40-1024x803-1.png\" alt=\"Ch\u1ec9nh l\u1ea1i email trong code\" width=\"1024\" height=\"803\" title=\"screen-shot-2016-10-28-at-19-30-40-1024x803-1\"><\/a><figcaption id=\"caption-attachment-882\" class=\"wp-caption-text\">Ch\u1ec9nh l\u1ea1i email trong code<\/figcaption><\/figure>\n<p><a href=\"http:\/\/www.hocexcel.online\/vba101-landing.html\">http:\/\/www.hocexcel.online\/vba101-landing.html<\/a><\/p>\n<p>VBA\u00a0gi\u00fap \u00edch\u00a0r\u1ea5t nhi\u1ec1u trong c\u00f4ng vi\u1ec7c: gi\u00fap b\u1ea1n t\u0103ng t\u1ed1c trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd tr\u00ean Excel, gi\u00fap l\u1eadp c\u00e1c b\u00e1o c\u00e1o t\u1ef1 \u0111\u1ed9ng, \u0111i\u1ec1u khi\u1ec3n c\u00e1c ch\u01b0\u01a1ng tr\u00ecnh kh\u00e1c nh\u01b0 Word, Power Point, Outlook\u2026 gi\u00fap bi\u1ebfn file Excel c\u1ee7a b\u1ea1n tr\u1edf th\u00e0nh 1 ph\u1ea7n m\u1ec1m chuy\u00ean nghi\u1ec7p\u2026<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 h\u1ecdc VBA m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, c\u00f3 h\u1ec7 th\u1ed1ng, b\u1ea1n h\u00e3y tham gia kho\u00e1 h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2OAUBOg\">VBA101 \u2013 VBA c\u01a1 b\u1ea3n d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/a>\u00a0c\u1ee7a h\u1ec7 th\u1ed1ng H\u1ecdc Excel Online. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. Chi ti\u1ebft xem t\u1ea1i:<\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-345.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8458,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8457","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8457","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=8457"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8457\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8458"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8457"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8457"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8457"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}