Ma'anar wannan hanyar ita ce amfani da daidaitaccen aikin Excel HYPERLINK (HYPERLINK), wanda aka tsara asali don ƙirƙirar hanyoyin haɗi zuwa albarkatun waje a cikin sel na takardar. Misali, kamar haka:
Hujja ta farko ga aikin ita ce hanyar haɗin gwiwa, na biyu kuma shine rubutun ma'auni a cikin tantanin halitta wanda mai amfani yake gani. Dabarar ita ce za ku iya amfani da daidaitaccen gini daga harshen alamar HTML azaman hanyar haɗi mailtoWanda ke ƙirƙirar saƙon saƙo tare da sigogin da aka bayar. Musamman, ga irin wannan gini a cikin dabara:
zai haifar lokacin da mai amfani ya danna mahaɗin, wannan shine sakon:
Idan ya cancanta, zaku iya ƙara kwafi (CC) da ɓoye kwafin (BCC) da rubutu (Jiki) zuwa wasiƙar da aka ƙirƙira ga masu karɓa da yawa. Ga dabara, misali:
=HYPERLINK("mailto:[email protected], [email protected]?cc=[Email kare]&bcc=[Email kare]& batu =taron sada zumunci& Jiki =Abokai!%0AIna da ra'ayi.%0AMe ya sa ba za mu tafa gilashi ba?";"Aika")
=HYPERLINK(«mailto:[email protected], [email protected][email protected]&[email protected]&subject=Taron abokantaka&body=Friends!%0AAI suna da ra'ayi.%0AAYa kamata mu tafa gilashi?",Aika ”)
zai sanya mu cikakken saƙon wasiku tare da tarin masu karɓa, jigo da rubutu:
Lokacin shigar da irin wannan dogon gini, a yi hankali kada a wuce gona da iri tare da ƙarin sarari da fa'ida. Haka kuma kar a manta da saka mai raba cikin jiki (jiki). %0A (kashi, sifili da Ingilishi A) idan kuna son yada rubutun ku ta layuka da yawa.
Amfanin wannan hanyar shine sauƙi, kowane irin wannan hanyoyin ya haɗa da amfani da macro. Akwai kuma rashin amfani:
- kasa haɗa fayil zuwa saƙo (mailto baya goyan bayan wannan fasalin saboda dalilai na tsaro)
- Matsakaicin tsayin rubutu a farkon hujjar aikin HYPERLINK shine haruffa 255, wanda ke iyakance tsawon saƙon.
- don aika wasiƙa, dole ne ku danna mahaɗin da hannu.
Bayan kun yi rawa kaɗan tare da tambourine, kuna iya ƙirƙirar tsari mai sauƙi wanda zai haifar da zaren rubutu daga guntun da aka bayar tare da sigogi azaman hujja ta farko na aikin HYPERLINK:
Tsarin da ke cikin E2 zai kasance:
=»mailto:»&C2&», «&C3&»?cc=»&C5&», «&C6&»&bcc=»&C8&», «&C9&»&subject=»&C11&»&body=»&C13&»%0A»&C14&»%0A»&C15&»%0A»&C16&»%0A»&C17
- Jerin aikawasiku tare da ƙari na PLEX
- Hanyoyi daban-daban don aika saƙonnin wasiku daga Excel