Tse ka Hare
Haeba hangata u tlameha ho romela libuka kapa maqephe a itseng ka e-mail, joale u lokela ho hlokomela hore mokhoa ona o ke ke oa bitsoa ka potlako. Haeba u e etsa "classic", u tla hloka:
- bula lenaneo la lengolo-tsoibila (mohlala, Outlook)
- theha molaetsa o mocha
- tlanya aterese, sehlooho le mongolo
- hokela faele molaetseng (u se lebale!)
- tobetsa konopo romela
Ebile, mangolo a ka romelloa habonolo ho tsoa Excel ka mekhoa e mengata e fapaneng. Eya…
Mokhoa oa 1: Embedded Romela
Haeba u ntse u e-na le Excel 2003 ea khale e ntle, joale tsohle li bonolo. Bula buka/lakane eo u e batlang ebe u khetha ho tsoa ho menu Faele – Romela – Molaetsa (Faele - Romella ho - Moamoheli oa lengolo-tsoibila). Ho tla bula fensetere moo u ka khethang e 'ngoe ea likhetho tse peli tseo u ka li romellang:
Tabeng ea pele, buka ea morao-rao e tla ekeletsoa molaetsa e le sephutheloana, tabeng ea bobeli, litaba tsa leqephe la hona joale li tla kena ka ho toba molaetsa oa molaetsa e le tafole ea mongolo (ntle le liforomo).
Ho feta moo, menu Faele – Romela (Faele - Romella ho) ho na le likhetho tse ling tse 'maloa tse sa tloaelehang tsa likepe:
- Molaetsa (bakeng sa tlhahlobo) (Moamoheli oa Lengolo bakeng sa Tlhahlobo) - buka eohle ea mosebetsi e rometsoe 'me ka nako e ts'oanang phetoho ea phetoho e buletsoe bakeng sa eona, ke hore, e qala ho lokisoa ka ho hlaka - ke mang, neng le ka lisele life tse entseng liphetoho. Joale o ka bonts'a liphetoho tse entsoeng ho menu Tšebeletso - Litokiso - Totobatsa litokiso (Lisebelisoa - Sheba liphetoho - Totobatsa liphetoho) kapa ho tab Tlhahlobo - Litokiso (Sheba - Sheba Liphetoho) E tla shebahala tjena:
Liforeimi tse mebala li tšoaea liphetoho tse entsoeng tokomaneng (mosebelisi e mong le e mong o na le 'mala o fapaneng). Ha u phahamisa mouse, fensetere e kang ea note e hlaha e nang le tlhaloso e qaqileng ea hore na ke mang, eng le hore na o fetotsoe neng ka seleng ena. Ho bonolo haholo bakeng sa ho hlahloba litokomane, ha, ka mohlala, u hlophisa tlaleho ea ba ka tlaase ho uena kapa mookameli a fetola ea hau.
- Tseleng (Moamoheli oa Tsela) - molaetsa oo buka ea hau e tla kopanngoa ho oona o tla feta har'a letoto la baamoheli, 'me e mong le e mong oa bona a tla e fetisetsa ho ea pele, joalo ka molangoana. Haeba o lakatsa, o ka seta molaetsa hore o khutlele ho uena qetellong ea ketane. O ka etsa hore ho lateloe phetoho ho bona liphetoho tse entsoeng ke motho e mong le e mong khoeleng.
Ho Excel 2007/2010 e ncha, boemo bo fapane hanyane. Liphetolelong tsena, ho romela buka ka poso, u lokela ho khetha konopo Office (Konopo ea Ofisi) kapa tab faele (Faele) le sehlopha romela (Romela). Ka mor'a moo, mosebedisi o fuoa khetho ea ho romela:
Ka kopo hlokomela hore liphetolelong tse ncha, bokhoni ba ho romela leqephe le arohaneng la buka ea mosebetsi le kentsoeng 'meleng oa lengolo le nyametse - joalo ka ha ho ne ho le teng ho Excel 2003 le hamorao. Khetho e le 'ngoe feela e setseng ke ho romela faele eohle. Empa ho ne ho e-na le monyetla oa ho romela ka mokhoa o tsebahalang oa PDF le XPS e sa tsejoeng haholo (e tšoanang le PDF, empa ha e hloke Acrobat Reader ho bala - e bula ka ho toba ho Internet Explorer). Taelo ea ho romella buka bakeng sa tlhahlobo e ka ntšoa joalo ka konopo e eketsehileng ho phanele ea phihlello e potlakileng ka Faele - Likhetho - Toolbar ea ho fihlella kapele - Litaelo tsohle - Romella bakeng sa tlhahlobo (Faele — Dikgetho — Toolbar ya ho fihlella kapele — Ditaelo tsohle — Romela bakeng sa Tlhahlobo).
Mokhoa oa 2. Li-macros tse bonolo tsa ho romela
Ho romella macro ho bonolo haholo. Ho bula Visual Basic Editor ka Menu Tšebeletso - Macro - Visual Basic Editor (Lisebelisoa — Macro — Visual Basic Editor), kenya module e ncha ho menu Kenya – Mojule 'me u kopitse mongolo oa li-macros tsena tse peli moo:
Sub SendWorkbook() ActiveWorkbook.SendMail Recipients:="[email protected]", Sehlooho:="Лови файлик" End Sub Sub SendSheet() ThisWorkbook.Sheets("Лист1").Kopitsa Ka ActiveWorkbook .SendMail Recipients:="[email sirelelitsoe]", Sehlooho:="Tšoara faele" .Close SaveChanges:=Qetello e Fosahetseng le End Sub
Ka mor'a moo, li-macros tse kopilitsoeng li ka tsamaisoa ho menu Tšebeletso - Macro - Macros (Lisebelisoa - Macro - Macros). SendWorkbook e romela buka eohle ea morao-rao atereseng e boletsoeng, le SendSheet - Sheet1 e le sephutheloana.
Ha o tsamaisa macro, Excel e tla ikopanya le Outlook, e tla etsa hore molaetsa o latelang oa ts'ireletso o hlahe skrineng:
Ema ho fihlela konopo rarolla e sebetsa ebe o e tobetsa ho netefatsa tlhahiso ea hau. Ka mor'a moo, melaetsa e hlahisoang ka bo eona e tla kenngoa foldareng E tsoang mme e tla romellwa ho baamohedi kgetlo la pele ha o qala Outlook kapa, haeba o e tshwere, hanghang.
Mokhoa oa 3. Universal macro
'Me haeba u sa batle ho romela buka ea morao-rao, empa faele leha e le efe e' ngoe? 'Me mongolo oa molaetsa o tla boela o be monate ho o beha! Li-macro tse fetileng li ke ke tsa thusa mona, kaha li fokotsoe ke bokhoni ba Excel ka boeona, empa u ka etsa macro e tla laola Outlook ho tloha Excel - theha le ho tlatsa fensetere e ncha ea molaetsa ebe u e romela. Macro e shebahala tjena:
Sub SendMail() Dim OutApp As Object Dim OutMail As Object Dim cell As Range Application.ScreenUpdating = False Set OutApp = CreateObject("Outlook.Application") 'qala Outlook ka mokhoa o patiloeng OutApp.Session.Logon On Error GoTo cleanup' haeba ho se joalo. qadile - tsoa Set OutMail = OutApp.CreateItem(0) ' theha molaetsa o mocha Ka Phoso Tsoela Pele E latelang 'tlatsa likarolo tsa molaetsa Ka OutMail .To = Range("A1").Boleng .Subject = Range("A2"). Boleng .Body = Range("A3").Boleng .Attachments.Add Range("A4").Boleng 'Send e ka nkeloa sebaka ke Pontšo ho bona molaetsa pele o romela : Set OutApp = Nothing Application.ScreenUpdating = True End Sub
Aterese, sehlooho, mongolo oa molaetsa le tsela e eang faeleng e khomaretsoeng li tlameha ho ba liseleng tsa A1:A4 tsa leqephe la hajoale.
- Ho romelloa ha Sehlopha ho tsoa Excel le Keketso ea PLEX
- Macros bakeng sa ho romella mangolo ho tsoa Excel ka Lotus Notes ka Dennis Wallentin
- Li-macros ke eng, moo u ka kenyang khoutu ea macro ho Visual Basic
- Ho etsa mangolo-tsoibila ka tšebetso ea HYPERLINK