Kutumiza buku kapena pepala ndi imelo

Ngati nthawi zambiri mumayenera kutumiza mabuku kapena mapepala ena kudzera pa imelo, ndiye kuti muyenera kuzindikira kuti njirayi singatchulidwe mofulumira. Ngati mukuchita "classically", muyenera:

  • tsegulani pulogalamu ya imelo (mwachitsanzo, Outlook)
  • pangani uthenga watsopano
  • lembani adilesi, mutu ndi mawu
  • phatikizani fayilo ku uthengawo (musaiwale!)
  • dinani batani kutumiza

M'malo mwake, makalata amatha kutumizidwa mosavuta kuchokera ku Excel m'njira zosiyanasiyana. Pitani…

Njira 1: Ophatikizidwa Tumizani

Ngati mudakali ndi Excel 2003 yakale yabwino, ndiye kuti zonse ndi zophweka. Tsegulani buku/tsamba lomwe mukufuna ndikusankha kuchokera pamenyu Fayilo - Tumizani - Uthenga (Fayilo - Tumizani Kwa - Wolandira Imelo). Zenera lidzatsegulidwa momwe mungasankhire imodzi mwa njira ziwiri zotumizira:

Pachiyambi choyamba, bukhu lamakono lidzawonjezedwa ku uthengawo ngati cholumikizira, kachiwiri, zomwe zili mu pepala lamakono zidzalowa mwachindunji muzolemba zauthenga monga tebulo lolemba (popanda mafomu).

Komanso, menyu Fayilo - Tumizani (Fayilo - Tumizani Ku) pali zinanso zachilendo zotumizira zina:

 

  • Uthenga (kuti muwunikenso) (Wolandila Imelo kuti awunikenso) - bukhu lonse la ntchito limatumizidwa ndipo panthawi imodzimodziyo kusintha kutsata kumatsegulidwa kwa izo, mwachitsanzo, kumayamba kukhazikika bwino - ndani, nthawi ndi ma cell omwe adasintha. Kenako mutha kuwonetsa zosintha zomwe zapangidwa mu menyu Service - Zokonza - Onetsani zosintha (Zida - Tsatani zosintha - Onetsani zosintha) kapena pa tabu Ndemanga - Zowongolera (Unikani - Tsatani Zosintha) Zikuwoneka ngati izi:

    Mafelemu amitundu amawonetsa kusintha komwe kwachitika pachikalatacho (wogwiritsa ntchito aliyense ali ndi mtundu wosiyana). Mukayendetsa mbewa, zenera lokhala ngati cholembera limatuluka ndikufotokozera mwatsatanetsatane za ndani, chiyani komanso nthawi yomwe asinthidwa mu cell iyi. Ndikosavuta kuwunikanso zikalata, mwachitsanzo, mukasintha lipoti la omwe ali pansi panu kapena abwana akusintha lanu.

  • Panjira (Wolandila Njira) - uthenga womwe bukhu lanu lidzalumikizidwa lidzadutsa mumndandanda wa olandira, omwe aliyense adzawatumizira mowonjezereka, ngati ndodo. Ngati mungafune, mutha kukhazikitsa uthengawo kuti ubwerere kwa inu kumapeto kwa unyolo. Mutha kuloleza kutsata kosintha kuti muwone zosintha zomwe munthu aliyense mu ulusiwo.

Mu Excel 2007/2010 yatsopano, zinthu ndizosiyana pang'ono. M'matembenuzidwe awa, kuti mutumize bukhulo ndi makalata, muyenera kusankha batani Office (Batani la Office) kapena tabu file (Fayilo) ndi timu kutumiza (Tumizani). Pambuyo pake, wogwiritsa ntchitoyo amapatsidwa njira zotumizira:

Chonde dziwani kuti m'matembenuzidwe atsopano, kuthekera kotumiza pepala losiyana la bukhu loyikidwa mu thupi la kalatayo kwasowa - monga momwe zinaliri mu Excel 2003 ndi pambuyo pake. Njira yokhayo yomwe yatsala ndikutumiza fayilo yonse. Koma panali mwayi wothandiza kutumiza mumtundu wodziwika bwino wa PDF ndi XPS yosadziwika bwino (yofanana ndi PDF, koma safuna kuti Acrobat Reader iwerenge - imatsegula mwachindunji Internet Explorer). Lamulo lotumiza buku kuti likawunikenso litha kutulutsidwa ngati batani lowonjezera pagawo lofikira mwachangu kudzera Fayilo - Zosankha - Chida Chofikira Mwamsanga - Malamulo Onse - Tumizani Kuti Muwunikenso (Fayilo - Zosankha - Chida Chofikira Mwamsanga - Malamulo Onse - Tumizani Kuti Muwunikenso).

Njira 2. Ma macros osavuta kutumiza

Kutumiza macro ndikosavuta. Kutsegula Visual Basic Editor kudzera pa Menyu Utumiki - Macro - Visual Basic Editor (Zida - Macro - Visual Basic Editor), ikani gawo latsopano mu menyu Ikani - Module ndikukopera zolemba za macros awiriwa pamenepo:

Sub SendWorkbook() ActiveWorkbook.SendMail Recipients:="[email protected]", Mutu:="Лови файлик" End Sub SendSheet() ThisWorkbook.Sheets("Лист1").Koperani Ndi ActiveWorkbook .SendMail Recipients:="[imelo chitetezo]", Mutu:="Gwirani fayilo" .Close SaveChanges:=Mapeto Onama Ndi Mapeto a Sub

Pambuyo pake, ma macros omwe adakopera amatha kuyendetsedwa mumenyu Utumiki - Macro - Macros (Zida - Macro - Macros). SendWorkbook amatumiza bukhu lonse lamakono ku adiresi yotchulidwa, ndi SendSheet - Tsamba 1 ngati cholumikizira.

Mukayendetsa macro, Excel ilumikizana ndi Outlook, zomwe zipangitsa kuti uthenga wotetezedwa uwonekere pazenera:

Dikirani mpaka batani kuthetsa imagwira ntchito ndikudina kuti mutsimikizire zomwe mwatumiza. Pambuyo pake, mauthenga opangidwa okha adzaikidwa mufoda Kutuluka ndipo idzatumizidwa kwa olandira nthawi yoyamba mukayamba Outlook kapena, ngati muli nayo, nthawi yomweyo.

Njira 3. Universal macro

Ndipo ngati mukufuna kutumiza osati buku lapano, koma fayilo ina iliyonse? Ndipo mawu a uthengawo angakhalenso abwino kuyika! Ma macros am'mbuyomu sangathandize pano, chifukwa ali ndi malire ndi kuthekera kwa Excel palokha, koma mutha kupanga macro omwe angayang'anire Outlook kuchokera ku Excel - pangani ndikudzaza zenera latsopano la uthenga ndikutumiza. Ma macro amawoneka motere:

Sub SendMail() Dim OutApp As Object Dim OutMail As Object Dim cell As Range Application.ScreenUpdating = False Set OutApp = CreateObject("Outlook.Application") 'yambitsani Outlook munjira yobisika OutApp.Session.Logon On Error GoTo cleanp' anayamba - tulukani Set OutMail = OutApp.CreateItem(0) 'pangani uthenga watsopano Pa Vuto Liyambirenso Kenako ' lembani minda ya uthenga Ndi OutMail .To = Range("A1").Value .Subject = Range("A2"). Mtengo : Set OutApp = Nothing Application.ScreenUpdating = True End Sub

Adilesi, mutu, mawu a uthengawo ndi njira yopita ku fayilo yolumikizidwa ziyenera kukhala m'maselo A1: A4 a pepala lapano.

  • Kutumiza kwa Gulu kuchokera ku Excel ndi PLEX Add-in
  • Macros potumiza makalata kuchokera ku Excel kudzera pa Lotus Notes wolemba Dennis Wallentin
  • Kodi macros ndi chiyani, komwe mungayike macro code mu Visual Basic
  • Kupanga maimelo ndi ntchito ya HYPERLINK

 

Siyani Mumakonda