{"id":7238,"date":"2024-12-21T17:09:36","date_gmt":"2024-12-21T17:09:36","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-nhap-dia-chi-lien-he-vao-outlook-tu-excel-theo-ba-buoc\/"},"modified":"2024-12-21T17:09:36","modified_gmt":"2024-12-21T17:09:36","slug":"cach-nhap-dia-chi-lien-he-vao-outlook-tu-excel-theo-ba-buoc","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-nhap-dia-chi-lien-he-vao-outlook-tu-excel-theo-ba-buoc\/","title":{"rendered":"C\u00e1ch nh\u1eadp \u0111\u1ecba ch\u1ec9 li\u00ean h\u1ec7 v\u00e0o Outlook t\u1eeb Excel theo ba b\u01b0\u1edbc"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em>Trong b\u00e0i n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn cho b\u1ea1n c\u00e1ch nh\u1eadp \u0111\u1ecba ch\u1ec9 li\u00ean l\u1ea1c t\u1eeb Excel sang Outlook 2010-2013.\u00a0C\u00f3 ba b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n truy xu\u1ea5t \u0111\u1ecba ch\u1ec9 li\u00ean h\u1ec7.\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/cach-chuyen-doi-excel-sang-csv-va-xuat-cac-tep-excel-sang-dinh-dang-csv-utf-8.html\" target=\"_blank\" rel=\"noopener noreferrer\">Chuy\u1ec3n d\u1eef li\u1ec7u sang \u0111\u1ecbnh d\u1ea1ng .csv<\/a>, nh\u1eadp ch\u00fang v\u00e0o Outlook v\u1edbi m\u1ed9t th\u1ee7 thu\u1eadt \u0111\u1eb7c bi\u1ec7t v\u00e0 \u0111i\u1ec1u ch\u1ec9nh cho c\u00e1c ti\u00eau \u0111\u1ec1 Excel \u0103n kh\u1edbp v\u1edbi c\u00e1c tr\u01b0\u1eddng t\u01b0\u01a1ng \u1ee9ng.<\/em><\/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-6766f64f494b8\" 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\/cach-nhap-dia-chi-lien-vao-outlook-tu-excel-theo-ba-buoc.html#Chuan_bi_du_lieu_lien_lac_Excel_cua_ban_de_duoc_nhap_vao_Outlook\" title=\"Chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u li\u00ean l\u1ea1c Excel c\u1ee7a b\u1ea1n \u0111\u1ec3 \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o Outlook\">Chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u li\u00ean l\u1ea1c Excel c\u1ee7a b\u1ea1n \u0111\u1ec3 \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o Outlook<\/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\/cach-nhap-dia-chi-lien-vao-outlook-tu-excel-theo-ba-buoc.html#Nhap_dia_chi_lien_he_tu_Excel_sang_Outlook\" title=\"Nh\u1eadp \u0111\u1ecba ch\u1ec9 li\u00ean h\u1ec7 t\u1eeb Excel sang Outlook\">Nh\u1eadp \u0111\u1ecba ch\u1ec9 li\u00ean h\u1ec7 t\u1eeb Excel sang Outlook<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-nhap-dia-chi-lien-vao-outlook-tu-excel-theo-ba-buoc.html#Dieu_chinh_cho_Excel_khop_voi_cac_truong_Outlook_tuong_ung\" title=\"\u0110i\u1ec1u ch\u1ec9nh cho Excel kh\u1edbp v\u1edbi c\u00e1c tr\u01b0\u1eddng Outlook t\u01b0\u01a1ng \u1ee9ng\">\u0110i\u1ec1u ch\u1ec9nh cho Excel kh\u1edbp v\u1edbi c\u00e1c tr\u01b0\u1eddng Outlook t\u01b0\u01a1ng \u1ee9ng<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Chuan_bi_du_lieu_lien_lac_Excel_cua_ban_de_duoc_nhap_vao_Outlook\"><\/span><strong>Chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u li\u00ean l\u1ea1c Excel c\u1ee7a b\u1ea1n \u0111\u1ec3 \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o Outlook<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">C\u00e1ch d\u1ec5 nh\u1ea5t \u0111\u1ec3 \u0111\u1ecba ch\u1ec9 li\u00ean l\u1ea1c c\u00f3 th\u1ec3 th\u00eam t\u1eeb Excel sang Outlook l\u00e0 l\u01b0u b\u1ea3ng t\u00ednh \u1edf \u0111\u1ecbnh d\u1ea1ng CSV.\u00a0C\u00e1ch n\u00e0y \u00e1p d\u1ee5ng cho b\u1ea5t k\u1ef3 phi\u00ean b\u1ea3n Office n\u00e0o v\u00e0 cho ph\u00e9p b\u1ea1n b\u1ecf qua m\u1ed9t s\u1ed1 v\u1ea5n \u0111\u1ec1 nh\u01b0 ph\u1ea1m vi \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean ho\u1eb7c \u0111\u1ecba ch\u1ec9 li\u00ean h\u1ec7 tr\u1ed1ng.<\/p>\n<ol style=\"text-align: justify\">\n<li>Trong b\u1ea3ng t\u00ednh, m\u1edf c\u00e1c li\u00ean h\u1ec7 chi ti\u1ebft b\u1ea1n mu\u1ed1n nh\u1eadp v\u00e0o Outlook 2010-2013.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6006\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-118.png\" width=\"600\" height=\"215\" title=\"excel-dialog-box-launcher-1-118\"><\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>Nh\u1ea5p v\u00e0o\u00a0<em>Flie\u00a0<\/em>v\u00e0 ch\u1ecdn <em>Save As<\/em>.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6007\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-119.png\" width=\"600\" height=\"318\" title=\"excel-dialog-box-launcher-1-119\"><\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li>Ch\u1ecdn v\u1ecb tr\u00ed \u0111\u1ec3 l\u01b0u t\u1ec7p c\u1ee7a b\u1ea1n.<\/li>\n<li>B\u1ea1n s\u1ebd th\u1ea5y\u00a0h\u1ed9p tho\u1ea1i\u00a0<em>Save As<\/em>.\u00a0Ch\u1ecdn tu\u1ef3 ch\u1ecdn\u00a0<em>CSV<\/em> <em>(Comma delimited)<\/em>\u00a0 m\u1ee5c <em>Save as type<\/em>\u00a0 v\u00e0 nh\u1ea5n\u00a0<em>Save<\/em>.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-file-saveas-scv.png\" alt=\"Choose the option CSV (Comma delimited) from the Save as type drop-down list\" title=\"excel-file-saveas-scv\">5. B\u1ea1n s\u1ebd th\u1ea5y th\u00f4ng b\u00e1o sau t\u1eeb Excel:\u00a0<em>The selected file type does not contain workbooks that contain multiple sheets.<\/em><em> (<\/em><em>Ki\u1ec3u t\u1ec7p \u0111\u00e3 ch\u1ecdn kh\u00f4ng ch\u1ee9a c\u00e1c b\u1ea3ng t\u00ednh c\u00f3 nhi\u1ec1u trang<\/em><em>).<\/em><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6008\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-120.png\" width=\"600\" height=\"128\" title=\"excel-dialog-box-launcher-1-120\"><\/p>\n<p style=\"text-align: justify\"><em>Th\u00f4ng b\u00e1o n\u00e0y cho b\u1ea1n bi\u1ebft v\u1ec1 gi\u1edbi h\u1ea1n c\u1ee7a t\u1ec7p CSV.\u00a0Xin \u0111\u1eebng lo l\u1eafng, b\u1ea3ng t\u00ednh g\u1ed1c c\u1ee7a b\u1ea1n s\u1ebd v\u1eabn nh\u01b0 c\u0169.\u00a0Ch\u1ec9 c\u1ea7n nh\u1ea5p v\u00e0o\u00a0OK\u00a0.<\/em><\/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-289.gif\" title=\"vba101_92019-nho-289\"><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-654.gif\" title=\"ex101_92019-nho-654\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">6. Sau khi nh\u1ea5p v\u00e0o\u00a0<em>OK<\/em>, b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y m\u1ed9t th\u00f4ng b\u00e1o kh\u00e1c n\u00f3i r\u1eb1ng:\u00a0<em>Some features in your workbook might be lost if you save it as CSV (Comma delimited)<\/em> (<em>M\u1ed9t s\u1ed1 t\u00ednh n\u0103ng trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n c\u00f3 th\u1ec3 b\u1ecb m\u1ea5t n\u1ebfu b\u1ea1n l\u01b0u n\u00f3 d\u01b0\u1edbi d\u1ea1ng CSV (Comma delimited)).<\/em><\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/message-features-lost-scv.png\" alt=\"See the message Some features in your workbook might be lost if you save it as CSV\" title=\"message-features-lost-scv\"><\/p>\n<p style=\"text-align: justify\">Th\u00f4ng b\u00e1o n\u00e0y c\u00f3 th\u1ec3 b\u1ecf qua.\u00a0Do \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5p v\u00e0o\u00a0<em>Yes<\/em>\u00a0\u0111\u1ec3 b\u1ea3ng t\u00ednh hi\u1ec7n t\u1ea1i c\u1ee7a b\u1ea1n l\u01b0u v\u1edbi \u0111\u1ecbnh d\u1ea1ng CSV.\u00a0B\u1ea3ng t\u00ednh g\u1ed1c (t\u1ec7p .xlsx) s\u1ebd b\u1ecb \u0111\u00f3ng v\u00e0 b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 nh\u1eadn th\u1ea5y r\u1eb1ng t\u00ean c\u1ee7a trang hi\u1ec7n t\u1ea1i c\u1ee7a b\u1ea1n s\u1ebd thay \u0111\u1ed5i.<\/p>\n<ol style=\"text-align: justify\" start=\"7\">\n<li>\u0110\u00f3ng t\u1ec7p CSV m\u1edbi c\u1ee7a b\u1ea1n.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd b\u1ea1n \u0111\u00e3 s\u1eb5n s\u00e0ng \u0111\u1ec3 th\u00eam \u0111\u1ecba ch\u1ec9 li\u00ean l\u1ea1c v\u00e0o Outlook.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Nhap_dia_chi_lien_he_tu_Excel_sang_Outlook\"><\/span><strong>Nh\u1eadp \u0111\u1ecba ch\u1ec9 li\u00ean h\u1ec7 t\u1eeb Excel sang Outlook<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u1ede b\u01b0\u1edbc n\u00e0y, b\u1ea1n s\u1ebd th\u1ea5y c\u00e1ch nh\u1eadp c\u00e1c \u0111\u1ecba ch\u1ec9 li\u00ean h\u1ec7 t\u1eeb Outlook sang Excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng\u00a0<a href=\"http:\/\/www.outlookimport.com\/vi\/description\/outlook-export-wizard\/\" target=\"_blank\" rel=\"noopener noreferrer\"><em>Import and Export Wizard.<\/em><\/a><\/p>\n<ol style=\"text-align: justify\">\n<li>M\u1edf Outlook, v\u00e0o\u00a0<em>File&gt; Open &amp; Export<\/em>v\u00e0 nh\u1ea5p v\u00e0o t\u00f9y ch\u1ecdn\u00a0<em>Import\/Export<\/em>.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/outlook-file-import-export.png\" alt=\"Click the option Import\/Export\" title=\"outlook-file-import-export\"><\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>B\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c\u00a0<em>Import and Export Wizard<\/em>\u00a0.\u00a0Ch\u1ecdn <em>Import from another program or file<\/em>\u00a0 v\u00e0 nh\u1ea5p v\u00e0o\u00a0n\u00fat\u00a0<em>Next<\/em><em>.<\/em><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/outlook-import-program-file.png\" alt=\"Select the option Import from another program or file\" title=\"outlook-import-program-file\"><\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li>T\u1ea1i b\u01b0\u1edbc\u00a0<em>Import a File<\/em>c\u1ee7a wizard, ch\u1ecdn\u00a0<em>Comma Separated Values<\/em>\u00a0v\u00e0 k\u00edch\u00a0<em>Next<\/em>.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/outlook-comma-separated-values.png\" alt=\"Pick Comma Separated Values\" title=\"outlook-comma-separated-values\"><\/p>\n<ol style=\"text-align: justify\" start=\"4\">\n<li>Nh\u1ea5p v\u00e0o\u00a0n\u00fat\u00a0<em>Browse\u00a0 <\/em>v\u00e0 t\u00ecm t\u1ec7p .csv b\u1ea1n mu\u1ed1n nh\u1eadp.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">\u1ede b\u01b0\u1edbc n\u00e0y b\u1ea1n c\u0169ng s\u1ebd th\u1ea5y c\u00e1c n\u00fat b\u00ean d\u01b0\u1edbi\u00a0<em>Options\u00a0<\/em>\u00a0cho ph\u00e9p b\u1ea1n kh\u00f4ng nh\u1eadp c\u00e1c ph\u1ea7n tr\u00f9ng l\u1eb7p, thay th\u1ebf c\u00e1c li\u00ean h\u1ec7 hi\u1ec7n c\u00f3 ho\u1eb7c t\u1ea1o nh\u1eefng m\u1ee5c sao ch\u00e9p.\u00a0N\u1ebfu b\u1ea1n xu\u1ea5t th\u00f4ng tin danh b\u1ea1 c\u1ee7a b\u1ea1n t\u1eeb Excel v\u00e0 mu\u1ed1n nh\u1eadp ch\u00fang tr\u1edf l\u1ea1i\u00a0Outlook, th\u00ec ph\u1ea3i ch\u1ecdn n\u00fat \u0111\u1ea7u ti\u00ean.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/outlook-import-options-group.png\" alt=\"Pick Comma Separated Values\" title=\"outlook-import-options-group\"><\/p>\n<ol style=\"text-align: justify\" start=\"5\">\n<li>Nh\u1ea5p v\u00e0o\u00a0n\u00fat\u00a0<em>Next\u00a0<\/em>\u0111\u1ec3 ch\u1ecdn \u0111\u00edch \u0111\u1ebfn cho email c\u1ee7a b\u1ea1n.\u00a0Th\u01b0 m\u1ee5c <em>Contacts<\/em>\u00a0 n\u00ean \u0111\u01b0\u1ee3c ch\u1ecdn theo m\u1eb7c \u0111\u1ecbnh.\u00a0N\u1ebfu kh\u00f4ng, b\u1ea1n c\u00f3 th\u1ec3 cu\u1ed9n l\u00ean ho\u1eb7c xu\u1ed1ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed t\u1ec7p.\u00a0C\u0169ng c\u00f3 th\u1ec3 ch\u1ecdn m\u1ed9t th\u01b0 m\u1ee5c kh\u00e1c<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/outlook-import-contacts-folder.png\" alt=\"Pick the Contacts folder\" title=\"outlook-import-contacts-folder\"><\/p>\n<ol style=\"text-align: justify\" start=\"6\">\n<li>Sau khi nh\u1ea5p v\u00e0o\u00a0<em>Next,,<\/em>b\u1ea1n s\u1ebd th\u1ea5y h\u1ed9p ki\u1ec3m\u00a0<em>Import \u201cYour File Name.csv\u201d into folder: Contacts \u201c<\/em>.\u00a0H\u00e3y \u0111\u1ea3m b\u1ea3o check v\u00e0o \u0111\u00f3.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/outlook-import-last-step.png\" alt=\"Tick the checkbox Import\" title=\"outlook-import-last-step\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1eebng v\u1ed9i nh\u1ea5n v\u00e0o\u00a0<em>Finish<\/em><em>.<\/em>\u00a0B\u1ea1n c\u1ea7n k\u1ebft h\u1ee3p m\u1ed9t s\u1ed1 c\u1ed9t trong t\u1ec7p CSV c\u1ee7a m\u00ecnh v\u00e0o c\u00e1c tr\u01b0\u1eddng li\u00ean h\u1ec7 trong Outlook.\u00a0Thao t\u00e1c n\u00e0y s\u1ebd nh\u1eadp \u0111\u1ecba ch\u1ec9 li\u00ean h\u1ec7 c\u1ee7a b\u1ea1n t\u1eeb Excel sang Outlook ch\u00ednh x\u00e1c nh\u01b0 b\u1ea1n mu\u1ed1n.\u00a0Ti\u1ebfp t\u1ee5c l\u00e0m theo c\u00e1c b\u01b0\u1edbc ti\u1ebfp theo<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Dieu_chinh_cho_Excel_khop_voi_cac_truong_Outlook_tuong_ung\"><\/span><strong>\u0110i\u1ec1u ch\u1ec9nh cho Excel <\/strong><strong>kh\u1edbp<\/strong><strong> v\u1edbi c\u00e1c tr\u01b0\u1eddng Outlook t\u01b0\u01a1ng \u1ee9ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ec3 \u0111\u1ea3m b\u1ea3o r\u1eb1ng c\u00e1c chi ti\u1ebft t\u1eeb c\u00e1c \u0111\u1ecba ch\u1ec9 li\u00ean h\u1ec7 b\u1ea1n \u0111\u00e3 nh\u1eadp xu\u1ea5t hi\u1ec7n trong c\u00e1c tr\u01b0\u1eddng t\u01b0\u01a1ng \u1ee9ng trong Outlook, s\u1eed d\u1ee5ng\u00a0h\u1ed9p tho\u1ea1i <em>Map Custom Fields <\/em>tr\u00ean b\u01b0\u1edbc cu\u1ed1i c\u00f9ng c\u1ee7a\u00a0<em>Import and Export Wizard.<\/em><\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn\u00a0<em>Import \u201cYour File Name.csv\u201d into folder: Contacts<\/em> \u0111\u1ec3 k\u00edch ho\u1ea1t n\u00fat\u00a0<em>Map Custom Fields\u2026.<\/em>Nh\u1ea5p v\u00e0o n\u00fat n\u00e0y \u0111\u1ec3 h\u1ed9p tho\u1ea1i t\u01b0\u01a1ng \u1ee9ng xu\u1ea5t hi\u1ec7n.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/button-map-custom-fields.png\" alt=\"Click on the Map Custom Fields button\" title=\"button-map-custom-fields\"><\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>B\u1ea1n s\u1ebd th\u1ea5y\u00a0<em>From:<\/em>v\u00e0\u00a0<em>To<\/em>\u00a0: tr\u00ean\u00a0<em>Map Custom Fields\u00a0dialog<\/em>\u00a0.\u00a0<em>From<\/em>\u00a0: ch\u1ee9a ti\u00eau \u0111\u1ec1 c\u1ed9t t\u1eeb t\u1ec7p CSV c\u1ee7a b\u1ea1n.\u00a0Trong\u00a0<em>To<\/em>\u00a0, b\u1ea1n s\u1ebd th\u1ea5y c\u00e1c tr\u01b0\u1eddng Outlook ti\u00eau chu\u1ea9n cho c\u00e1c \u0111\u1ecba ch\u1ec9 li\u00ean h\u1ec7.\u00a0N\u1ebfu m\u1ed9t tr\u01b0\u1eddng kh\u1edbp v\u1edbi m\u1ed9t c\u1ed9t trong t\u1ec7p CSV, b\u1ea1n s\u1ebd th\u1ea5y c\u1ed9t c\u1ee7a m\u00ecnh trong\u00a0<em>Mapped from.<\/em><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/map-custom-fields-dialog.png\" alt=\"See the From: and To: sections on the Map Custom Fields dialog\" title=\"map-custom-fields-dialog\"><\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li>C\u00e1c tr\u01b0\u1eddng\u00a0<em>Name,\u00a0First Name<\/em>l\u00e0 c\u00e1c tr\u01b0\u1eddng Outlook c\u01a1 b\u1ea3n, v\u00ec v\u1eady n\u1ebfu chi ti\u1ebft li\u00ean l\u1ea1c trong t\u1ec7p c\u1ee7a b\u1ea1n c\u00f3 b\u1ea5t k\u1ef3 t\u00ean li\u00ean h\u1ec7 n\u00e0o, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp v\u00e0o.<\/li>\n<li>B\u1ea1n c\u0169ng c\u1ea7n ph\u1ea3i t\u1ea1o m\u1ed9t mapping th\u1ee7 c\u00f4ng.\u00a0V\u00ed d\u1ee5: trong t\u1ec7p c\u1ee7a b\u1ea1n, \u0111i\u1ec7n tho\u1ea1i c\u1ee7a ng\u01b0\u1eddi li\u00ean h\u1ec7 n\u1eb1m trong c\u1ed9t\u00a0<em>Phone number<\/em>.\u00a0Outlook c\u00f3 nhi\u1ec1u tr\u01b0\u1eddng ch\u1ee9a s\u1ed1 \u0111i\u1ec7n tho\u1ea1i, ch\u1eb3ng h\u1ea1n nh\u01b0\u00a0<em>Business, Home, Car,..<\/em>.\u00a0V\u00ec v\u1eady, b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm th\u1ea5y m\u1ed9t k\u1ebft n\u1ed1i t\u01b0\u01a1ng \u0111\u01b0\u01a1ng b\u1eb1ng c\u00e1ch cu\u1ed9n trong \u00f4\u00a0<em>To<\/em>\u00a0:.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/custom-fields-business-phone.png\" alt=\"Scroll down in the To: pane and find the necessary Phone option\" title=\"custom-fields-business-phone\"><\/p>\n<ol style=\"text-align: justify\" start=\"5\">\n<li>Khi b\u1ea1n t\u00ecm th\u1ea5y t\u00f9y ch\u1ecdn \u0111\u00fang, v\u00ed d\u1ee5:\u00a0<em>Business Phone,<\/em> ch\u1ec9 c\u1ea7n ch\u1ecdn\u00a0<em>Phone number <\/em>trong\u00a0<em>From<\/em>.\u00a0Sau \u0111\u00f3 k\u00e9o v\u00e0 th\u1ea3 n\u00f3 v\u00e0o\u00a0<em>Business Phone<\/em> \u00a0trong h\u1ed9p\u00a0<em>T<\/em><em>o<\/em><em>:<\/em><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/fields-drag-drop-phone.png\" alt=\"Map the field by drag-n-dropping\" title=\"fields-drag-drop-phone\"><\/p>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd b\u1ea1n c\u00f3 th\u1ec3 xem\u00a0ti\u00eau \u0111\u1ec1 c\u1ed9t\u00a0<em>Phone number\u00a0<\/em>\u00a0b\u00ean\u00a0 c\u1ea1nh\u00a0tr\u01b0\u1eddng\u00a0<em>Business Phone<\/em>\u00a0.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/fields-map-phone.png\" alt=\"see the Phone number column header next to the Business Phone field\" title=\"fields-map-phone\"><\/p>\n<ol style=\"text-align: justify\" start=\"6\">\n<li>K\u00e9o c\u00e1c m\u1ee5c kh\u00e1c t\u1eeb khung b\u00ean tr\u00e1i sang c\u00e1c tr\u01b0\u1eddng Outlook th\u00edch h\u1ee3p v\u00e0 nh\u1ea5p v\u00e0o Finish .<\/li>\n<\/ol>\n<p style=\"text-align: justify\">\u0110\u1ecba ch\u1ec9 li\u00ean h\u1ec7 c\u1ee7a b\u1ea1n \u0111\u00e3 \u0111\u01b0\u1ee3c th\u00eam th\u00e0nh c\u00f4ng v\u00e0o Outlook t\u1eeb Excel.<\/p>\n<p style=\"text-align: justify\"><b><\/b>Excel kh\u00f4ng ch\u1ec9 b\u00f3 h\u1eb9p \u1edf c\u00e1c h\u00e0m hay c\u00e1c c\u00f4ng c\u1ee5 t\u1ea1i m\u00e1y t\u00ednh c\u1ee7a b\u1ea1n, m\u00e0 c\u00f2n v\u00f4 v\u00e0n \u1ee9ng d\u1ee5ng kh\u00e1c khi m\u00e1y t\u00ednh li\u00ean k\u1ebft v\u1edbi nh\u1eefng ch\u01b0\u01a1ng tr\u00ecnh kh\u00e1c.<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2w6YAe8\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc\u00a0n\u00e0y. Chi ti\u1ebft v\u1ec1 kh\u00f3a h\u1ecdc, b\u1ea1n vui l\u00f2ng 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-289.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7239,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7238","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\/7238","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=7238"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7238\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7239"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7238"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7238"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7238"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}