Yuav Xa Ntawv Li Cas Hauv Microsoft Word (nrog Duab)

Cov txheej txheem:

Yuav Xa Ntawv Li Cas Hauv Microsoft Word (nrog Duab)
Yuav Xa Ntawv Li Cas Hauv Microsoft Word (nrog Duab)
Anonim

Qhov wikiHow qhia koj yuav siv "Mail Merge" feature hauv Microsoft Word. Kev Sib Txuas Xa Ntawv tso cai rau koj siv daim ntawv nthuav qhia cov ntaub ntawv tiv toj los muab qhov chaw nyob sib txawv, lub npe, lossis lwm yam ntaub ntawv rau txhua daim ntawv theej ntawm daim ntawv. Qhov no muaj txiaj ntsig thaum ua tus kheej cov ntawv xov xwm lossis nqe lus, vim koj tsis tas yuav sau los ntawm txhua tus neeg lub npe lossis chaw nyob nyob rau saum toj ntawm txhua daim ntawv.

Cov kauj ruam

Ntu 1 ntawm 3: Tsim Daim Ntawv Tiv Thaiv

Mail Merge hauv Microsoft Word Kauj Ruam 1
Mail Merge hauv Microsoft Word Kauj Ruam 1

Kauj Ruam 1. Qhib Microsoft Excel

Microsoft Excel lub app icon zoo ib yam li "X" dawb ntawm qhov tsaus ntuj-ntsuab keeb kwm yav dhau. Nplooj ntawv Excel "Tshiab" yuav qhib.

Yog tias koj twb muaj daim ntawv tiv toj hauv Excel, hla ua ntej rau ntshuam Excel cov neeg sib txuas

Mail Merge hauv Microsoft Word Step 2
Mail Merge hauv Microsoft Word Step 2

Kauj Ruam 2. Nyem Phau ntawv ua haujlwm dawb paug

Nws nyob rau sab saud sab laug ntawm nplooj ntawv "Tshiab". Qhov no yuav qhib ib daim ntawv tshiab, Excel dawb paug.

Mail Merge hauv Microsoft Word Kauj Ruam 3
Mail Merge hauv Microsoft Word Kauj Ruam 3

Kauj Ruam 3. Ntxiv koj cov npe hu

Pib hauv cell A1 thiab txav mus los ntawm qhov ntawd, nkag mus rau hauv cov hauv qab no:

  • FirstName - Koj cov npe 'cov npe yuav mus hauv kab ntawv no (ntawm tes A1).
  • LastName - Koj cov neeg lub npe kawg yuav mus hauv kab ntawv no (ntawm tes B1).
  • Tel - Koj tus xov tooj tus xov tooj yuav nyob hauv kab lus no (ntawm tes C1).
  • StreetAddress - Koj qhov chaw nyob ntawm txoj kev yuav nyob hauv kab ntawv no (ntawm tes D1).
  • Lub Nroog - Koj cov neeg nyob hauv lub nroog nyob yuav nyob hauv kab lus no (ntawm tes E1).
  • Xeev - Koj cov neeg nyob hauv lub xeev yuav nyob hauv kab ntawv no (cell F1).
  • ZIP - Koj cov neeg tiv toj tus lej ZIP yuav nyob hauv kab ntawv no (ntawm tes G1).
  • Email - Koj tus email chaw nyob yuav nyob hauv kab lus no (ntawm tes H1).
Mail Merge hauv Microsoft Word Kauj Ruam 4
Mail Merge hauv Microsoft Word Kauj Ruam 4

Kauj Ruam 4. Sau koj cov ntaub ntawv tiv toj

Pib hauv kab A, xov tooj 2, pib nkag mus rau cov ntaub ntawv tiv toj rau txhua tus neeg uas koj xav tsim kom muaj kev sib koom xa ntawv.

Nco ntsoov tias cov ntaub ntawv no muaj tseeb ua ntej yuav mus

Mail Merge hauv Microsoft Word Step 5
Mail Merge hauv Microsoft Word Step 5

Kauj Ruam 5. Txuag koj daim ntawv

Ua li ntawd:

  • Windows - Nyem Cov ntaub ntawv, nyem Txuag As, ob-nias Lub PC no, nyem qhov chaw khaws tseg nyob rau sab laug ntawm lub qhov rais, ntaus cov ntawv lub npe rau hauv "Cov ntaub ntawv npe" lub thawv ntawv, thiab nyem Txuag.
  • Mac - Nyem Cov ntaub ntawv, nyem Txuag Raws Li…, nkag mus rau cov ntaub ntawv lub npe hauv qhov "Txuag Raws Li" teb, xaiv qhov chaw khaws cia los ntawm txhaj rau lub pob "Qhov twg" thiab nyem rau daim nplaub tshev, thiab nyem Txuag.
  • Nco ntsoov tias koj tau xaiv tseg qhov chaw-koj yuav tsum nrhiav Excel daim ntawv nthuav tawm tom qab.
Mail Merge hauv Microsoft Word Step 6
Mail Merge hauv Microsoft Word Step 6

Kauj Ruam 6. Kaw Excel

Nyem rau X nyob rau sab saud sab xis ntawm Excel (Windows) lossis lub voj voog liab nyob rau ntawm kaum sab laug (Mac). Tam sim no koj tuaj yeem pib tsim cov ntawv sib koom ua ke hauv Microsoft Word.

Ntu 2 ntawm 3: Ntshuam Cov Neeg rau Lo Lus

Mail Merge hauv Microsoft Word Step 7
Mail Merge hauv Microsoft Word Step 7

Kauj Ruam 1. Qhib Microsoft Word

Lo lus app icon zoo li dawb "W" ntawm qhov tsaus ntuj-xiav keeb kwm yav dhau. Raws li nrog Excel, nplooj ntawv "Tshiab" yuav qhib.

Yog tias koj muaj Microsoft Word cov ntaub ntawv tam sim no uas koj xav tau import Excel cov neeg sib tham, koj yuav hloov ob zaug nws kom qhib nws thiab hla cov kauj ruam tom ntej

Mail Merge hauv Microsoft Word Step 8
Mail Merge hauv Microsoft Word Step 8

Kauj Ruam 2. Nyem rau Blank document

Nws yog lub thawv dawb nyob rau sab saud sab laug ntawm nplooj ntawv. Cov ntaub ntawv Microsoft Word dawb yuav qhib.

Mail Merge hauv Microsoft Word Kauj Ruam 9
Mail Merge hauv Microsoft Word Kauj Ruam 9

Kauj Ruam 3. Nyem rau Mailings tab

Cov ntawv no yog nyob rau sab saum toj ntawm Microsoft Word qhov rai. Lub cuab yeej yuav tshwm nyob hauv qab kab ntawm tabs ntawm no.

Mail Merge hauv Microsoft Word Step 10
Mail Merge hauv Microsoft Word Step 10

Kauj Ruam 4. Nyem Xaiv Cov Neeg Tau Txais

Nws yog nyob rau hauv "Start Mail Merge" ntu ntawm Kev xa ntawv toolbar. Ua li ntawd hais kom ua cov ntawv qhia zaub mov nco-down.

Mail Merge hauv Microsoft Word Kauj Ruam 11
Mail Merge hauv Microsoft Word Kauj Ruam 11

Kauj Ruam 5. Nyem Siv Daim Ntawv Teev Npe Muaj…

Koj yuav pom qhov kev xaiv no hauv cov ntawv qhia zaub mov nco-down. Ib lub qhov rai tshiab yuav qhib.

  • Yog tias koj ib txwm xav siv Outlook tiv tauj lwm tus, koj tuaj yeem xaiv qhov Xaiv los ntawm Outlook Contacts kev xaiv hauv cov ntawv qhia zaub mov nco-down.
  • Koj tseem tuaj yeem ntaus cov npe ib ntus ntawm cov ntaub ntawv tiv toj rau hauv Lo Lus los ntawm kev xaiv lub Ntaus Cov Npe Tshiab kev xaiv Qhov no muaj txiaj ntsig thaum koj tsuas yog xav tsim ib txhais tes ntawm cov neeg sib cuag cov ntaub ntawv.
Mail Merge hauv Microsoft Word Kauj Ruam 12
Mail Merge hauv Microsoft Word Kauj Ruam 12

Kauj Ruam 6. Xaiv koj daim ntawv hu rau Microsoft Excel

Ntawm sab laug ntawm lub qhov rais, nyem rau daim nplaub tshev uas koj tau khaws daim ntawv Excel, tom qab ntawv nyem rau Excel ntawv los xaiv nws.

Mail Merge hauv Microsoft Word Kauj Ruam 13
Mail Merge hauv Microsoft Word Kauj Ruam 13

Kauj Ruam 7. Nyem Qhib

Nws nyob hauv qab-txoj cai kaum ntawm lub qhov rais.

Mail Merge hauv Microsoft Word Kauj Ruam 14
Mail Merge hauv Microsoft Word Kauj Ruam 14

Kauj Ruam 8. Txheeb xyuas qhov kev txiav txim siab

Nyem rau ntawm Excel daim ntawv lub npe nyob rau hauv lub qhov rai pop-up, tom qab ntawd nyem OK hauv qab ntawm lub qhov rais. Koj daim ntawv Excel yuav raug xaiv raws li qhov chaw uas koj cov neeg sib cuag yuav thauj khoom.

Nco ntsoov tias "Thawj kab ntawm cov ntaub ntawv muaj kab ntawv kab ntawv" hauv lub thawv hauv qab ntawm lub qhov rai no tau tshuaj xyuas

Ntu 3 ntawm 3: Siv Kev Xa Ntawv Ua Ke

Mail Merge hauv Microsoft Word Kauj Ruam 15
Mail Merge hauv Microsoft Word Kauj Ruam 15

Kauj Ruam 1. Mus rau qhov chaw uas koj xav kom ntxig cov ntaub ntawv tiv toj

Nrhiav qhov chaw uas koj xav ntxig rau cov ntaub ntawv tiv toj (piv txwv li, sab saud ntawm daim ntawv) thiab nyem rau nws kom tso tus cursor nyob ntawd.

Mail Merge hauv Microsoft Word Kauj Ruam 16
Mail Merge hauv Microsoft Word Kauj Ruam 16

Kauj Ruam 2. Nyem Insert Merge Field

Nws yog ib qho kev xaiv hauv ntu "Sau & Ntxig Ua Ntej" ntawm Kev xa ntawv tab. Cov ntawv qhia zaub mov nco-down yuav tshwm.

  • Tej zaum koj yuav tau nyem qhov Kev xa ntawv tab dua ua ntej ua qhov no.
Mail Merge hauv Microsoft Word Kauj Ruam 17
Mail Merge hauv Microsoft Word Kauj Ruam 17

Kauj Ruam 3. Xaiv ib hom ntaub ntawv

Hauv cov ntawv qhia zaub mov nco-down, nyem lub npe ntawm ib lub hauv paus ntawm koj daim ntawv Excel kom ntxig rau nws.

  • Piv txwv li, koj yuav nyem Lub Npe hauv cov ntawv qhia zaub mov nco-down yog tias koj xav ntxig rau ib qho rau cov neeg hu ua thawj lub npe.
Mail Merge hauv Microsoft Word Kauj Ruam 18
Mail Merge hauv Microsoft Word Kauj Ruam 18

Kauj Ruam 4. Ntxiv lwm cov ntaub ntawv thaum tsim nyog

Qhov no yuav suav nrog cov neeg nyob sib tham, lub xeem, tus lej xov tooj, thiab ntxiv rau.

Mail Merge hauv Microsoft Word Kauj Ruam 19
Mail Merge hauv Microsoft Word Kauj Ruam 19

Kauj Ruam 5. Nyem Finish & Merge

Nws yog nyob rau sab xis-sab xis ntawm Kev xa ntawv tab toolbar. Qhov no qhia cov ntawv qhia zaub mov nco-down.

Mail Merge hauv Microsoft Word Step 20
Mail Merge hauv Microsoft Word Step 20

Kauj Ruam 6. Xaiv qhov kev xaiv ua ke

Nyem ib qho ntawm cov hauv qab no:

  • Kho Cov Ntaub Ntawv Tus Kheej - Qhib txhua tus neeg tau txais cov ntaub ntawv, tso cai rau koj tus kheej ntxiv cov ntaub ntawv.
  • Luam Cov Ntaub Ntawv… - Tso cai rau koj luam tawm daim ntawv theej ntawm koj daim ntawv rau txhua tus neeg tau teev tseg hauv koj daim ntawv tiv toj.
  • Xa email lus… - Tso cai rau koj xa cov ntaub ntawv raws li email. Cov neeg sib cuag email chaw nyob yuav raug xaiv ua qhov chaw nyob email.
Xa Ntawv Ua Ke hauv Microsoft Word Kauj Ruam 21
Xa Ntawv Ua Ke hauv Microsoft Word Kauj Ruam 21

Kauj Ruam 7. Ua raws li cov lus qhia ntawm lub vijtsam

Nyob ntawm koj qhov kev xaiv xaiv, koj yuav muaj daim ntawv ntxiv los tshuaj xyuas (piv txwv li, yog tias koj xaiv Email, koj yuav tsum nkag mus rau qhov kev kawm thiab tom qab ntawd nyem OK). Ua li ntawd yuav ua tiav cov txheej txheem xa ntawv sib koom ua ke.

Nrov los ntawm cov ncauj lus