Uzithumela njani ii-imeyile ngqo kwi-Excel

  • I-Excel ikuvumela ukuba uthumele ii-imeyile ngokuthe ngqo, ukwenza unxibelelwano lwedatha lula.
  • Ukusebenzisa i-Outlook ukuthumela iifayile kwi-Excel iqinisekisa isantya kunye nokhuseleko.
  • Iinketho zokuthumela ii-imeyile azikho iimacros okanye usebenzisa iVBA.
  • Ungqamaniso lwe-Excel kunye ne-Outlook ngundoqo ekuthumeleni ii-imeyile.

ii-imeyile ezivela e-excel

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:

  1. Okokuqala, Sivula i-Outlook.
  2. Emva koko siya kuthi "Iirekhodi".
  3. Sinqakraza "Khetha" kwaye emva koko siya "Ngokubanzi".
  4. Kwiinketho zokuqalisa, sivula ithebhu ye-Outlook njengenkqubo echazwe kwangaphambili yee-imeyile, abafowunelwa, iikhalenda, njl.
  5. 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

thumela i-imeyile ebalaseleyo

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:

  1. Okokuqala siya kwi-Excel kwaye, kwiribhoni engentla, sikhetha "Iirekhodi".
  2. Emva koko sicofa "Yabelana nge-imeyile".
  3. 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:

  1. 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).
  2. Emva koko kufuneka uvule incwadi yokusebenza ye-Excel edityaniswe neemacros.
  3. Siyacinezela F11 ukwenza amandla Microsoft Visual Basic.
  4. Ngokuzenzekelayo, a código esinokufikelela ngokucofa kabini kuyo Le Ncwadi yoMsebenzi. Okulandelayo sincamathisela ikhowudi kwifestile entsha evulayo.
  5. Emva koko sibuyisela i-imeyile nge idilesi yomamkeli kwi-intanethi.
  6. 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.


Shiya uluvo lwakho

Idilesi yakho ye email aziyi kupapashwa. ezidingekayo ziphawulwe *

*

*

  1. Uxanduva lwedatha: UMiguel Ángel Gatón
  2. Injongo yedatha: Ulawulo lwe-SPAM, ulawulo lwezimvo.
  3. Umthetho: Imvume yakho
  4. Unxibelelwano lwedatha: Idatha ayizukuhanjiswa kubantu besithathu ngaphandle koxanduva lomthetho.
  5. Ukugcinwa kweenkcukacha
  6. Amalungelo: Ngalo naliphi na ixesha unganciphisa, uphinde uphinde ucime ulwazi lwakho.