Izvo zvakakosha zveiyi nzira ndeye kushandisa yakajairwa Excel basa HYPERLINK (HYPERLINK), iyo yakatanga kugadzirirwa kugadzira zvinongedzo kune zvekunze zviwanikwa mumaseru epepa. Semuenzaniso, seizvi:
Nhaurirano yekutanga kune basa iri link, yechipiri ndeyechibatiso chinyorwa musero chinoonekwa nemushandisi. Iyo dhizaini ndeyekuti iwe unogona kushandisa yakajairwa kuvaka kubva kuHTML markup mutauro sechinhu chinongedzo mailtoIyo inogadzira meseji yemeseji ine ma parameter akapihwa. Kunyanya, heino chivakwa chakadaro mune formula:
ichagadzira kana mushandisi adzvanya pane chinongedzo, iyi ndiyo meseji:
Kana zvichidikanwa, unogona kuwedzera kopi (CC) uye kopi yakavanzika (BCC) uye chinyorwa (Muviri) kune iyo yakagadzirwa tsamba kune vakawanda vanogamuchira. Heino fomula, semuenzaniso:
=HYPERLINK("mailto:[email yakachengetedzwa], [email yakachengetedzwa]?cc=[Email akadzivirira]&bcc=[Email akadzivirira]&chidzidzo=kuungana kwoushamwari& Muviri =Shamwari!%0ANdine zano.%0ASei tisingaombere girazi?";"Send")
=HYPERLINK(«mailto:[email protected], [email protected]&[email protected]&subject=Shamwari dzeshamwari&body=Shamwari!%0AAI tine zano.%0AATinofanira kuombera girazi here?",”Tumira ”)
achatiitira meseji yakazara-yakazara ine boka revanogamuchira, chinyorwa uye chinyorwa:
Paunopinda muchivakwa chakareba kudaro, chenjerera kuti urege kupfuudza nekuwedzera nzvimbo uye makotesheni. Uyewo usakanganwa kuisa separator mumuviri (muviri). %0A (muzana, zero neChirungu A) kana iwe uchida kuparadzira chinyorwa chako mumitsara yakawanda.
Zvakanakira nzira iyi zviri nyore, chero nzira dzakafanana dzinosanganisira kushandiswa kwemacros. Kune zvakare cons:
- haikwanise kubatanidza faira kune meseji (mailto haitsigire chinhu ichi nekuda kwezvikonzero zvekuchengetedza)
- hurefu hwechinyorwa munharo yekutanga yeHYPERLINK basa ndeye 255 mavara, anoganhura kureba kwemeseji.
- kuti utumire tsamba, unofanira kudzvanya nemaoko pane chinongedzo.
Watamba zvishoma netamborini, unogona kutogadzira chimiro chakareruka chinozogadzira tambo yemavara kubva pane zvakapihwa zvimedu zvine paramita senharo yekutanga yeHYPERLINK basa:
Iyo formula muE2 ichave:
=»mailto:»&C2&», «&C3&»?cc=»&C5&», «&C6&»&bcc=»&C8&», «&C9&»&subject=»&C11&»&body=»&C13&»%0A»&C14&»%0A»&C15&»%0A»&C16&»%0A»&C17
- Rondedzero yetsamba ine PLEX yekuwedzera
- Nzira dzakasiyana dzekutumira mameseji kubva kuExcel