Yog tias koj feem ntau yuav tsum xa tawm qee cov phau ntawv lossis nplooj ntawv los ntawm e-mail, ces koj yuav tsum tau pom tias cov txheej txheem no tsis tuaj yeem hu sai. Yog tias koj ua nws "classically", ces koj xav tau:
- qhib ib qho email program (piv txwv li, Outlook)
- tsim cov lus tshiab
- ntaus hauv qhov chaw nyob, cov ntsiab lus thiab cov ntawv nyeem
- xa ib cov ntaub ntawv rau cov lus (tsis txhob hnov qab!)
- nyem lub pob Xa
Qhov tseeb, xa ntawv tuaj yeem yooj yim xa ncaj qha los ntawm Excel hauv ntau txoj kev sib txawv. Mus…
Txoj Kev 1: Embedded Xa
Yog tias koj tseem muaj qhov zoo qub Excel 2003, ces txhua yam yooj yim. Qhib cov ntawv xav tau / ntawv thiab xaiv los ntawm cov ntawv qhia zaub mov Cov ntaub ntawv – Xa – Lus (File — Xa rau — Mail Recipient). Lub qhov rais yuav qhib uas koj tuaj yeem xaiv ib qho ntawm ob qho kev xaiv xa:
Hauv thawj kis, phau ntawv tam sim no yuav muab ntxiv rau cov lus raws li qhov txuas, hauv qhov thib ob, cov ntsiab lus ntawm daim ntawv tam sim no yuav ncaj qha mus rau hauv cov ntawv xov xwm raws li lub rooj ntawv (tsis muaj qauv).
Ntxiv rau, cov ntawv qhia zaub mov File – Xa (Cov ntaub ntawv - Xa rau) muaj ob peb yam txawv txawv shipping xaiv:
- Message (rau kev tshuaj xyuas) (Tus neeg txais ntawv xa tuaj rau kev tshuaj xyuas) - tag nrho phau ntawv ua haujlwm raug xa mus thiab tib lub sijhawm hloov pauv kev taug qab yog qhib rau nws, piv txwv li pib kho kom meej - leej twg, thaum twg thiab nyob rau hauv lub hlwb ua li cas hloov. Tom qab ntawd koj tuaj yeem tso saib cov kev hloov pauv hauv cov ntawv qhia zaub mov Kev Pabcuam – Fixes – Highlight fixes (Cov cuab yeej - Taug qab kev hloov pauv - Qhia qhov hloov pauv) los yog ntawm lub tab Tshuaj xyuas – Kho (Reveiw — Track Changes) Nws yuav zoo li tej yam zoo li no:
Xim thav duab cim kev hloov pauv rau daim ntawv (txhua tus neeg siv muaj xim sib txawv). Thaum koj hover tus nas, lub qhov rai zoo li lub qhov rai pops nrog cov lus piav qhia ntxaws txog leej twg, dab tsi thiab thaum twg hloov pauv hauv lub xov tooj ntawm tes no. Nws yog qhov yooj yim heev rau kev tshuaj xyuas cov ntaub ntawv, thaum, piv txwv li, koj kho cov ntawv tshaj tawm ntawm koj cov subordinates lossis tus thawj coj kho koj li.
- Raws li txoj kev (Routing Recipient) - Cov lus uas koj phau ntawv yuav txuas mus yuav dhau los ntawm cov saw ntawm cov neeg tau txais, txhua tus yuav cia li xa nws mus ntxiv, zoo li rab chais. Yog tias xav tau, koj tuaj yeem teeb tsa cov lus xa rov qab rau koj ntawm qhov kawg ntawm cov saw hlau. Koj tuaj yeem ua kom muaj kev hloov pauv kom pom cov kev hloov kho los ntawm txhua tus neeg hauv xov.
Hauv Excel tshiab 2007/2010, qhov xwm txheej txawv me ntsis. Nyob rau hauv cov versions no, xa phau ntawv los ntawm kev xa ntawv, koj yuav tsum xaiv lub pob chaw ua hauj lwm (Office Khawm) lub tab cov ntaub ntawv (Cov ntaub ntawv) thiab pab neeg Xa (Xa). Tom ntej no, tus neeg siv tau muab cov txheej txheem xa tawm:
Thov nco ntsoov tias hauv cov ntawv tshiab, lub peev xwm xa ib daim ntawv sib cais ntawm phau ntawv ua haujlwm tso rau hauv lub cev ntawm tsab ntawv tau ploj mus - zoo li nws nyob hauv Excel 2003 thiab tom qab ntawd. Txoj kev xaiv sab laug tsuas yog xa tag nrho cov ntaub ntawv. Tab sis muaj lub sijhawm muaj txiaj ntsig zoo los xa hauv hom ntawv PDF paub zoo thiab tsis paub XPS (zoo ib yam li PDF, tab sis tsis xav tau Acrobat Reader nyeem - nws qhib ncaj qha hauv Internet Explorer). Cov lus txib xa ib phau ntawv rau kev tshuaj xyuas tuaj yeem rub tawm los ua ib qho ntxiv khawm ntawm lub vaj huam sib luag ceev nkag ntawm Cov Ntaub Ntawv - Cov Kev Xaiv - Cov Cuab Yeej Siv nrawm - Tag nrho cov lus txib - Xa mus xyuas (Cov Ntaub Ntawv - Cov Kev Xaiv - Kev Nkag Nkag Ceev - Tag Nrho Cov Lus Cog Tseg - Xa rau Kev Ntsuam Xyuas).
Txoj kev 2. Yooj yim macros xa
Xa macro yog yooj yim dua. Qhib Visual Basic Editor ntawm Cov Ntawv Qhia Kev Pabcuam - Macro - Visual Basic Editor (Cov cuab yeej - Macro - Visual Basic Editor), ntxig tus tshiab module rau hauv cov ntawv qhia zaub mov Ntxig - Module thiab luam cov ntawv ntawm ob macros no muaj:
Sub SendWorkbook() ActiveWorkbook.SendMail Recipients:="[email protected]", Subject:="Лови файлик" End Sub Sub SendSheet() ThisWorkbook.Sheets("Лист1").Copy With ActiveWorkbook .SendMail Recipients:="[email tiv thaiv]", Subject:="Catch the file".Kloe SaveChanges:=False End With End Sub Tom qab ntawd, theej macro tuaj yeem khiav hauv cov ntawv qhia zaub mov Kev pabcuam - Macro - Macros (Cov cuab yeej - Macro - Macros). SendWorkbook xa tag nrho phau ntawv tam sim no mus rau qhov chaw nyob, thiab SendSheet - Daim ntawv 1 raws li daim ntawv txuas.
Thaum koj khiav lub macro, Excel yuav hu rau Outlook, uas yuav ua rau cov lus ceeb toom hauv qab no tshwm sim ntawm qhov screen:
Tos kom txog thaum lub khawm Daws ua active thiab nias nws kom paub meej tias koj xa. Tom qab ntawd, cia li generated lus yuav muab tso rau hauv lub nplaub tshev Ntsaws thiab yuav raug xa mus rau cov neeg txais thawj zaug koj pib Outlook lossis, yog tias koj muaj nws khiav, tam sim ntawd.
Txoj kev 3. Universal macro
Thiab yog tias koj xav xa tsis yog phau ntawv tam sim no, tab sis lwm yam ntaub ntawv? Thiab cov ntawv ntawm cov lus kuj yuav zoo rau teeb! Cov macro yav dhau los yuav tsis pab ntawm no, vim tias lawv raug txwv los ntawm lub peev xwm ntawm Excel nws tus kheej, tab sis koj tuaj yeem tsim cov macro uas yuav tswj hwm Outlook los ntawm Excel - tsim thiab sau rau hauv lub qhov rais tshiab thiab xa nws. Lub macro zoo li no:
Sub SendMail() Dim OutApp As Object Dim OutMail As Object Dim Cell As Range Application.ScreenUpdating = False Set OutApp = CreateObject("Outlook.Application") 'pib Outlook nyob rau hauv zais hom OutApp.Session.Logon On yuam kev GoTo cleanup 'yog tsis yog pib - tawm Teem OutMail = OutApp.CreateItem(0) 'tsim cov lus tshiab Ntawm Kev Ua Haujlwm Tsis Txaus Siab Tom ntej 'sau hauv cov lus teb nrog OutMail .To = Range("A1").Value .Subject = Range("A2"). Tus nqi .Body = Range("A3").Value .Attachments.Add Range("A4").Value 'Xa tuaj yeem hloov nrog Zaub los saib cov lus ua ntej xa .Xa Xaus Nrog On Qhov yuam kev GoTo 0 Teem OutMail = Tsis muaj dab tsi ntxuav : Teem OutApp = Nothing Application.ScreenUpdating = True End Sub Qhov chaw nyob, cov ntsiab lus, cov ntawv ntawm cov lus thiab txoj hauv kev rau cov ntaub ntawv txuas yuav tsum yog nyob rau hauv hlwb A1: A4 ntawm daim ntawv tam sim no.
- Pawg xa ntawv los ntawm Excel nrog PLEX Ntxiv-hauv
- Macros xa ntawv los ntawm Excel ntawm Lotus Notes los ntawm Dennis Wallentin
- Dab tsi yog macro, qhov twg los ntxig macro code hauv Visual Basic
- Tsim cov email nrog HYPERLINK muaj nuj nqi