Ingqikithi yale ndlela ukusebenzisa umsebenzi ojwayelekile we-Excel I-HYPERLINK (HYPERLINK), ekuqaleni eyayiklanyelwe ukudala izixhumanisi ezinsizeni zangaphandle kumaseli eshidi. Ngokwesibonelo, kanje:
I-agumenti yokuqala yomsebenzi iyisixhumanisi, eyesibili umbhalo wesibambi seseli obonwa umsebenzisi. Iqhinga liwukuthi ungasebenzisa ukwakhiwa okujwayelekile okuvela olimini lwemakhaphu ye-HTML njengesixhumanisi mailtoAn edala umlayezo wemeyili namapharamitha anikeziwe. Ikakhulukazi, nansi ukwakhiwa okunjalo kufomula:
izokhiqiza uma umsebenzisi achofoza isixhumanisi, lona ngumlayezo:
Uma kunesidingo, ungakwazi ukwengeza ikhophi (CC) kanye nekhophi efihliwe (BCC) kanye nombhalo (Umzimba) encwadini edaliwe kubamukeli abambalwa. Nali ifomula, isibonelo:
=HYPERLINK(“i-mailto:[i-imeyili ivikelwe], [i-imeyili ivikelwe]?cc=[Email protected]&bcc=[Email protected]&isihloko=imibuthano yobungane& Umzimba =Bangani!%0ANginombono.%0AKungani singashayi ingilazi?";"Thumela")
=HYPERLINK(«mailto:[email protected], [email protected]&[email protected]&subject=Friendly get-togethers&body=Abangane!%0AAI unombono.%0AAIngabe kufanele sishaye ingilazi?”,”Thumela ”)
izosenzela umlayezo wemeyili ogcwele ngokugcwele onenqwaba yabamukeli, isihloko nombhalo:
Uma ufaka ukwakhiwa okude kangaka, qaphela ukuthi ungadluli ngezikhala ezengeziwe nezingcaphuno. Futhi ungakhohlwa ukufaka isihlukanisi emzimbeni (umzimba). %0A (iphesenti, uziro kanye nesiNgisi A) uma ufuna ukusabalalisa umbhalo wakho emigqeni eminingi.
Izinzuzo zale ndlela zilula, noma yiziphi izindlela ezifanayo zibandakanya ukusetshenziswa kwama-macros. Kukhona nobubi:
- ayikwazi ukunamathisela ifayela kumlayezo (i-mailto ayisekeli lesi sici ngezizathu zokuphepha)
- ubude bobude bombhalo ku-agumenti yokuqala yomsebenzi we-HYPERLINK yizinhlamvu ezingu-255, ezikhawulela ubude bemilayezo.
- ukuze uthumele incwadi, kufanele uchofoze isixhumanisi ngesandla.
Ngemva kokudansa kancane ngethamborini, ungakha ngisho nefomu elilula elizodala iyunithi yezinhlamvu yombhalo ezingxenyeni ezinikeziwe ezinamapharamitha njengengxabano yokuqala yomsebenzi we-HYPERLINK:
Ifomula ku-E2 izoba:
=»mailto:»&C2&», «&C3&»?cc=»&C5&», «&C6&»&bcc=»&C8&», «&C9&»&subject=»&C11&»&body=»&C13&»%0A»&C14&»%0A»&C15&»%0A»&C16&»%0A»&C17
- Uhlu lwamakheli anesengezo se-PLEX
- Izindlela ezahlukahlukene zokuthumela imiyalezo ye-imeyili kusuka ku-Excel