Qhov wikiHow qhia koj yuav siv "Mail Merge" feature hauv Microsoft Word. Kev xa ntawv sib koom ua ke tso cai rau koj siv daim ntawv xov xwm tiv toj kom muab qhov chaw nyob sib txawv, lub npe, lossis cov ntaub ntawv rau txhua daim ntawv theej ntawm daim ntawv. Cov yam ntxwv no muaj txiaj ntsig zoo thaum koj xav tau kho cov ntawv xov xwm lossis ntawv pov thawj vim tias koj tsis tas yuav sau tus kheej lub npe lossis chaw nyob sib txawv nyob rau saum toj ntawm txhua daim ntawv.
Kauj ruam
Ntu 1 ntawm 3: Tsim Daim Ntawv Tiv Thaiv
Kauj Ruam 1. Qhib Microsoft Excel
Microsoft Excel daim ntawv thov lub cim zoo ib yam "X" dawb ntawm keeb kwm yav dhau dawb. Tom qab ntawd, nplooj ntawv "Tshiab" yuav tshwm.
Yog tias koj twb muaj daim ntawv tiv toj hauv Excel, hla mus rau theem ntawm kev thauj khoom lossis ntshuam Excel cov neeg
Kauj Ruam 2. Nyem Phau ntawv ua haujlwm dawb paug
Nws yog nyob rau sab saum toj-sab laug ntawm nplooj ntawv "Tshiab". Tom qab ntawd, daim ntawv Excel tshiab yuav qhib.
Kauj Ruam 3. Ntxiv qhov hu xov tooj
Pib los ntawm lub thawv " A1"Ntawm sab xis, sau lub taub hau lossis lub npe raws li hauv qab no:
- "FirstName" - Tus hu lub npe yuav tsum tau nkag mus rau hauv daim teb no (lub npov " A1 ”).
- "Xeem Npe" - Lub xeem lub npe ntawm kev sib cuag yuav tsum tau nkag mus rau hauv daim teb no (lub npov " B1 ”).
- "Tel" - Tus lej xov tooj tiv toj yuav raug ntxiv rau hauv daim teb no (lub npov " C1 ”).
- "StreetAddress" - Chaw nyob yuav tsum tau nkag rau hauv daim teb no (lub npov " D1 ”).
- “Lub Nroog” - Tus hu lub nroog/chaw nyob yuav tsum tau ntxiv rau qhov kev sib cuag no (lub npov “ E1 ”).
- "Xeev" - Lub xeev keeb kwm ntawm kev sib cuag yuav raug ntxiv rau hauv kab lus no (lub npov " F1 ”).
- "ZIP" - Tus lej xa ntawv qhov chaw sib cuag yuav tsum tau ntxiv rau kab ntawv no (kab " G1 ”).
- "Email" - Tus email chaw nyob ntawm kev sib cuag yuav raug sau rau hauv daim teb no (lub npov " H1 ”).
Kauj Ruam 4. Nkag mus rau cov ntaub ntawv tiv toj
Pib ntawm kab A ntawm lub npov 2, nkag mus rau cov ntaub ntawv tiv toj rau txhua tus neeg koj xav ntxiv rau cov cuab yeej xa ntawv sib koom ua ke.
Ua kom ntseeg tau tias cov ntaub ntawv nkag mus raug yog ua ntej koj mus rau kauj ruam tom ntej
Kauj Ruam 5. Txuag daim ntawv
Txuag nws:
- Windows - Nyem " Cov ntaub ntawv ", xaiv" Txuag As ", ob npaug nias" Lub PC no ", Xaiv qhov chaw khaws cov ntaub ntawv nyob rau sab laug ntawm lub qhov rais, ntaus lub npe cov ntaub ntawv hauv daim teb" Cov npe ntaub ntawv ", thiab nyem" Txuag ”.
- Mac - Nyem " Cov ntaub ntawv ", xaiv" Txuag Raws li… ", Sau lub npe cov ntaub ntawv hauv" Txuag Raws Li "teb, xaiv qhov chaw cia khoom los ntawm txhaj rau lub pob" Qhov twg "thiab xaiv daim nplaub tshev, tom qab ntawd nyem" Txuag ”.
- Nco ntsoov qhov chaw khaws cov ntawv xaiv. Tom qab ntawd koj yuav tsum nrhiav cov ntawv hu rau Excel ntawm qhov chaw ntawd.
Kauj Ruam 6. Kaw qhov Excel qhov rai
Nyem lub pob " X"Nyob rau sab xis-sab xis ntawm lub qhov rais Excel (Windows) lossis lub voj voog liab nyob rau sab saud sab laug ntawm lub qhov rais (Mac). Tam sim no koj tuaj yeem tsim lossis siv cov ntawv sib koom ua ke hauv Microsoft Word.
Ntu 2 ntawm 3: Ntshuam Cov Neeg rau Lo Lus
Kauj Ruam 1. Qhib Microsoft Word
Microsoft Word daim ntawv thov lub cim zoo li dawb "W" ntawm qhov tsaus ntuj xiav. Raws li hauv Microsoft Excel, nplooj ntawv "Tshiab" yuav tshwm tom qab qhib qhov program.
Yog tias koj twb muaj Microsoft Word cov ntaub ntawv uas koj xav ntxiv cov neeg sib tham los ntawm Excel rau, koj yuav tsum tau nyem ob npaug rau daim ntawv kom qhib nws. Hla cov kauj ruam tom ntej yog tias koj twb muaj cov ntawv tshwj xeeb
Kauj Ruam 2. Nyem rau Blank document
Nws yog lub thawv dawb nyob rau ntawm kaum-sab laug ntawm nplooj ntawv. Tom qab ntawd, daim ntawv Microsoft Word dawb paug yuav tshwm.
Kauj Ruam 3. Nyem rau Mailings tab
Cov ntawv no yog nyob rau sab saum toj ntawm Microsoft Word qhov rai. Tom qab ntawd, lub cuab yeej yuav tshwm nyob rau hauv qab kab ntawm tabs.
Kauj Ruam 4. Nyem Xaiv Cov Neeg Tau Txais
Nws nyob hauv "Pib Xa Ntawv Sib Koom" ntu ntawm lub cuab yeej " Kev xa ntawv " Tom qab ntawd, cov ntawv qhia zaub mov nco-down yuav tshwm.
Kauj Ruam 5. Nyem Siv Daim Ntawv Teev Npe Muaj…
Qhov kev xaiv no yog nyob hauv cov ntawv qhia zaub mov nco-down. Tom qab ntawd, lub qhov rai tshiab yuav qhib.
- Yog tias koj xav siv kev sib cuag los ntawm Outlook, koj tuaj yeem xaiv qhov kev xaiv " Xaiv los ntawm Outlook Contacts "Los ntawm cov ntawv qhia zaub mov nco-down.
- Koj tseem tuaj yeem ntaus cov npe ib ntus ntawm cov ntaub ntawv tiv toj hauv Lo Lus los ntawm kev xaiv " Ntaus Cov Npe Tshiab " Cov yam ntxwv no muaj txiaj ntsig thaum koj tsuas xav tsim qee cov ntaub ntawv tiv toj.
Kauj Ruam 6. Xaiv Microsoft Excel daim ntawv sib cuag
Ntawm sab laug ntawm lub qhov rais, nyem rau daim nplaub tshev uas muaj daim ntawv hu rau Excel. Tom qab ntawv, nyem rau ntawm daim ntawv Excel kom xaiv nws.
Kauj Ruam 7. Nyem Qhib
Nws nyob hauv lub kaum sab xis-sab xis ntawm lub qhov rais.
Kauj Ruam 8. Paub meej tias koj xaiv
Nyem rau ntawm Excel daim ntawv npe nyob rau hauv lub qhov rai pop-up, tom qab ntawv nyem rau " OK "Uas yog nyob hauv qab qhov rais. Koj daim ntawv Excel yuav raug xaiv los ua qhov chaw sib cuag.
Xyuas kom tseeb tias "Thawj kab ntawm cov ntaub ntawv muaj kab ntawv kab ntawv" hauv lub thawv hauv qab ntawm lub qhov rais raug tshuaj xyuas
Ntu 3 ntawm 3: Siv Kev Xa Ntawv Ua Haujlwm Zoo
Kauj Ruam 1. Mus rau qhov chaw lossis taw tes uas koj xav tau ntxig cov ntaub ntawv tiv toj
Nrhiav qhov chaw uas koj xav ntxiv cov ntaub ntawv tiv toj (piv txwv li lub taub hau ntawm daim ntawv) thiab nyem rau nws kom tso tus cursor.
Kauj Ruam 2. Nyem Insert Merge Field
Qhov kev xaiv no nyob hauv ntu "Sau & Ntxig" hauv "tab". Kev xa ntawv " Tom qab ntawd, cov ntawv qhia zaub mov nco-down yuav tshwm.
Koj yuav tsum tau nyem rau ntawm lub tab " Kev xa ntawv "Ib zaug ntxiv ua ntej ua raws cov kauj ruam no.
Kauj Ruam 3. Xaiv hom ntaub ntawv
Ntawm cov ntawv qhia zaub mov nco, nyem lub npe ntawm ib qho ntawm cov npe lossis cov ncauj lus ntawm cov ntaub ntawv los ntawm daim ntawv Excel txhawm rau ntxig nws rau hauv Lo Lus ntawv.
Piv txwv li, yog tias koj xav ntxiv tus neeg hu thawj lub npe tag, nyem " Lub Npe "Hauv cov ntawv qhia zaub mov nco-down.
Kauj Ruam 4. Ntxiv lwm cov ntaub ntawv yog tias tsim nyog
Cov ntaub ntawv no suav nrog chaw nyob, lub xeem, tus lej xov tooj, thiab lwm yam.
Kauj Ruam 5. Nyem Finish & Merge
Nws yog nyob rau sab xis ntawm lub tab toolbar. Kev xa ntawv Tom qab ntawd, cov ntawv qhia zaub mov nco-down yuav tshwm.
Kauj Ruam 6. Txiav txim siab txog kev xaiv ua ke
Nyem ib qho ntawm cov kev xaiv hauv qab no:
- “ Kho Cov Ntaub Ntawv Tus Kheej " - Qhov kev xaiv no yuav qhib txhua tus neeg txais cov ntaub ntawv yog li koj tuaj yeem rov kho daim ntawv.
- “ Luam Cov Ntaub Ntawv… " - Qhov kev xaiv no tso cai rau koj luam daim ntawv theej ntawm txhua tus neeg uas muaj npe nyob hauv daim ntawv sib cuag.
- “ Xa email lus… "-Qhov kev xaiv no tso cai rau koj xa cov ntawv ua e-mail. Tus email chaw nyob yuav raug xaiv raws li email chaw nyob.
Kauj Ruam 7. Ua raws li cov lus qhia pom ntawm qhov screen
Koj tuaj yeem muaj cov ntawv ntxiv los tshuaj xyuas, nyob ntawm cov kev xaiv uas tau xaiv (piv txwv li yog tias koj xaiv " E-mail ", Koj yuav tsum sau lub npe thiab nyem" OK "). Tom qab ntawd, txheej txheem xa ntawv xa tuaj tiav.