Inkqubo ye-Microsoft 365 yespredishithi, Excel, iyaziwa ngokusebenziseka kwayo okukhulu xa isenza zonke iintlobo ze-accounting kunye nemisebenzi yezemali. Nangona kunjalo, ikwanayo neminye imisebenzi engaziwayo kakhulu enokuba luncedo olukhulu kwiimeko ezithile. Kule post, ngaphandle kokuya phambili, siyakuxelela indlela yokuthumela ii-imeyile ngqo kwi-Excel.
Imeko ecacileyo kakhulu xa kuvela isidingo sokunxibelelana okanye ukwabelana ngedatha kwi-spreadsheet esisebenza kuyo. Kukho indlela elula kakhulu yokwenza oku ngaphandle kokushiya isicelo.
Izinto ezilungileyo zokuthumela ii-imeyile ukusuka ku-Excel
Indibaniselwano yeenzuzo ze-Excel kunye nezo ze-Outlook isinika umphumo onomdla kakhulu: ukuba kunokwenzeka yabelana ngesixa esikhulu solwazi (idatha, izibalo, iigrafu, izibalo, amaxwebhu, njl.) nge-imeyile. Phakathi koluhlu lwayo lweenzuzo sinokubonisa ezi:
- Khawuleza, kuba abancedisi bazo zombini iinkonzo zilungelelanisiwe.
- Khu seleko. I-Excel igcina ikopi yedatha efakwe kwi-imeyile. Kwelinye icala, i-Outlook ikwaqhuba i-backup.
- Ukuhambelana: Kuyenzeka ukuba uthumele ii-imeyile nge-Gmail kunye ne-Hotmail.
Inyathelo elidlulileyo: ungqamaniso
Oku kunokwenzeka ukuba nje iisetingi zeOfisi yeMicrosoft yakho zingqanyaniswe kakuhle neOutlook njengedilesi yeimeyile ehlala ikho. Ukuba kunjalo, siya kukwazi ukuthumela naluphi na uhlobo loxwebhu njengezihlomelo ze-imeyile. Kwimeko apho olu ngqamaniso lungamiselwanga, kufuneka silwenze. Kufuneka ulandele amanyathelo ambalwa alula:
- Okokuqala, Sivula i-Outlook.
- Emva koko siya kuthi "Iirekhodi".
- Sinqakraza "Khetha" kwaye emva koko siya "Ngokubanzi".
- Kwiinketho zokuqalisa, sivula ithebhu ye-Outlook njengenkqubo echazwe kwangaphambili yee-imeyile, abafowunelwa, iikhalenda, njl.
- Ekugqibeleni, sicofa Yamkela
Nje ukuba inyathelo langaphambili longqamaniso ligqityiwe, siya kuchaza ngokweenkcukacha oko kufuneka kwenziwe ukuthumela ii-imeyile ezivela kwi-Excel.
Thumela ii-imeyile ukusuka ku-Excel
Ukusebenzisa usetyenziso lwe-Excel ukuthumela ii-imeyile ngokuthe ngqo, sinokukhetha ezimbini: kunye okanye ngaphandle kweemakhro. Okwangoku kufanelekile ukucacisa ukuba sibiza uluhlu lwemiyalelo equlethwe kuxwebhu lwe-Excel i-macro. Sichaza indlela yokuqhuba kwimeko nganye kwezi zimbini:
Akukho makhrosi
Le yindlela elandelayo ukungagqibeki kwi-Outlook. Isicelo sinoxanduva lokuvelisa ikopi yefayile ye-Excel okanye uxwebhu kwaye uyithumele kumamkeli oboniswe ngumsebenzisi. Kule meko, ifayile ithunyelwa ngefomathi yePDF. Nantsi into ekufuneka siyenze:
- Okokuqala siya kwi-Excel kwaye, kwiribhoni engentla, sikhetha "Iirekhodi".
- Emva koko sicofa "Yabelana nge-imeyile".
- Okulandelayo siphawula ukhetho lwe thumela idatha njengeziqhoboshelo kwaye sinika "Thumela".
ngeemakhro
Oku kunokwenzeka kufuna ukuba sisebenzise ulwimi lokucwangcisa I-VBA (iSiseko esiBonakalayo sosetyenziso), eyona nto isetyenziswa nguMicrosoft ukwandisa imisebenzi yeenkqubo zayo. Ukuthumela i-imeyile evela kwi-Excel kunye ne-macros, kufuneka ugcine ifayile ngokuchanekileyo. Ukwenza oku, siya kulandela la manyathelo:
- Into yokuqala yokwenza kukuba gcina i-spreadsheet kwiiFayile njenge a incwadi yokusebenza ye-excel ene-macro-enabled (njengebhokisi yencoko yababini kunye nokukhetha incwadi enegama elahlukileyo).
- Emva koko kufuneka uvule incwadi yokusebenza ye-Excel edityaniswe neemacros.
- Siyacinezela F11 ukwenza amandla Microsoft Visual Basic.
- Ngokuzenzekelayo, a código esinokufikelela ngokucofa kabini kuyo Le Ncwadi yoMsebenzi. Okulandelayo sincamathisela ikhowudi kwifestile entsha evulayo.
- Emva koko sibuyisela i-imeyile nge idilesi yomamkeli kwi-intanethi.
- Ukugqiba, sivala iMicrosoft Visual Basic kwaye sicofe ku "Thumela".
Inketho ethi "nge-macros" yeyona nto kufuneka sikhethe ukuyenza ukuthunyelwa ngobuninzi. Kule meko, into ekufuneka uyenzile kukudala i-VBA macro kunye neprogram (ukuqwalasela) ikhowudi yokuthumela i-imeyile enkulu.