Idan sau da yawa kuna aika wasu littattafai ko zanen gado ta imel, to ya kamata ku lura cewa ba za a iya kiran wannan hanyar da sauri ba. Idan kun yi shi "classically", to kuna buƙatar:
- bude shirin imel (misali, Outlook)
- haifar da sabon sako
- rubuta a adireshin, batun da rubutu
- haɗa fayil zuwa saƙon (kar a manta!)
- danna maballin Aika
A zahiri, ana iya aika wasiku cikin sauƙi kai tsaye daga Excel ta hanyoyi daban-daban. Tafi…
Hanyar 1: Ƙaddamar da Aika
Idan har yanzu kuna da kyakkyawar tsohuwar Excel 2003, to komai yana da sauƙi. Bude littafin da ake so kuma zaɓi daga menu Fayil - Aika - Saƙo (Fayil - Aika Zuwa - Mai karɓar Saƙo). Wani taga zai buɗe wanda a ciki zaku iya zaɓar ɗayan zaɓuɓɓuka biyu don aikawa:
A cikin akwati na farko, za a ƙara littafin na yanzu zuwa saƙon a matsayin abin da aka makala, a cikin akwati na biyu, abubuwan da ke cikin takardar yanzu za su shiga cikin saƙon kai tsaye a matsayin tebur na rubutu (ba tare da tsari ba).
Bugu da kari, menu Fayil - Gabatarwa (Fayil - Aika Zuwa) akwai ƴan ƙarin zaɓuɓɓukan jigilar kaya:
- Sako (don dubawa) (Mai karɓar wasiku don dubawa) - An aika dukan littafin aikin kuma a lokaci guda an kunna canjin canji don shi, watau fara gyarawa a fili - wanda, lokacin da kuma a cikin abin da sel suka yi canje-canje. Hakanan zaka iya nuna canje-canjen da aka yi a cikin menu Sabis - Gyarawa - Haskaka gyare-gyare (Kayan aiki - Canje-canje - Canje-canje na Haskakawa) ko a kan tab Bita - Gyaran baya (Bincika - Bibiyan Canje-canje) Zai yi kama da wani abu kamar haka:
Firam masu launi suna alamar canje-canjen da aka yi ga takaddar (kowane mai amfani yana da launi daban-daban). Lokacin da kake shawagi linzamin kwamfuta, taga mai kama da bayanin kula yana buɗewa tare da cikakken bayanin wanda, menene da lokacin da aka canza a cikin wannan tantanin halitta. Yana da matukar dacewa don duba takardu, lokacin da, alal misali, kuka gyara rahoton ma'aikatan ku ko shugaba ya gyara naku.
- Tare da hanya (Mai Karɓi Hanyar Hanya) – sakon da za a makala littafinka zai bi ta cikin jerin masu karba, kowannensu zai kara tura shi kai tsaye, kamar sanda. Idan ana so, zaku iya saita saƙon don komawa gare ku a ƙarshen sarkar. Kuna iya kunna canjin bin diddigin don ganin gyare-gyaren da kowane mutum yayi a cikin zaren.
A cikin sabon Excel 2007/2010, yanayin ya ɗan bambanta. A cikin waɗannan nau'ikan, don aika littafin ta wasiƙa, kuna buƙatar zaɓar maɓallin Office (Maɓallin Ofishin) ko tab fayil (Fayil) da tawagar Aika (Aika). Bayan haka, ana ba mai amfani da saitin zaɓuɓɓukan aikawa:
Lura cewa a cikin sababbin sigogin, ikon aika wani takarda daban na littafin aikin da aka saka a jikin wasiƙar ya ɓace - kamar yadda yake a cikin Excel 2003 kuma daga baya. Zaɓin da ya rage shi ne aika duk fayil ɗin. Amma akwai wata dama mai amfani don aikawa a cikin sanannun tsarin PDF da ƙananan sanannun XPS (mai kama da PDF, amma baya buƙatar Acrobat Reader don karantawa - yana buɗewa kai tsaye a cikin Internet Explorer). Ana iya fitar da umarnin don aika littafi don bita azaman ƙarin maɓalli akan rukunin shiga cikin sauri ta Fayil - Zaɓuɓɓuka - Wurin Kayan aiki na Samun Sauri - Duk Umarni - Aika don Bita (Fayil - Zaɓuɓɓuka - Toolbar Samun Sauri - Duk Saƙonni - Aika don Bita).
Hanyar 2. Sauƙaƙe macros don aikawa
Aika macro ya fi sauƙi. Buɗe Editan Kayayyakin Kayayyakin Kayayyakin Ta hanyar Menu Sabis – Macro – Kayayyakin Basic Edita (Kayan aiki - Macro - Editan Kayayyakin Kayayyakin gani), saka sabon tsarin a cikin menu Saka - Module da kwafi rubutun waɗannan macro guda biyu a wurin:
Sub SendWorkbook() ActiveWorkbook.SendMail Masu karɓa: = "[email protected]", Maudu'i: = " Лови файлик" Ƙarshen Sub SendSheet() Wannan Littafin Aikin.Sheets("Лист1"). Kwafi Tare da ActiveWorkbook .SendMail Masu karɓa:="[email] kiyayewa]", Taken: = "Kama fayil ɗin" .Rufe SaveChanges: = Ƙarshen Ƙarshe Tare da Ƙarshen Ƙarshe Bayan haka, ana iya gudanar da macro da aka kwafi a cikin menu Sabis - Macro - Macros (Kayan aiki - Macro - Macros). Aika Littafin Aiki aika dukan littafin na yanzu zuwa ƙayyadadden adireshin, kuma Aika Sheet - Sheet1 azaman abin da aka makala.
Lokacin da kake gudanar da macro, Excel zai tuntuɓi Outlook, wanda zai sa saƙon tsaro ya bayyana akan allon:
Jira har sai maɓallin warware ya zama mai aiki kuma danna shi don tabbatar da ƙaddamarwa. Bayan haka, saƙonnin da aka samar ta atomatik za a sanya su cikin babban fayil ɗin fita kuma za a aika zuwa masu karɓa a karon farko da ka fara Outlook ko, idan kana da shi yana gudana, nan da nan.
Hanyar 3. Universal macro
Kuma idan kana so ka aika ba na yanzu littafin, amma wani fayil? Kuma rubutun saƙon ma zai yi kyau a saita! Macros na baya ba zai taimaka a nan ba, saboda an iyakance su ta hanyar iyawar Excel kanta, amma zaka iya ƙirƙirar macro wanda zai sarrafa Outlook daga Excel - ƙirƙira da cika sabon taga sakon kuma aika shi. Macro yayi kama da haka:
Sub SendMail() Dim OutApp As Abu Dim OutMail As Object Dim cell As Range Application.ScreenUpdating = Ƙarya Saitin OutApp = CreateObject("Outlook.Application") 'fara Outlook a cikin yanayin ɓoye OutApp.Session.Logon Kan Kuskure GoTo tsaftacewa' idan ba haka ba. fara - fita Saita OutMail = OutApp.CreateItem(0) 'ƙirƙiri sabon saƙo Akan Kuskure Ci gaba Na gaba'cika filayen saƙon Tare da OutMail .To = Range("A1").Value .Subject = Range("A2"). Darajar .Jiki = Range("A3").Mai daraja .Haɗe-haɗe.Ƙara Range("A4").Za'a iya maye gurbin ƙimar' Aika da Nuni don duba saƙon kafin aika .Aika Ƙare Tare da Kuskure GoTo 0 Saita OutMail = Babu wani abu mai tsabta : Saita OutApp = Babu wani abu Aikace-aikace.ScreenUpdating = Gaskiya Karshen Sub Adireshin, batun, rubutun saƙon da hanyar zuwa fayil ɗin da aka haɗe dole ne su kasance a cikin sel A1: A4 na takardar yanzu.
- Saƙon rukuni daga Excel tare da PLEX Add-in
- Macros don aika wasiku daga Excel ta hanyar Lotus Notes na Dennis Wallentin
- Menene macros, inda za a saka macro code a cikin Visual Basic
- Ƙirƙirar imel tare da aikin HYPERLINK