Ukuthumela incwadi noma ishidi nge-imeyili

Uma ngokuvamile kufanele uthumele izincwadi ezithile noma amashidi nge-imeyili, kufanele ngabe uqaphele ukuthi le nqubo ayikwazi ukubizwa ngokushesha. Uma ukwenza "i-classically", uzodinga:

  • vula uhlelo lwe-imeyili (isibonelo, i-Outlook)
  • dala umlayezo omusha
  • thayipha ikheli, isihloko kanye nombhalo
  • namathisela ifayela kumlayezo (ungakhohlwa!)
  • chofoza inkinobho Thumela

Eqinisweni, imeyili ingathunyelwa kalula isuka ku-Excel ngenqwaba yezindlela ezihlukene. Hamba...

Indlela 1: Okushumekiwe Thumela

Uma usenayo i-Excel 2003 endala, khona-ke yonke into ilula. Vula ibhuku/ishidi olifunayo bese ukhetha kumenyu Ifayela – Thumela – Umlayezo (Ifayela — Thumela Ku — Umamukeli Wemeyili). Iwindi lizovuleka lapho ungakhetha khona eyodwa kwezimbili ongakhetha ukuyithumela:

Esimweni sokuqala, ibhuku lamanje lizokwengezwa emyalezweni njengesinamathiseli, esimweni sesibili, okuqukethwe kweshidi lamanje kuzongena ngqo embhalweni womlayezo njengethebula lombhalo (ngaphandle kwamafomula).

Ngaphezu kwalokho, imenyu Ifayela – Thumela (Ifayela — Thumela Ku) kukhona ezinye izinketho zokuthumela ezingavamile:

 

  • Umlayezo (uzobuyekezwa) (Umamukeli Wemeyili uzobuyekezwa) - ibhuku lokusebenzela lonke liyathunyelwa futhi ngesikhathi esifanayo ukulandelelwa koshintsho kuvulelwe lona, ​​okungukuthi kuqala ukulungiswa ngokucacile - ngubani, nini futhi kumaphi amaseli enze izinguquko. Ungabe usubonisa izinguquko ezenziwe kumenyu Isevisi - Ukulungiswa - Gqamisa ukulungiswa (Amathuluzi — Landela izinguquko — Gqamisa izinguquko) noma kuthebhu Buyekeza - Ukulungiswa (Buyekeza — Landela izinguquko) Kuzobukeka okuthile okufana nalokhu:

    Ozimele abanemibala bamaka izinguquko ezenziwe kudokhumenti (umsebenzisi ngamunye unombala ohlukile). Uma uhambisa igundane, kuvela iwindi elifana nenothi elinencazelo enemininingwane yokuthi ubani, ini futhi nini eshintshwa kuleli seli. Kulula kakhulu ukubuyekeza amadokhumenti, lapho, ngokwesibonelo, uhlela umbiko wabangaphansi kwakho noma umphathi ehlela owakho.

  • Emzileni (Umamukeli womzila) - umlayezo lapho incwadi yakho izonamathiselwa khona uzodlula ochungechungeni lwabamukeli, ngamunye wabo ozoyidlulisela ngokuzenzakalelayo, njengenduku. Uma uthanda, ungasetha umlayezo ukuthi ubuyele kuwe ekupheleni kweketango. Ungavumela ukulandelwa koshintsho ukuze ubone ukuhlelwa okwenziwe ngumuntu ngamunye ochungechungeni.

Ku-Excel 2007/2010 entsha, isimo sihluke kancane. Kulezi zinguqulo, ukuze uthumele incwadi ngeposi, udinga ukukhetha inkinobho Office (Inkinobho Yehhovisi) noma ithebhu Ifayela (Ifayela) kanye neqembu Thumela (Thumela). Okulandelayo, umsebenzisi unikezwa isethi yezinketho zokuthumela:

Sicela uqaphele ukuthi ezinguqulweni ezintsha, ikhono lokuthumela ishidi elihlukile lencwadi yokusebenzela elifakwe emzimbeni wencwadi selinyamalele - njengoba lalinjalo ku-Excel 2003 nakamuva. Okuwukuphela kwenketho esele ukuthumela lonke ifayela. Kodwa kube nethuba eliwusizo lokuthumela ngefomethi ye-PDF eyaziwa kakhulu kanye ne-XPS engaziwa kancane (efana ne-PDF, kodwa ayidingi i-Acrobat Reader ukuze ifundwe - ivula ngokuqondile ku-Internet Explorer). Umyalo wokuthumela incwadi ukuze ibuyekezwe ungakhishwa njengenkinobho eyengeziwe kuphaneli yokufinyelela okusheshayo ngokusebenzisa Ifayela - Izinketho - Ibha yamathuluzi yokufinyelela Ngokushesha - Yonke Imiyalo - Thumela ukuze Ubuyekeze (Ifayela — Izinketho — Ibha yamathuluzi yokufinyelela Ngokushesha — Yonke Imiyalo — Thumela ukuze Ibuyekezwe).

Indlela 2. Amamakhro alula okuthumela

Ukuthumela i-macro kulula kakhulu. Ukuvula i-Visual Basic Editor ngeMenu Isevisi – Macro – Visual Basic Editor (Amathuluzi — Macro — Visual Basic Editor), faka imojuli entsha kumenyu Faka – Imojula bese ukopisha umbhalo wala makhro amabili lapho:

I-Sub SendWorkbook() I-ActiveWorkbook.ThumelaI-imeyili Abamukeli:="[i-imeyili ivikelwe]", Isihloko:="Лови файлик" Qeda I-Sub Sub SendSheet() ThisWorkbook.AmaSpredishithi("Лист1").Kopisha Nge-ActiveWorkbook .ThumelaI-imeyili Abamukeli:="[i-imeyili protected]", Isihloko:="Bamba ifayela" .Vala GcinaIzinguquko:=Isiphetho Esingelona Isehlukaniso

Ngemuva kwalokho, ama-macros akopishiwe angasebenza kumenyu Isevisi - Macro - Macros (Amathuluzi - Imakhro - Amakhro). Thumela Incwadi Yokusebenzela ithumela lonke ibhuku lamanje ekhelini elishiwo, futhi ThumelaSheet - Ishidi1 njengesinamathiselo.

Uma usebenzisa i-macro, i-Excel izoxhumana ne-Outlook, okuzokwenza ukuthi umlayezo wokuphepha olandelayo uvele esikrinini:

Linda kuze kube inkinobho Xazulula iqala ukusebenza bese uyichofoza ukuze uqinisekise ukuthunyelwa kwakho. Ngemva kwalokho, imilayezo ekhiqizwe ngokuzenzakalelayo izofakwa kufolda Uyaphuma futhi izothunyelwa kubamukeli okokuqala lapho uqala i-Outlook noma, uma iyasebenza, ngaso leso sikhathi.

Indlela 3. I-Universal macro

Futhi uma ungafuni ukuthumela incwadi yamanje, kodwa noma yiliphi elinye ifayela? Futhi umbhalo womlayezo nakho kungaba kuhle ukusethwa! Amamakhro adlule ngeke asize lapha, njengoba anqunyelwe amandla e-Excel uqobo, kodwa ungakha i-macro ezophatha i-Outlook kusuka ku-Excel - dala futhi ugcwalise iwindi lomlayezo omusha bese ulithumela. I-macro ibonakala kanje:

I-Sub SendMail() Fiphalisa I-OutMail Njengento Efiphalisa I-Outmail Njengeseli Yento Efiphele Njengohlelo Lohlelo Lokusebenza.ScreenUpdating = I-False Set OutApp = DalaObject("I-Outlook.Application") 'qalisa i-Outlook ngemodi efihliwe I-OutApp.Session.Ngena Ngephutha Hamba uhlanze 'uma kungenjalo iqalile - phuma ku-Set OutMail = OutApp.CreateItem(0) 'dala umlayezo omusha Ngephutha Qalisa Kabusha Okulandelayo 'gcwalisa izinkambu zomlayezo Nge-Outmail .To = Range("A1").Value .Subject = Range("A2"). Inani .Umzimba = Ububanzi("A3").Inani .Okunamathiselwe.Engeza Ububanzi("A4").Inani 'Thumela lingathathelwa indawo Isiboniso ukuze ubuke umlayezo ngaphambi kokuthumela .Thumela Qeda Ngephutha Ngephutha GoTo 0 Setha I-Outmail = Nothing cleanup : Setha i-OutApp = Nothing Application.ScreenUpdating = I-True End Sub

Ikheli, isihloko, umbhalo womlayezo kanye nendlela eya efayeleni elinamathiselwe kufanele kube kumaseli A1:A4 eshidi lamanje.

  • Iqembu Lemeyili elisuka ku-Excel Ngesengezo se-PLEX
  • Amamakhro okuthumela i-imeyili esuka ku-Excel nge-Lotus Notes ka-Dennis Wallentin
  • Ayini ama-macro, lapho ungafaka khona ikhodi enkulu ku-Visual Basic
  • Ukudala ama-imeyili ngomsebenzi we-HYPERLINK

 

shiya impendulo