Isici sokuhlanganiswa kwe-imeyili se-Microsoft sikuvumela ukuba uthumele idokhumenti efanayo nezinguquko ezincane kwinani elikhulu labamukeli. Igama elithi "ukuhlanganisa" livela eqinisweni lokuthi idokhumenti eyodwa (incwadi, isibonelo) ihlangene nombhalo wedatha wedatha , njengepredishithi.
Isici sokuhlanganiswa kweposi se-Word sisebenza ngokuzenzekelayo nedatha esuka ku-Excel. Ngesikhathi iZwi likuvumela ukuthi udale umthombo wayo wedatha, izinketho zokusebenzisa le datha zikhawulelwe. Ngaphezu kwalokho, uma usuvele unayo idatha yakho kuspredishithi, akusizi umqondo ukuphindaphinda yonke imininingwane emithonjeni yedatha ye-Word.
Ukulungiselela Idatha Yakho Ye-Imeyili Yokuhlangana
Ngokweqhinga, ungasebenzisa noma yiliphi ishidi lokusebenzela le-Excel emsebenzini wokuhlanganisa i-Word ngaphandle kokulungiselela okukhethekile. Kodwa-ke, kunconywa ukuthi uthathe isikhathi sokulungisa ishidi lakho lokusebenzela ukuze ukwandise inqubo yokuhlanganisa iposi .
Nazi iziqondiso ezimbalwa zokugcina lokho kuzosiza ukuthi inqubo yokuhlanganisa iposi ihambe kahle.
Hlela idatha yakho yespredishithi
Lapho engozini yokusho okucacile, idatha yakho kufanele ihlelwe ngokufanele emigqeni namakholomu. Cabanga ngomugqa ngamunye njengerekhodi elilodwa kanye nekholomu ngayinye njengensimu ozoyifaka kumadokhumenti wakho. (Bheka i- Excel idatha-entry tutorial uma udinga ukuvuselela.)
Dala i-Header Row
Dala umugqa wekhanda ushidi ohlose ukusebenzisa ngalo ukuhlanganiswa kwemeyili. Umugqa wezinhloko umugqa onamalebula okhomba idatha kumaseli angezansi. I-Excel ingahle ihlaziye ngezinye izikhathi mayelana nokwahlukanisa phakathi kwedatha namalebula, ngakho yenza lokhu kucaciswe ngokusebenzisa umbhalo obhaliwe, imingcele yeselula kanye ne-shading cell ukuthi ihlukile kumugqa wekhanda. Lokhu kuzoqinisekisa ukuthi i-Excel iyahlukanisa nayo yonke idatha yakho.
Kamuva uma uhlanganisa idatha nedokhumenti esemqoka, amalebula azovela njengamagama wezinkambu zokuhlanganisa, ngakho ngeke kube khona ukudideka ngokuthi iyiphi idatha oyifaka emadokhumenti wakho. Ngaphezu kwalokho, kuwumkhuba omuhle ukubeka amakholomu akho, njengoba kusiza ukuvimbela iphutha lomsebenzisi.
Beka Zonke Idatha KuShidi Lodwa
Idatha ohlose ukuyisebenzisa ukuhlanganiswa kwemeyili kumele ibe kwelinye ishidi. Uma isakazwa kumashidi amaningi, kuzodingeka uhlanganise amashidi noma wenze ama-multiple merges ehlanganisiwe. Futhi, qinisekisa ukuthi amashidi abizwa ngokucacile , njengoba uzodinga ukwazi ukukhetha ishidi ohlose ukuyisebenzisa ngaphandle kokulibuka.
Ukuhlanganisa Umthombo Wez Data ku-Merge Imeyili
Isinyathelo esilandelayo inqubo yokuhlanganiswa kweposi ukuhlanganisa ispredishithi yakho elungiselelwe ye-Excel nge idokhumenti yeZwi lakho.
- Kumathuluzi wethuluzi lokuhlanganiswa kweMeyili, chofoza inkinobho ye- Open Data Source .
- Ku-Khetha Idatha Yobhokisi lengxoxo ibhokisi, phenya ngokusebenzisa amafolda uze uthole incwadi yakho ye-Excel. Uma ungeke ukwazi ukuthola ifayela lakho le-Excel, qinisekisa ukuthi "Yonke imithombo yedatha" ikhethiwe kwimenyu yokudonsa ibhalwe "Amafayela ohlobo."
- Chofoza kabili kufayela lakho lomthombo we-Excel, noma ukhethe bese uqhafaza Vula .
- Ku-Ibhokisi lebhokisi lethebula le-Khetha, khetha i-Excel sheet equkethe idatha oyifisa ukuhlanganiswa nedokhumenti yakho.
- Qinisekisa ukuthi ibhokisi lokuhlola eliseceleni "Uhlu lokuqala lwedatha liqukethe izihloko zekholomu" lihloliwe.
- Chofoza OK .
Manje ukuthi umthombo wedatha uhlotshaniswe nombhalo oyinhloko, ungaqala ukufaka umbhalo kanye / noma ukuhlela idokhumenti yeWizwi. Nokho, awukwazi ukwenza izinguquko kumthombo wakho wedatha ku-Excel; uma udinga ukwenza izinguquko kudatha, kufanele uvale idokhumenti esemqoka eZwini ngaphambi kokuthi uvule umthombo wedatha ku-Excel.
Ukufaka amasimu ekuhlanganiseni kumadokhumenti wakho kulula ngokulandela lezi zinyathelo:
- Chofoza inkinobho ye- Insert Merge Field kubha yamathuluzi wokuhlanganiswa kweposi. Ibhokisi lebhokisi le-Insert Field Merge lizovela.
- Qinisekisa igama lensimu oyifisa ukuyifaka ohlwini bese uchofoza Faka .
- Ibhokisi lizohlala livulekile, likuvumele ukuthi ufake ezinye izinkambu. Uma ufaka insimu engaphezu kweyodwa ngokulandelana, iZwi ngeke lizenzele ngokuzenzekelayo isikhala phakathi kwamasimu edokhumenti yakho; kufanele wenze lokhu ngokwakho ngemuva kokuvala ibhokisi lengxoxo. Emadokhumenti wakho uzobona igama lesimu elizungezwe imicibisholo emibili.
- Uma usuqedile, chofoza u- Vala .
Ukufaka Amabhulogi Ekheli Nezethulo-Sebenzisa Ngokucophelela
I-Microsoft yakamuva yengeze isici sokuhlanganiswa kweposi esikuvumela ukuba ufake amabhulokhi ekheli kanye nemigqa yokubingelelana. Ngokuchofoza inkinobho ehambelanayo kwibha yamathuluzi, iZwi lizokuvumela ukuba ufake amasimu amaningana ngesikhathi esisodwa, uhlelwe ngokuhlukahluka okufanayo.
Inkinobho yokufaka ikheli lokungena iyona ngakwesobunxele; ukufaka umlayezo wokubingelelisa ngakwesokudla.
Ngaphezu kwalokho, uma uchofoza kunoma iyiphi inkinobho, iZwi libonisa ibhokisi lengxoxo elikunika ezinye izinketho lapho ungathanda ukufaka khona, ukuthi ungathanda ukuba zihlelwe kanjani, yiziphi izimpawu zokufaka okubandakanya nabanye. Ngenkathi lokhu kuzwakala ngokuqondile-futhi uma usebenzisa umthombo wedatha owadalwa ku-Word-kungenza udideke uma usebenzisa i-Excel sheet sheet.
Khumbula lapho kunconywa mayelana nokwengeza umugqa wezinhloko ekhasini lakho lokusebenzela ekhasini 1 laleli sihloko? Kulungile, uma ubiza insimu into ngaphandle kwalokho iZwi elikusebenzisa njengegama lesensimu yedatha efanayo, iZwi lingalinganisa amasimu ngokungalungile.
Lokho kusho ukuthi uma usebenzisa i- block yokufaka ikheli noma ufaka izinkinobho zomugqa wokubingelela , idatha ingase ivele ngendlela ehlukile kunalokho ucacise-ngoba nje amalebula awafani. Ngenhlanhla, i-Microsoft ilindele lokhu futhi yakhiwe kwisici se-Match Fields esikuvumela ukuba ufanise amagama akho ensimu kulawo iZwi esebenzisa emabhuloki.
Ukusebenzisa Amasimu Wokubambisana ukuze Umeze Ngokuqondile Imephu Yezimboni
Ukufanisa amasimu, landela lezi zinyathelo:
- Chofoza inkinobho yeMatch Fields kubha yamathuluzi.
- Ebhokisini lengxoxo ye-Match Fields, uzobona uhlu lwamagama ensimu e-Word ngakwesobunxele. Ngakwesokudla kwebhokisi, uzobona ikholomu yamabhokisi ehlaselwa phansi. Igama ebhokisini ngalinye le-dropdown yinkambu iZwi elisetshenziselwa insimu ngayinye ebhodini lekheli noma I-Greeting line block. Ukwenza noma yikuphi ushintsho, mane ukhethe igama lesimu kusukela ebhokisini lokudonsa.
- Uma usuqedile ukwenza izinguquko, chofoza OK .
Ungakwazi futhi ukuletha ibhokisi lengxoxo ye- Match Fields ngokuchofoza inkinobho ye- Match Fields ngaphansi kwebhokisi le-Insert Address Block noma I-Greeting Line ibhokisi, okubili okuvela uma uchofoza inkinobho yebar yamathuluzi.
Ukubuka Imeyili Ukuhlanganisa Amadokhumenti
Ngaphambi kokuba siqhubeke nokuhlola kuqala nokunyathelisa amadokhumenti akho ahlangene, inothi mayelana nokufometha: Uma ufaka amasimu ukuhlanganisa idokhumenti, iZwi alithwali ngaphezu kokufometha kwedatha kumthombo wedatha.
Ukusebenzisa ukufometha okukhethekile kusuka kumthombo wesipredishithi
Uma ufuna ukusebenzisa ukufometha okhethekile okufana nemitlolo, ngesibindi noma ngaphansi, kufanele wenze njalo eZwini. Uma ubheka idokhumenti ngamasimu, kufanele ukhethe imicibisholo emibili emaceleni omabili lapho ufuna ukusebenzisa ukufometha. Uma ubheka idatha ehlanganisiwe kudokhumenti, vele uqokomise umbhalo ofuna ukuwuguqula.
Khumbula ukuthi noma yikuphi ukuguqulwa kuzothatha kuyo yonke imibhalo ehlangene, hhayi nje umuntu ngamunye.
Ukuhlola kuqala Amadokhumenti Ahlanganisiwe
Ukuze uhlole kuqala amadokhumenti akho ahlangene, chofoza inkinobho Buka Ehlanganisiwe Idatha kwi-barbar yamathuluzi okuhlanganisa i-Mail. Le nkinobho isebenza njengenguquko yokushintsha, ngakho-ke uma ufuna ukubuyela emuva ekubukeni nje amasimu hhayi idatha equkethe, chofoza futhi.
Ungakwazi ukuhamba ngezincwadi ezihlanganisiwe ngokusebenzisa izinkinobho zokuhamba ngebhayisikili yamathuluzi wokuhlanganisa i-Mail. Bayi, kusukela kwesobunxele kuya kwesokudla: Irekhodi yokuqala , irekhodi langaphambili , iya ukurekhoda , irekhodi elilandelayo , irekhodi lokugcina .
Ngaphambi kokuthi uhlanganise amadokhumenti akho, kufanele ubheke kuqala kubo bonke, noma abaningi ngangokunokwenzeka ukuqinisekisa ukuthi konke kuhlanganiswe kahle. Khokha ngokukhethekile ezintweni ezifana nezimpawu zokubhala kanye nokukhala okuzungezile idatha ehlanganisiwe.
Qedela idokhumenti ye-imeyili yakho yokuhlanganiswa
Uma usulungele ukuhlanganisa amadokhumenti akho, unezinqumo ezimbili.
Hlanganisa kuphrinta
Owokuqala ukuwahlanganisa kuphrinta. Uma ukhetha le nketho, amadokhumenti azothunyelwa kuphrinta ngaphandle kokuguqulwa. Ungakwazi ukuhlanganisa iphrinta ngokuchofoza inkinobho yokuhlanganisela inkinobho yamathuluzi wephrinta .
Hlanganisa kumbhalo omusha
Uma udinga ukwenza ngezifiso ezinye noma zonke imibhalo (noma kunjalo, kungaba ukuhlakanipha ukwengeza insimu inothi emthonjeni wedatha kumanothi aqondene nawe), noma wenze noma yiziphi ezinye izinguquko ngaphambi kokuthi uphrinte, ungazihlanganisa nomqulu omusha; uma uhlangana nedokhumenti elisha, i-imeyili ihlanganisa idokhumenti eyinhloko nomthombo wedatha kuzohlala ingaguquki, kodwa uzoba nefayela lesibili eliqukethe amadokhumenti ahlanganisiwe.
Ukuze wenze lokhu, mane uchofoze inkinobho yokuhlanganisa kuya inkinobho yamathuluzi yamathuluzi amasha.
Noma ngabe iyiphi indlela oyikhethayo, uzokwethula ibhokisi lengxoxo lapho ungatshela khona iZwi ukuhlanganisa wonke amarekhodi, irekhodi lamanje, noma uhla lwamarekhodi.
Chofoza inkinobho yezinketho eceleni kwesinqumo oyifunayo bese uchofoza OK .
Uma ufuna ukuhlanganisa ibanga, uzodinga ukufaka inombolo yokuqala kanye nenombolo yokugcina yamarekhodi ofisa ukuwahlanganisa ekuhlanganiseni ngaphambi kokuthi uchofoze OK .
Uma ukhethe ukuphrinta amadokhumenti, ngemuva kokuba ibhokisi lengxoxo likhuphuke, uzonikezwa ibhokisi lengxoxo yokuphrinta. Ungakwazi ukuxhumana nayo ngendlela efanayo nanoma iyiphi enye idokhumenti.