{"id":29719,"date":"2026-09-29T10:15:00","date_gmt":"2026-09-29T03:15:00","guid":{"rendered":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/?p=29719"},"modified":"2026-09-29T17:26:50","modified_gmt":"2026-09-29T10:26:50","slug":"mail-merge-tron-thu-hang-loat","status":"publish","type":"post","link":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/tu-van-nghe-nghiep\/mail-merge-tron-thu-hang-loat","title":{"rendered":"Mail merge l\u00e0 g\u00ec v\u00e0 c\u00e1ch tr\u1ed9n th\u01b0 h\u00e0ng lo\u1ea1t trong Word kh\u00f4ng l\u1ed7i"},"content":{"rendered":"<p>B\u1ea1n c\u1ea7n g\u1eedi h\u00e0ng tr\u0103m th\u01b0 m\u1eddi, phi\u1ebfu l\u01b0\u01a1ng hay gi\u1ea5y ch\u1ee9ng nh\u1eadn, m\u1ed7i b\u1ea3n ch\u1ec9 kh\u00e1c nhau v\u00e0i d\u00f2ng t\u00ean v\u00e0 s\u1ed1 li\u1ec7u, c\u00f2n vi\u1ec7c s\u1eeda tay t\u1eebng b\u1ea3n th\u00ec v\u1eeba l\u00e2u v\u1eeba d\u1ec5 sai. \u0110\u00e2y ch\u00ednh l\u00e0 l\u00fac t\u00ednh n\u0103ng <strong>mail merge<\/strong> ph\u00e1t huy t\u00e1c d\u1ee5ng: n\u00f3 gh\u00e9p m\u1ed9t m\u1eabu chung v\u1edbi m\u1ed9t danh s\u00e1ch d\u1eef li\u1ec7u \u0111\u1ec3 t\u1ea1o ra h\u00e0ng lo\u1ea1t b\u1ea3n ri\u00eang bi\u1ec7t cho t\u1eebng ng\u01b0\u1eddi.<\/p>\n<p style=\"text-align:center\"><img decoding=\"async\" src=\"https:\/\/cl-wpml.careerlink.vn\/cam-nang-viec-lam\/wp-content\/uploads\/2026\/09\/27070718\/a-mail-merge-tron-thu-hang-loat-1.png\" alt=\"mail merge tr\u1ed9n th\u01b0 h\u00e0ng lo\u1ea1t\" style=\"max-width:100%;height:auto;\" \/><\/p>\n<div style=\"background:#e3f2fd;border-left:4px solid #1565c0;padding:15px 20px;margin:20px 0;border-radius:4px\">\n<p><strong>T\u1ed5ng quan nhanh<\/strong><\/p>\n<p>\u2013 Tr\u1ed9n th\u01b0 l\u00e0 k\u1ef9 thu\u1eadt gh\u00e9p m\u1ed9t t\u00e0i li\u1ec7u m\u1eabu v\u1edbi m\u1ed9t danh s\u00e1ch d\u1eef li\u1ec7u \u0111\u1ec3 in ra nhi\u1ec1u b\u1ea3n c\u00e1 nh\u00e2n h\u00f3a.<\/p>\n<p>\u2013 M\u1ed9t l\u1ea7n tr\u1ed9n c\u1ea7n \u0111\u1ee7 ba th\u00e0nh ph\u1ea7n: t\u00e0i li\u1ec7u ch\u00ednh, ngu\u1ed3n d\u1eef li\u1ec7u v\u00e0 c\u00e1c tr\u01b0\u1eddng tr\u1ed9n.<\/p>\n<p>\u2013 Ph\u1ea7n l\u1edbn l\u1ed7i kh\u00f4ng n\u1eb1m \u1edf thao t\u00e1c b\u1ea5m n\u00fat m\u00e0 n\u1eb1m \u1edf c\u00e1ch tr\u00ecnh b\u00e0y file d\u1eef li\u1ec7u ngu\u1ed3n.<\/p>\n<p>\u2013 K\u1ef9 thu\u1eadt n\u00e0y d\u00f9ng \u0111\u01b0\u1ee3c cho c\u1ea3 email, nh\u00e3n d\u00e1n, phong b\u00ec l\u1eabn gi\u1ea5y khen ch\u1ee9 kh\u00f4ng ri\u00eang th\u01b0 t\u1eeb.<\/p>\n<\/div>\n<p>B\u1ed1n \u00fd tr\u00ean l\u00e0 khung c\u1ee7a b\u00e0i, \u0111i t\u1eeb kh\u00e1i ni\u1ec7m t\u1edbi quy tr\u00ecnh r\u1ed3i t\u1edbi c\u00e1c l\u1ed7i hay g\u1eb7p.<\/p>\n<h2>1. Mail merge l\u00e0 g\u00ec v\u00e0 khi n\u00e0o n\u00ean d\u00f9ng<\/h2>\n<p>V\u1ec1 b\u1ea3n ch\u1ea5t, mail merge l\u00e0 c\u00e1ch \u0111\u1ec3 m\u1ed9t m\u1eabu t\u00e0i li\u1ec7u t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n d\u1eef li\u1ec7u kh\u00e1c nhau cho t\u1eebng ng\u01b0\u1eddi nh\u1eadn, thay v\u00ec b\u1ea1n ph\u1ea3i ch\u00e9p v\u00e0 s\u1eeda th\u1ee7 c\u00f4ng. B\u1ea1n so\u1ea1n m\u1ed9t l\u1ea7n ph\u1ea7n c\u1ed1 \u0111\u1ecbnh nh\u01b0 l\u1eddi ch\u00e0o, n\u1ed9i dung ch\u00ednh, ch\u1eef k\u00fd, r\u1ed3i \u0111\u00e1nh d\u1ea5u nh\u1eefng ch\u1ed7 c\u1ea7n thay \u0111\u1ed5i nh\u01b0 h\u1ecd t\u00ean, ph\u00f2ng ban, s\u1ed1 ti\u1ec1n. Ph\u1ea7n m\u1ec1m s\u1ebd l\u1ea7n l\u01b0\u1ee3t l\u1ea5y t\u1eebng d\u00f2ng trong danh s\u00e1ch \u0111\u1ec3 t\u1ea1o ra m\u1ed9t b\u1ea3n ho\u00e0n ch\u1ec9nh ri\u00eang.<\/p>\n<p>Mail merge \u0111\u00e1ng d\u00f9ng khi s\u1ed1 l\u01b0\u1ee3ng b\u1ea3n \u0111\u1ee7 l\u1edbn v\u00e0 c\u1ea5u tr\u00fac l\u1eb7p l\u1ea1i, ch\u1eb3ng h\u1ea1n th\u01b0 m\u1eddi ph\u1ecfng v\u1ea5n cho nhi\u1ec1u \u1ee9ng vi\u00ean, phi\u1ebfu l\u01b0\u01a1ng h\u00e0ng th\u00e1ng, hay gi\u1ea5y x\u00e1c nh\u1eadn c\u00f4ng t\u00e1c. N\u1ebfu ch\u1ec9 c\u00f3 v\u00e0i b\u1ea3n, g\u00f5 tay c\u00f3 khi c\u00f2n nhanh h\u01a1n c\u00f4ng s\u1ee9c thi\u1ebft l\u1eadp ban \u0111\u1ea7u.<\/p>\n<h2>2. Ba th\u00e0nh ph\u1ea7n t\u1ea1o n\u00ean m\u1ed9t l\u1ea7n tr\u1ed9n th\u01b0<\/h2>\n<p>M\u1ecdi l\u1ea7n mail merge, d\u00f9 \u0111\u01a1n gi\u1ea3n hay ph\u1ee9c t\u1ea1p, \u0111\u1ec1u d\u1ef1ng tr\u00ean \u0111\u00fang ba kh\u1ed1i. Hi\u1ec3u r\u00f5 vai tr\u00f2 c\u1ee7a t\u1eebng kh\u1ed1i gi\u00fap b\u1ea1n khoanh v\u00f9ng l\u1ed7i nhanh khi k\u1ebft qu\u1ea3 ra sai.<\/p>\n<table class=\"table table-bordered table-striped\">\n<thead>\n<tr style=\"background:#1565c0;color:#fff\">\n<th>Th\u00e0nh ph\u1ea7n<\/th>\n<th>Vai tr\u00f2<\/th>\n<th>V\u00ed d\u1ee5 th\u1ef1c t\u1ebf<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>T\u00e0i li\u1ec7u ch\u00ednh<\/td>\n<td>Ch\u1ee9a ph\u1ea7n n\u1ed9i dung c\u1ed1 \u0111\u1ecbnh d\u00f9ng chung cho m\u1ecdi b\u1ea3n<\/td>\n<td>M\u1eabu th\u01b0 m\u1eddi, m\u1eabu phi\u1ebfu l\u01b0\u01a1ng<\/td>\n<\/tr>\n<tr style=\"background:#f0f7ff\">\n<td>Ngu\u1ed3n d\u1eef li\u1ec7u<\/td>\n<td>B\u1ea3ng ch\u1ee9a th\u00f4ng tin thay \u0111\u1ed5i theo t\u1eebng ng\u01b0\u1eddi nh\u1eadn<\/td>\n<td>File Excel danh s\u00e1ch nh\u00e2n vi\u00ean<\/td>\n<\/tr>\n<tr>\n<td>Tr\u01b0\u1eddng tr\u1ed9n<\/td>\n<td>V\u1ecb tr\u00ed \u0111\u00e1nh d\u1ea5u \u0111\u1ec3 h\u1ec7 th\u1ed1ng ch\u00e8n d\u1eef li\u1ec7u v\u00e0o t\u00e0i li\u1ec7u<\/td>\n<td>\u00d4 ghi h\u1ecd t\u00ean, ch\u1ee9c danh, s\u1ed1 ti\u1ec1n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Tr\u01b0\u1eddng tr\u1ed9n th\u01b0\u1eddng hi\u1ec3n th\u1ecb d\u01b0\u1edbi d\u1ea1ng t\u00ean c\u1ed9t \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p nh\u1ecdn, v\u00e0 m\u1ed7i tr\u01b0\u1eddng ph\u1ea3i kh\u1edbp \u0111\u00fang m\u1ed9t ti\u00eau \u0111\u1ec1 c\u1ed9t trong ngu\u1ed3n d\u1eef li\u1ec7u. B\u1ed9 c\u00f4ng c\u1ee5 v\u0103n ph\u00f2ng ph\u1ed5 bi\u1ebfn cho vi\u1ec7c n\u00e0y n\u1eb1m trong h\u1ec7 sinh th\u00e1i c\u1ee7a Microsoft, v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ecdc th\u00eam b\u00e0i <a href=\"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/tu-van-nghe-nghiep\/microsoft-la-gi\" style=\"color:#1565c0;font-weight:600;text-decoration:underline\">Microsoft l\u00e0 g\u00ec<\/a> \u0111\u1ec3 n\u1eafm b\u1ee9c tranh chung v\u1ec1 b\u1ed9 \u1ee9ng d\u1ee5ng n\u00e0y tr\u01b0\u1edbc khi \u0111i v\u00e0o thao t\u00e1c.<\/p>\n<h2>3. Quy tr\u00ecnh tr\u1ed9n th\u01b0 trong Word v\u1edbi ngu\u1ed3n d\u1eef li\u1ec7u Excel<\/h2>\n<p>\u1ede m\u1ee9c nguy\u00ean l\u00fd, quy tr\u00ecnh g\u1ed3m b\u1ed1n nh\u1ecbp l\u1eb7p \u0111i l\u1eb7p l\u1ea1i d\u00f9 b\u1ea1n d\u00f9ng phi\u00ean b\u1ea3n ph\u1ea7n m\u1ec1m n\u00e0o. N\u1eafm b\u1ed1n nh\u1ecbp n\u00e0y r\u1ed3i th\u00ec c\u00e1c n\u00fat b\u1ea5m c\u1ee5 th\u1ec3 ch\u1ec9 l\u00e0 chi ti\u1ebft b\u1ec1 m\u1eb7t.<\/p>\n<p>\u2013 Chu\u1ea9n b\u1ecb b\u1ea3ng d\u1eef li\u1ec7u ngu\u1ed3n v\u1edbi h\u00e0ng \u0111\u1ea7u l\u00e0 ti\u00eau \u0111\u1ec1 c\u1ed9t, m\u1ed7i d\u00f2ng d\u01b0\u1edbi l\u00e0 m\u1ed9t ng\u01b0\u1eddi nh\u1eadn.<\/p>\n<p>\u2013 M\u1edf t\u00e0i li\u1ec7u ch\u00ednh r\u1ed3i k\u1ebft n\u1ed1i n\u00f3 t\u1edbi b\u1ea3ng d\u1eef li\u1ec7u v\u1eeba chu\u1ea9n b\u1ecb.<\/p>\n<p>\u2013 Ch\u00e8n c\u00e1c tr\u01b0\u1eddng tr\u1ed9n v\u00e0o \u0111\u00fang v\u1ecb tr\u00ed c\u1ea7n thay \u0111\u1ed5i trong t\u00e0i li\u1ec7u.<\/p>\n<p>\u2013 Xem tr\u01b0\u1edbc v\u00e0i b\u1ea3n \u0111\u1ea7u, ki\u1ec3m tra r\u1ed3i m\u1edbi ho\u00e0n t\u1ea5t \u0111\u1ec3 in ho\u1eb7c xu\u1ea5t file.<\/p>\n<p>B\u1ed1n nh\u1ecbp tr\u00ean n\u00ean l\u00e0m tu\u1ea7n t\u1ef1, v\u00e0 b\u01b0\u1edbc xem tr\u01b0\u1edbc l\u00e0 ch\u1ed1t ch\u1eb7n quan tr\u1ecdng nh\u1ea5t v\u00ec n\u00f3 l\u1ed9 ra ngay c\u00e1c tr\u01b0\u1eddng b\u1ecb l\u1ec7ch. K\u1ef9 n\u0103ng thao t\u00e1c g\u1ecdn g\u00e0ng lo\u1ea1i t\u00e0i li\u1ec7u h\u00e0ng lo\u1ea1t ki\u1ec3u n\u00e0y l\u00e0 m\u1ed9t trong nh\u1eefng y\u00eau c\u1ea7u th\u01b0\u1eddng th\u1ea5y \u1edf nh\u00f3m <a href=\"https:\/\/www.careerlink.vn\/viec-lam\/thu-ky-hanh-chanh\/6\" style=\"color:#1565c0;font-weight:600;text-decoration:underline\">vi\u1ec7c l\u00e0m th\u01b0 k\u00fd &#8211; h\u00e0nh ch\u00e1nh<\/a> tr\u00ean CareerLink, n\u01a1i th\u01b0 k\u00fd h\u00e0nh ch\u00ednh (Administrative Secretary) th\u01b0\u1eddng xuy\u00ean ph\u1ea3i x\u1eed l\u00fd v\u0103n b\u1ea3n theo l\u00f4.<\/p>\n<h2>4. V\u00ec sao ph\u1ea7n l\u1edbn l\u1ed7i \u0111\u1ebfn t\u1eeb file d\u1eef li\u1ec7u ngu\u1ed3n<\/h2>\n<p>Nhi\u1ec1u h\u01b0\u1edbng d\u1eabn mail merge ch\u1ec9 ch\u1ee5p l\u1ea1i c\u00e1c b\u01b0\u1edbc b\u1ea5m n\u00fat, n\u00ean khi k\u1ebft qu\u1ea3 ra sai ng\u01b0\u1eddi d\u00f9ng loay hoay \u1edf ph\u1ea7n t\u00e0i li\u1ec7u ch\u00ednh trong khi g\u1ed1c r\u1ec5 n\u1eb1m \u1edf b\u1ea3ng d\u1eef li\u1ec7u. \u0110\u1ecbnh d\u1ea1ng ng\u00e0y, s\u1ed1 v\u00e0 ti\u1ec1n t\u1ec7 l\u00e0 th\u1ee7 ph\u1ea1m quen thu\u1ed9c: m\u1ed9t \u00f4 ng\u00e0y ghi ki\u1ec3u n\u00e0y trong b\u1ea3ng t\u00ednh c\u00f3 th\u1ec3 b\u1ecb tr\u1ed9n ra m\u1ed9t ki\u1ec3u kh\u00e1c trong v\u0103n b\u1ea3n. \u00d4 tr\u1ed1ng, kho\u1ea3ng tr\u1eafng th\u1eeba v\u00e0 ti\u00eau \u0111\u1ec1 c\u1ed9t \u0111\u1eb7t tr\u00f9ng t\u00ean c\u0169ng khi\u1ebfn tr\u01b0\u1eddng tr\u1ed9n nh\u1ea3y sai ch\u1ed7.<\/p>\n<div style=\"background:#fff3e0;border-left:4px solid #ff9800;padding:15px 20px;margin:20px 0;border-radius:4px\">\n<p><strong>Ba l\u1ed7i d\u1eef li\u1ec7u ngu\u1ed3n hay g\u1eb7p nh\u1ea5t<\/strong><\/p>\n<p>\u2013 C\u1ed9t s\u1ed1 ho\u1eb7c ng\u00e0y hi\u1ec3n th\u1ecb sai \u0111\u1ecbnh d\u1ea1ng sau khi tr\u1ed9n so v\u1edbi trong b\u1ea3ng g\u1ed1c.<\/p>\n<p>\u2013 C\u00f3 d\u00f2ng b\u1ecb b\u1ecf tr\u1ed1ng ho\u1eb7c thi\u1ebfu \u00f4 khi\u1ebfn b\u1ea3n in ra h\u1ee5t th\u00f4ng tin.<\/p>\n<p>\u2013 Ti\u00eau \u0111\u1ec1 c\u1ed9t \u0111\u1eb7t tr\u00f9ng t\u00ean ho\u1eb7c ch\u1ee9a k\u00fd t\u1ef1 l\u1ea1 l\u00e0m ph\u1ea7n m\u1ec1m nh\u1eadn nh\u1ea7m tr\u01b0\u1eddng.<\/p>\n<\/div>\n<p>Ba l\u1ed7i tr\u00ean \u0111\u1ec1u x\u1eed l\u00fd \u0111\u01b0\u1ee3c \u1edf kh\u00e2u chu\u1ea9n b\u1ecb b\u1ea3ng, n\u00ean d\u00e0nh th\u00eam \u00edt ph\u00fat l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u tr\u01b0\u1edbc khi tr\u1ed9n s\u1ebd ti\u1ebft ki\u1ec7m r\u1ea5t nhi\u1ec1u th\u1eddi gian s\u1eeda v\u1ec1 sau. C\u00e1ch ph\u00f2ng t\u1ed1t l\u00e0 ki\u1ec3m tra b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 ki\u1ec3m m\u1ed9t bi\u1ec3u m\u1eabu \u0111\u1ed9c l\u1eadp tr\u01b0\u1edbc khi mang \u0111i tr\u1ed9n.<\/p>\n<p style=\"text-align:center\"><img decoding=\"async\" src=\"https:\/\/cl-wpml.careerlink.vn\/cam-nang-viec-lam\/wp-content\/uploads\/2026\/09\/27070727\/a-mail-merge-tron-thu-hang-loat-2.png\" alt=\"mail merge tr\u1ed9n th\u01b0 h\u00e0ng lo\u1ea1t\" style=\"max-width:100%;height:auto;\" \/><\/p>\n<h2>5. Mail merge kh\u00f4ng ch\u1ec9 \u0111\u1ec3 g\u1eedi email<\/h2>\n<p>M\u1ed9t hi\u1ec3u nh\u1ea7m ph\u1ed5 bi\u1ebfn l\u00e0 k\u1ef9 thu\u1eadt n\u00e0y ch\u1ec9 d\u00f9ng cho th\u01b0 \u0111i\u1ec7n t\u1eed. Th\u1ef1c t\u1ebf c\u00f9ng m\u1ed9t c\u01a1 ch\u1ebf tr\u1ed9n c\u00f3 th\u1ec3 xu\u1ea5t ra r\u1ea5t nhi\u1ec1u lo\u1ea1i \u1ea5n ph\u1ea9m v\u1eadt l\u00fd. B\u1ea1n c\u00f3 th\u1ec3 in nh\u00e3n d\u00e1n \u0111\u1ecba ch\u1ec9 h\u00e0ng lo\u1ea1t, t\u1ea1o phong b\u00ec theo danh s\u00e1ch, in gi\u1ea5y khen ho\u1eb7c th\u1ebb t\u00ean cho s\u1ef1 ki\u1ec7n, th\u1eadm ch\u00ed d\u1ef1ng phi\u1ebfu thu chi theo m\u1eabu.<\/p>\n<blockquote>\n<p><em>Tr\u1ed9n th\u01b0 kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t t\u00ednh n\u0103ng g\u1eedi email, m\u00e0 l\u00e0 m\u1ed9t c\u00e1ch nh\u00e2n b\u1ea3n t\u00e0i li\u1ec7u c\u00f3 ki\u1ec3m so\u00e1t; email ch\u1ec9 l\u00e0 m\u1ed9t trong nhi\u1ec1u \u0111\u1ea7u ra c\u1ee7a n\u00f3.<\/em><\/p>\n<\/blockquote>\n<p>Nh\u00ecn theo g\u00f3c \u0111\u00f3, mail merge g\u1ea7n v\u1edbi t\u01b0 duy qu\u1ea3n l\u00fd d\u1eef li\u1ec7u h\u01a1n l\u00e0 m\u1ed9t m\u1eb9o v\u1eb7t c\u1ee7a ph\u1ea7n m\u1ec1m so\u1ea1n th\u1ea3o. Khi t\u00e1ch ph\u1ea7n c\u1ed1 \u0111\u1ecbnh kh\u1ecfi ph\u1ea7n thay \u0111\u1ed5i v\u00e0 gi\u1eef d\u1eef li\u1ec7u \u1edf m\u1ed9t b\u1ea3ng s\u1ea1ch, b\u1ea1n c\u00f3 th\u1ec3 t\u00e1i d\u00f9ng c\u00f9ng b\u1ed9 d\u1eef li\u1ec7u cho nhi\u1ec1u lo\u1ea1i \u0111\u1ea7u ra m\u00e0 kh\u00f4ng ph\u1ea3i nh\u1eadp l\u1ea1i.<\/p>\n<div style=\"background:#e8f5e9;border-left:4px solid #4caf50;padding:15px 20px;margin:20px 0;border-radius:4px\">\n<p><strong>Hai th\u00f3i quen gi\u00fap tr\u1ed9n th\u01b0 g\u1ecdn v\u00e0 an to\u00e0n<\/strong><\/p>\n<p>\u2013 H\u00e3y gi\u1eef m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u g\u1ed1c s\u1ea1ch v\u00e0 t\u00e1ch ri\u00eang kh\u1ecfi c\u00e1c b\u1ea3n \u0111\u00e3 tr\u1ed9n \u0111\u1ec3 d\u1ec5 t\u00e1i d\u00f9ng.<\/p>\n<p>\u2013 H\u00e3y tr\u1ed9n th\u1eed m\u1ed9t l\u00f4 nh\u1ecf r\u1ed3i ki\u1ec3m m\u1eaft tr\u01b0\u1edbc khi ch\u1ea1y to\u00e0n b\u1ed9 danh s\u00e1ch l\u1edbn.<\/p>\n<\/div>\n<p>Hai th\u00f3i quen n\u00e0y gi\u00fap b\u1ea1n ph\u00e1t hi\u1ec7n sai s\u00f3t khi h\u1eadu qu\u1ea3 c\u00f2n nh\u1ecf, thay v\u00ec khi \u0111\u00e3 in ra h\u00e0ng tr\u0103m b\u1ea3n.<\/p>\n<h2>6. C\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p<\/h2>\n<p><strong><em>1. Mail merge c\u00f3 c\u1ea7n bi\u1ebft l\u1eadp tr\u00ecnh kh\u00f4ng?<\/em><\/strong><\/p>\n<p>Kh\u00f4ng. To\u00e0n b\u1ed9 thao t\u00e1c n\u1eb1m trong giao di\u1ec7n ph\u1ea7n m\u1ec1m so\u1ea1n th\u1ea3o, b\u1ea1n ch\u1ec9 ch\u1ecdn ngu\u1ed3n d\u1eef li\u1ec7u v\u00e0 ch\u00e8n tr\u01b0\u1eddng qua c\u00e1c n\u00fat b\u1ea5m. Ng\u01b0\u1eddi m\u1edbi l\u00e0m quen kho\u1ea3ng m\u1ed9t bu\u1ed5i l\u00e0 tr\u1ed9n \u0111\u01b0\u1ee3c m\u1ed9t danh s\u00e1ch c\u01a1 b\u1ea3n.<\/p>\n<p><strong><em>2. Ngu\u1ed3n d\u1eef li\u1ec7u b\u1eaft bu\u1ed9c ph\u1ea3i l\u00e0 Excel \u00e0?<\/em><\/strong><\/p>\n<p>Kh\u00f4ng b\u1eaft bu\u1ed9c. B\u1ea3ng t\u00ednh l\u00e0 l\u1ef1a ch\u1ecdn ti\u1ec7n v\u00e0 ph\u1ed5 bi\u1ebfn, nh\u01b0ng danh b\u1ea1 li\u00ean h\u1ec7 hay m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u d\u1ea1ng kh\u00e1c v\u1eabn d\u00f9ng \u0111\u01b0\u1ee3c, mi\u1ec5n l\u00e0 d\u1eef li\u1ec7u c\u00f3 c\u1ea5u tr\u00fac c\u1ed9t r\u00f5 r\u00e0ng v\u00e0 ti\u00eau \u0111\u1ec1 s\u1ea1ch.<\/p>\n<p><strong><em>3. V\u00ec sao b\u1ea3n tr\u1ed9n ra b\u1ecb sai \u0111\u1ecbnh d\u1ea1ng ng\u00e0y v\u00e0 s\u1ed1?<\/em><\/strong><\/p>\n<p>Nguy\u00ean nh\u00e2n th\u01b0\u1eddng n\u1eb1m \u1edf c\u00e1ch ph\u1ea7n m\u1ec1m \u0111\u1ecdc \u00f4 d\u1eef li\u1ec7u ch\u1ee9 kh\u00f4ng ph\u1ea3i \u1edf t\u00e0i li\u1ec7u m\u1eabu. C\u00e1ch x\u1eed l\u00fd l\u00e0 chu\u1ea9n h\u00f3a \u0111\u1ecbnh d\u1ea1ng ngay trong b\u1ea3ng ngu\u1ed3n, ho\u1eb7c \u0111i\u1ec1u ch\u1ec9nh c\u00e1ch tr\u01b0\u1eddng tr\u1ed9n hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb.<\/p>\n<p>N\u1eafm \u0111\u01b0\u1ee3c <strong>mail merge<\/strong> gi\u00fap b\u1ea1n bi\u1ebfn m\u1ed9t vi\u1ec7c t\u1ed1n h\u00e0ng gi\u1edd \u0111\u1ed3ng h\u1ed3 th\u00e0nh v\u00e0i ph\u00fat thi\u1ebft l\u1eadp, \u0111\u1ed3ng th\u1eddi gi\u1ea3m h\u1eb3n r\u1ee7i ro g\u00f5 nh\u1ea7m khi l\u00e0m s\u1ed1 l\u01b0\u1ee3ng l\u1edbn. H\u00e3y nh\u1edb ba th\u00e0nh ph\u1ea7n c\u1ed1t l\u00f5i, d\u00e0nh th\u1eddi gian l\u00e0m s\u1ea1ch b\u1ea3ng d\u1eef li\u1ec7u ngu\u1ed3n v\u00e0 lu\u00f4n xem tr\u01b0\u1edbc m\u1ed9t l\u00f4 nh\u1ecf tr\u01b0\u1edbc khi ch\u1ea1y to\u00e0n b\u1ed9. B\u1eaft \u0111\u1ea7u t\u1eeb m\u1ed9t danh s\u00e1ch \u0111\u01a1n gi\u1ea3n trong c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n \u0111\u1ec3 l\u00e0m quen v\u1edbi nh\u1ecbp thao t\u00e1c.<\/p>\n<p><em>N\u1ed9i dung trong b\u00e0i mang t\u00ednh tham kh\u1ea3o, t\u1ed5ng h\u1ee3p t\u1eeb nguy\u00ean l\u00fd chung c\u1ee7a t\u00ednh n\u0103ng tr\u1ed9n th\u01b0; giao di\u1ec7n v\u00e0 thao t\u00e1c c\u1ee5 th\u1ec3 c\u00f3 th\u1ec3 kh\u00e1c nhau t\u00f9y phi\u00ean b\u1ea3n ph\u1ea7n m\u1ec1m b\u1ea1n \u0111ang d\u00f9ng.<\/em><\/p>\n<p><em>Minh An<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>B\u1ea1n c\u1ea7n g\u1eedi h\u00e0ng tr\u0103m th\u01b0 m\u1eddi, phi\u1ebfu l\u01b0\u01a1ng hay gi\u1ea5y ch\u1ee9ng nh\u1eadn, m\u1ed7i b\u1ea3n ch\u1ec9 kh\u00e1c nhau v\u00e0i d\u00f2ng t\u00ean v\u00e0 s\u1ed1 li\u1ec7u, c\u00f2n &#8230;<\/p>\n","protected":false},"author":58,"featured_media":29699,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[],"class_list":["post-29719","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tu-van-nghe-nghiep"],"careerlink":{"blog":"cnvl","focus_keyword":"Mail merge l\u00e0 g\u00ec","primary_category":17,"old_slugs":[],"author":{"id":58,"name":"CareerLink","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/8701f568badfca4d5276fee58a666445be82904ca0123886d429464825b459be?s=96&d=mm&r=g"}},"_links":{"self":[{"href":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/wp-json\/wp\/v2\/posts\/29719","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/wp-json\/wp\/v2\/users\/58"}],"replies":[{"embeddable":true,"href":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/wp-json\/wp\/v2\/comments?post=29719"}],"version-history":[{"count":1,"href":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/wp-json\/wp\/v2\/posts\/29719\/revisions"}],"predecessor-version":[{"id":29720,"href":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/wp-json\/wp\/v2\/posts\/29719\/revisions\/29720"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/wp-json\/wp\/v2\/media\/29699"}],"wp:attachment":[{"href":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/wp-json\/wp\/v2\/media?parent=29719"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/wp-json\/wp\/v2\/categories?post=29719"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/wp-json\/wp\/v2\/tags?post=29719"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}