Lub ntsiab ntawm txoj kev no yog siv tus txheej txheem Excel ua haujlwm HYPERLINK (HYPERLINK), uas yog Ameslikas tsim los tsim kev sib txuas rau cov khoom siv sab nraud hauv cov hlwb ntawm daim ntawv. Piv txwv li, zoo li no:
Thawj qhov kev sib cav rau qhov muaj nuj nqi yog qhov txuas, qhov thib ob yog cov ntawv tso rau hauv lub xov tooj ntawm tes uas tus neeg siv pom. Qhov ua kom yuam kev yog tias koj tuaj yeem siv tus qauv tsim los ntawm HTML markup lus ua qhov txuas mailtoIb qho uas tsim cov ntawv xa ntawv nrog rau qhov muab tsis tau. Hauv particular, ntawm no yog ib qho kev tsim kho hauv cov qauv:
yuav tsim thaum tus neeg siv nyem rau ntawm qhov txuas, qhov no yog cov lus:
Yog tias tsim nyog, koj tuaj yeem ntxiv ib daim ntawv luam (CC) thiab daim ntawv zais (BCC) thiab ntawv nyeem (Lub cev) rau hauv tsab ntawv tsim rau ntau tus neeg tau txais. Nov yog ib qho qauv, piv txwv li:
=HYPERLINK(“mailto:[email tiv thaiv], [email tiv thaiv]?cc=[Email tiv thaiv]&bcc=[Email tiv thaiv]&subject=phooj ywg sib tham& lub cev =Cov Phooj Ywg!%0AKuv muaj ib lub tswv yim.%0AVim li cas peb tsis npuaj iav?";"Xa")
=HYPERLINK(«mailto:[email tiv thaiv], [email tiv thaiv][email tiv thaiv]&[email tiv thaiv]&subject=Friendly get-togethers&body=Friends!%0AAI muaj ib lub tswv yim.%0AAShould we clap a glass?”,”Xa ”)
yuav ua rau peb ib tug tag nrho-fledged mail lus nrog ib pawg ntawm cov neeg tau txais kev pab, cov ntsiab lus thiab cov ntawv:
Thaum nkag mus rau qhov kev tsim kho ntev, ceev faj kom tsis txhob overdo nws nrog qhov chaw ntxiv thiab cov lus hais. Tsis tas li ntawd tsis txhob hnov qab ntxig lub cais rau hauv lub cev (lub cev). %0A (feem pua, xoom thiab Askiv A) yog tias koj xav nthuav koj cov ntawv hla ntau kab.
Qhov zoo ntawm txoj kev no yog kev yooj yim, txhua txoj hauv kev zoo sib xws suav nrog kev siv macros. Kuj tseem muaj cons:
- tsis tuaj yeem xa cov ntaub ntawv rau cov lus (mailto tsis txhawb qhov no vim kev ruaj ntseg)
- Qhov siab tshaj plaws ntawm cov ntawv nyeem hauv thawj qhov kev sib cav ntawm HYPERLINK muaj nuj nqi yog 255 cim, uas txwv qhov ntev ntawm cov lus
- xa ib tsab ntawv, koj yuav tsum manually nyem rau ntawm qhov txuas.
Tau seev cev me ntsis nrog tambourine, koj tuaj yeem tsim ib daim ntawv yooj yim uas yuav tsim cov kab ntawv los ntawm cov khoom tawg nrog cov tsis raws li thawj qhov kev sib cav ntawm HYPERLINK muaj nuj nqi:
Cov mis hauv E2 yuav yog:
=»mailto:»&C2&», «&C3&»?cc=»&C5&», «&C6&»&bcc=»&C8&», «&C9&»&subject=»&C11&»&body=»&C13&»%0A»&C14&»%0A»&C15&»%0A»&C16&»%0A»&C17
- Cov npe xa ntawv nrog PLEX add-on
- Muaj ntau txoj hauv kev los xa cov ntawv xa los ntawm Excel