Nhamba yeMicrosoft Merge feature inokubvumira kutumira gwaro rimwechete nekuchinja kuduku kune nhamba yakawanda yevakagamuchira. Izwi rokuti "kubatanidza" rinobva pakuziva kuti imwe nyandiko (tsamba, somuenzaniso) inosanganiswa nedhiyabhorosi yemagwaro, sepaspiritsi .
Maziso eShoko akabatanidza maitiro anoshanda asinganzwisisiki nemashoko kubva kuExcel. Kunyange zvazvo Shoko richikubvumira iwe kuti uite dhiyabhorosi yako pachake, zvigadzidzo zvekushandisa iyi data zvishoma. Uyezve, kana iwe uine data yako mune pepafurasi, hazviiti kunyatsonzwisisa kubata zvakare mashoko ose muShoko reShoko.
Kugadzirira Dhiyabhorosi Dzako Meseji Merge
Zvinyorwa, unogona kushandisa chero shanduro yekushanda ye Excel muShoko reMeyili yekubatana basa pasina chero gadziriro yakakosha. Zvisinei, zvinokurudzirwa kuti utore nguva yekugadzirira pepa rako rekushandira kuti uwedzere mazishe ekubatana .
Heano maitiro mashomanana ekucherechedza izvo zvichabatsira kuti mail iyananise hutano iende zvakanaka.
Rongedza Dharedhi YepaDhadharo Yenyu
Pangozi yekureva pachena, deta yako inofanira kurongeka zvakakwana mumitsara nemadzamu. Funga pamutsara wega wega sewe rekodhi imwechete uye imwe korumunda semunda waunenge uchida kuisa mumagwaro ako. (Tarisa kunze kwe Excel data-entry tutorial kana uchida kugadzirisa.)
Gadzira Header Row
Gadzira mutsara we musoro kune peji iwe waunoda kushandisa nekuda kwema mail kuungana. Mutsara wemusoro ndiwo musara une mavarai anoratidza data mumasero ari pasi apa. Excel inogona kunge yakagadzirisa dzimwe nguva pamusoro pekuparadzanisa pakati pezvinyorwa uye mavara, saka ita izvi zvijekese nekushandura mashoko akashinga, masero emasero uye chekisi shading izvo zvakasiyana nemutsara wepamusoro. Izvi zvichaita kuti Excel iparadzanise kubva kune imwe nzvimbo yedhesi yako.
Pave paya paunenge uchibatanidza data nedhidhiyo huru, mavara acho achaonekwa semazita emasangano akabatanidzwa, saka hakuzovi nekuvhiringidzika kuti ndeyepi dhesi iwe uri kuisa muudhadhi yako. Uyezve, iyo tsika yakanaka yekuisa ma column yako, sezvo inobatsira kudzivirira kukanganisa kwevashandi.
Isa Zvose Dhiyabhorosi paShaiti imwe chete
Dhesiro yaunoda kushandisa nekuda kwemaseri kuwirirana inofanira kuva pane imwe peji. Kana ikapararira mukati memashizha mazhinji, iwe uchada kubatanidza mapepa kana kuita mavhesi akawanda merges. Uyewo, iva nechokwadi chokuti mapepa acho anonyatsotumidzwa , sezvamunoda kuti ukwanise kusarudza pepa iyo iwe unoda kushandisa pasina kuiona.
Kushamwaridzana neDhiyabhorosi Inowanikwa muMetan Merge
Nhanho inotevera mune tsamba yekubatanidza nzira yekubatanidza yako yakagadzirwa Excel spreadsheet nedhidziso yako yeShoko.
- Pamusoro peTybar toolbar Merge, chengetedza Bhokisi re Open Open Source .
- MuchiSarudza Data Dhiyabhorosi dialog box, fambai kuburikidza nemafaira kusvikira mawana bhuku renyu reku Excel. Kana iwe usingakwanisi kuwana yako Excel faira, iva nechokwadi chokuti "Zvose zvinotapura zvinyorwa" zvinosarudzwa mumenyu inodonha yakanyorwa "Files of type."
- Dzoka kaviri pane yako source Excel source file, kana kuti sarudza uye chovha Open .
- MuchiSarudza Table dialog box, sarudza Excel pepa rine data yaunoda kuwirirana nedhidhiyo yako.
- Iva nechokwadi chokuti bhokisi rinotarisa riri "Mutsara wokutanga we data rine korona yemusoro" inoongororwa.
- Dzvanya OK .
Iye zvino kuti iyo data yakabva yave yakabatanidzwa neyinyorwa huru, unogona kutanga kupinda mavara uye / kana kugadzira dhidhiro yako yeShoko. Iwe haugoni, zvisinei, kuchinja kunzvimbo yako yedhesi mu Excel; kana uchida kugadzirisa kune data, unofanira kuvhara dhiyabhorosi huru muShoko usati washa kuzarura dhesi rekushandisa mu Excel.
Kuisa masangano masangano muchikwata chako zviri nyore nekutevera matanho aya:
- Dzvanya bhokisi re Insert Merge Field pamakatani ekubatanidza kadhi. The Insert Merge Field dialog box ichaonekwa.
- Simbisa zita remunda waunoda kuisa kubva pakurongwa uye chengeta Isa .
- Bhokisi racho richagara rakazaruka, richikubvumira kuisa mamwe masimi. Kana iwe ukaisa zvinopfuura imwe munda mumakwikwi, Shoko harizowedzera nzvimbo pakati peminda mumagwaro ako; iwe unofanirwa kuzviita iwe pachako mushure mekuvhara bhokisi rebhokisi. Mutsamba yako uchaona zita remunda rakapoteredzwa nemiseve miviri.
- Paunenge wapedza, chura Close .
Kuisa Mazita Ezvinyorwa Nekukwazisa-Shandisa Zvakanaka
Microsoft ichangobva kuwedzera mail yekubatanidza chinhu chinokubvumira kuti uise mabheji ekutaura uye mitsara yekukwazisa. Nokukanda bhatani rakanamatira pane bharari, Shoko rinokubvumira kuti uise mimwe michina kamwe chete, yakarongeka nenzira dzakasiyana.
Iko inowani kero yekuvharira bhokisi ndiyo imwe kuruboshwe; iyo mutsara wokukwazisa inowanikwa kurudyi.
Uyezve, kana iwe ukanyora pane bhatani, Shoko rinoratidza bhokisi rekukurukuro rinokupa mamwe maitiro pane maitiro aungada kuiswa, sei waungada kuti agadzirwe, chii chinopinza kuisa pamwe nevamwe. Kunyange zvazvo izvi zvichitaura zvakananga-uye kana iwe uri kushandisa deta yakagadzirwa muShoko-zvinogona kuvhiringidza kana uri kushandisa Excel worksheet.
Yeuka apo rumbidzo pamusoro pekuwedzera mutsara wepamusoro mune pepa rako rebasa riri papeji 1 yenyaya ino? Zvakanaka, kana iwe uchitumidza munda chimwe chinhu kunze kwekuti Shoko rinoshandisa sezita remunda rine dhese rakafanana, Shoko rinogona kufanana neminda kusina kururama.
Izvi zvinorevei kana iwe ukashandisa kuisa kero yekuvhara kana kuisa mabhesi emutsara ekukwazisa , data inogona kuonekwa mune imwe yakarongeka pane iwe unotsanangura-kungoita nokuti mavara haafananidzi. Nenzira yakanaka, Microsoft inofungidzira izvi uye yakavakwa mune chimwe chinhu cheMatch Field iyo inokubvumira kufanidza mazita emunda wako kune avo Shoko rinoshandisa mumatombo.
Kushandisa Match Fields Kururamisa Map Map Field Labels
Kuti ufanane neminda, tevera matanho aya:
- Dzvanya paMatch Fields bhokisi pane toolbar.
- MuMatch Fields dialog box, uchaona mazita emashoko eShoko kuruboshwe. Kurutivi rworudyi rwebhokisi, uchaona korona yemabhokisi ekuderera. Zita iri mubhokisi rimwe nerimwe rinodonhedzwa ndiro munda iro Shoko rinoshandisa kune imwe neimwe nzvimbo iri muIndaneti yeChitsuwa kana Greeting line block. Kuti uite chero shanduko, ingosarudza zita remunda kubva kubhokisi rakaderera.
- Kana wapedza kugadzirisa, sarudza OK .
Iwe unogonawo kuunza Match Fields dialog box nekukanda Match Fields bhatani iri pasi peIndaneti Address Block kana Greeting Line dialog box, zvose zviri kuonekwa kana iwe ukanyora bhatani rebarabhati.
Kuona Mail Kubatanidza Ma Documents
Tisati taenda kunotarisa nekunyora magwaro ako akabatanidzwa, chinyorwa pamusoro pekugadzirisa: Kana uisa kuisa masimi mudhipatimendi, Shoko harina kutakura pamusoro pekugadzirisa kwemashoko kubva pane deta.
Kushandisa Kugadziridza Kunokosha kubva Pasi Pasigiriti
Kana iwe uchida kushandisa maitiro akasiyana-siyana akadai sematariki, usingaregi kana kuteterera, iwe unofanira kuzviita muShoko. Kana uri kuona dhidhiyo neminda, unofanira kusarudza miseve miviri kumativi maviri emunda waunoda kushandisa maitiro. Kana uri kutarisa dheji yakabatana iri mumagwaro, ingojekesa chete zvinyorwa zvaunoda kuchinja.
Yeuka kuti chero shanduko inotakura mumagwaro ose akabatanidzwa, kwete munhu mumwe chete.
Kuongorora maDhechi Akabatanidzwa
Kuti uongorore magwaro ako akabatanidzwa, chengetedza Bhokisi reDhina reDheta reDhiyabhorosi paBurakiti reKubatanidza yeMavhura. Iri bhatani rinoshanda sechinoshandura chekuchinja, naizvozvo kana uchida kudzokera shure kuti uone masango chete uye kwete data yavari, chengetedza zvakare.
Iwe unogona kufamba kuburikidza nemagwaro akabatanidzwa uchishandisa mabheji ekufamba-famba paTabha yeMatric toolbar. Ivo, kubva kuruboshwe kuenda kurudyi: First Record , Previous Record , Go To Record , Next Record , Last Record .
Iwe usati waunganidza mapepa ako, iwe unofanira kutanga watarisa vose, kana kuti neavo vese unokwanisa kuti uone kuti zvinhu zvose zvakabatana zvakarurama. Chengetedza zvakanyanya zvinhu zvakadai sechiratidzo uye nzvimbo yakapoteredza data yakabatana.
Shandisa Mharidzo Yako Merge Document
Kana wakagadzirira kuunganidza magwaro ako, une zvisarudzo zviviri.
Gungano kuChinyorwa
Chokutanga ndechekubatanidza ku printer. Kana ukasarudza sarudzo iyi, zvinyorwa zvichaendeswa kune printer pasina kuchinjwa. Iwe unogona kubatanidza ku printer nekungodonha kubatanidza kuItakiti yepakisha yechabatanidza.
Gungano muNew Document Nyaya
Kana uchida kugadzirisa zvimwe kana zvese zvinyorwa (kunyange zvakadaro, unenge wakachenjera kuwedzera mundima yemashoko mukati memashoko ekutsvaga manotsi), kana kuita chero humwe shanduko usati wapa, iwe unogona kuzvibatanidza kune zvinyorwa zvitsva; kana iwe uchibatanidza kune chigwaro chitsva, mail inosanganisira chigwaro chikuru uye deta inotora icharamba ichinyatsogadzikana, asi iwe uchava nefaira rechipiri rine zvinyorwa zvakabatana.
Kuti uite izvi, zvingonyanidza bhatani reBatanidzwa kuNew Document toolbar.
Chero chero nzira yaunosarudza, iwe uchaiswa nebhokisi rebhokisi umo iwe unogona kuudza Shoko kuti iyananise zvinyorwa zvose, rekodi yazvino, kana huwandu hwezvinyorwa.
Dzvanya bhodhi rekusarudza pedyo nechisarudzo chako chaunoda uye wovhara OK .
Kana iwe uchida kubatanidza ronga, iwe uchada kuisa munhamba yekutanga uye nhamba yekupedzisira yezvinyorwa zvaunoda kuzviisa mubatanidzwa usati wanyora OK .
Kana ukasarudza kudhinda zvinyorwa, mushure mekunge bhokisi rebhokisi rinouya, iwe uchaiswa neChirangaridzo dialog box. Iwe unogona kutaurirana nayo zvakafanana sezvaungada kune imwe nyaradzi.