{"id":30358,"date":"2026-08-23T16:25:45","date_gmt":"2026-08-23T09:25:45","guid":{"rendered":"https:\/\/tct.vn\/blog\/ca-nhan-hoa-thu-hang-loat-trong-word-bang-quy-tac-ifthenelse\/"},"modified":"2026-08-23T16:25:45","modified_gmt":"2026-08-23T09:25:45","slug":"ca-nhan-hoa-thu-hang-loat-trong-word-bang-quy-tac-ifthenelse","status":"publish","type":"post","link":"https:\/\/tct.vn\/blog\/ca-nhan-hoa-thu-hang-loat-trong-word-bang-quy-tac-ifthenelse\/","title":{"rendered":"C\u00e1 nh\u00e2n h\u00f3a th\u01b0 h\u00e0ng lo\u1ea1t trong Word b\u1eb1ng quy t\u1eafc If\u2026Then\u2026Else"},"content":{"rendered":"<p>Khi n\u00e0o th\u1ee7 thu\u1eadt n\u00e0y h\u1eefu \u00edch? Gi\u1ea3 s\u1eed b\u1ea3ng Excel ch\u1ee9a danh s\u00e1ch kh\u00e1ch h\u00e0ng c\u00f9ng c\u00e1c c\u1ed9t H\u1ecd_t\u00ean, Gi\u1edbi_t\u00ednh, H\u1ea1ng_th\u00e0nh_vi\u00ean v\u00e0 Th\u00e0nh_ph\u1ed1. Thay v\u00ec g\u1eedi m\u1ed9t n\u1ed9i dung gi\u1ed1ng nhau cho t\u1ea5t c\u1ea3 m\u1ecdi ng\u01b0\u1eddi, b\u1ea1n c\u00f3 th\u1ec3 y\u00eau c\u1ea7u Word t\u1ef1 t\u1ea1o l\u1eddi ch\u00e0o \u201cK\u00ednh g\u1eedi \u00d4ng\u201d... [N\u1ed9i dung \u0111\u1ea7y \u0111\u1ee7 v\u00e0 h\u00ecnh \u1ea3nh \u0111\u00e3 \u0111\u01b0\u1ee3c \u1ea9n \u0111\u1ed1i v\u1edbi c\u00f4ng c\u1ee5 t\u1ef1 \u0111\u1ed9ng]<\/p>","protected":false},"excerpt":{"rendered":"<p>Kh\u00f4ng ch\u1ec9 thay t\u00ean ng\u01b0\u1eddi nh\u1eadn, Word c\u00f2n c\u00f3 th\u1ec3 t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i l\u1eddi ch\u00e0o, \u01b0u \u0111\u00e3i ho\u1eb7c h\u01b0\u1edbng d\u1eabn d\u1ef1a tr\u00ean d\u1eef li\u1ec7u c\u1ee7a t\u1eebng ng\u01b0\u1eddi. Th\u1ee7 thu\u1eadt d\u00f9ng quy t\u1eafc If\u2026Then\u2026Else trong Mail Merge gi\u00fap b\u1ea1n t\u1ea1o h\u00e0ng tr\u0103m t\u00e0i li\u1ec7u c\u00e1 nh\u00e2n h\u00f3a m\u00e0 kh\u00f4ng c\u1ea7n... [N\u1ed9i dung \u0111\u1ea7y \u0111\u1ee7 v\u00e0 h\u00ecnh \u1ea3nh \u0111\u00e3 \u0111\u01b0\u1ee3c \u1ea9n \u0111\u1ed1i v\u1edbi c\u00f4ng c\u1ee5 t\u1ef1 \u0111\u1ed9ng]<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[506,508],"tags":[],"class_list":["post-30358","post","type-post","status-publish","format-standard","hentry","category-thu-thuat","category-office"],"_links":{"self":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/30358","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/comments?post=30358"}],"version-history":[{"count":0,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/30358\/revisions"}],"wp:attachment":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media?parent=30358"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/categories?post=30358"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/tags?post=30358"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}