Maitiro ekutumira maemail zvakananga kubva kuExcel

Maitiro ekutumira maemail zvakananga kubva kuExcel Inokuchengetedza nguva yakawanda kana iwe ukazvipira kushanda zuva nezuva nepurogiramu iyi uye kutumira migumisiro yayo. Muna 2024, Excel yave imwe yeanonyanya kushandiswa eMicrosoft Office maturusi, ese kubasa uye pachedu nhanho, kunyangwe kunyanya mune yekutanga kesi. Excel chishandiso chakanakisa chinogona kukubatsira iwe nemabasa ezuva nezuva uye zvimwe zvakawanda.

Naizvozvo, kana wakazvibvunza iwe cMaitiro ekutumira maemail zvakananga kubva kuExcel kubva Tecnobits Isu tichakupindura negwara kana chinyorwa chekudzidzisa umo iwe unozodzidza kuzviita kuitira kuti iwe uchengetedze uye uwedzere nguva yako yezuva nezuva zvebasa. Isu tichatsanangura nhanho nhanho maitirwo uye sekutaura kwatinoita, iwe uchachengetedza nguva nesimba mukutumira basa rakagadzirwa kubva kuExcel. Handei ikoko nechinyorwa. 

Zvakanakira kutumira maemail kubva kuExcel

Nekuti kana wasvika pachinyorwa ichi imhaka yekuti unotenda kuti kudzidza Maitiro ekutumira maemail zvakananga kubva kuExcel anokupa mamwe mabhenefiti, uye zvinoita. Isu tichataura pamusoro pavo pazasi, kunyangwe isu tichifungidzira kuti ndizvo zvawaitarisira, nekuti zvese zviri muExcel Iyo inowira pasi kune nguva optimization uye kunyatsoshanda. 

• Automate maitiro: Chinhu chakajairika ndechekuti kana ukashandisa Excel padanho rebasa iwe unobata yakawanda kwazvo yedata uye, seyakajairwa mutemo, yakaoma. Vanogona kubva kune mazita mazita ekugona kutengesa, ruzivo pamusoro pavo uye nezvimwe zvakawanda. Neemail otomatiki iwe unozogona, sekutaura kunoita izwi, kusiya zvese zvakagadzirirwa uye kuti zvitumire otomatiki.
• Email customization-Gadzirisa maemail kune iyo database yese yaunayo muExcel. Iwe unozogona kuwedzera zvinhu zvidiki zvakabviswa kubva kune yako Excel spreadsheets. Kana iwe waifunga kuti kudzidza kutumira maemail zvakananga kubva kuExcel kwaisaenderana nehunhu, wakarasika.
• Kubudirira uye optimization-Gadzirisa mafambiro ako uye nyatsoita. Iwe unobvisa akawanda ekare matanho anokupa mamwe mabasa kana kutambisa nguva. Kanganwa nezve kunamira uye kukopa ruzivo kubva kune imwe nzvimbo kuenda kune imwe pasina kumira. Ukangodzidza panoMaitiro ekutumira maemail zvakananga kubva kuExcel anosiya zvese nenzira inoshanda zvakanyanya. 

Tumira maemail kubva kuExcel: nhanho-ne-nhanho gwara

 

Uye zvino, nguva yepakati yawanga wakamirira yasvika, kwaunodzidza nezvayoMaitiro ekutumira maemail zvakananga kubva kuExcel. Tiri kuzokutsanangurirai zvatinotenda kubva Tecnobits que son nzira dzakanakisa uye pamusoro pezvose zviri nyore kushandisa. Sezvo kushandisa Visual Basics For Applications isiri yemunhu wese, isu tiri kuzokupa imwe imwe apo inenge ichingoshandisa yekuwedzera-mukati yeExcel. Iwe sarudza kuti ndeupi wauchachengeta. 

Visual basic yeMaapplication ekutumira maemail muExcel

 

Zvingave zvakanyanya kuomarara, asi isu tichaedza kukuparura iwe zvishoma nezvishoma kuti uzvinzwisise. VBA ari Yakanyanya kufarirwa programming chishandiso uye yakabatanidzwa muMicrosoft Office. Kuti udzidze panoMaitiro ekutumira maemail zvakananga kubva kuExcel neVBA, tevera matanho aya: 

1. Shandisa iyo developer tab: Iwe uchafanirwa kuvhura Microsoft Excel uye enda ku "faira". Zvino enda ku "sarudzo" uye imomo enda kune kuruboshwe menyu uye sarudza "customize ribhoni". Mushure meizvi, shandisa bhokisi re "developer" uye gamuchira zvose.
2. Vhura Visual Basic Applications: Iwe unogona kuivhura zvakananga nekhibhodi yekudimbudzira Alt + F11 uye kana zvisiri, unogona kuenda kune "mugadziri" tab zvakare kuti uivhure. Zvino mukati meVBA sarudza "insert" uye wobva wadzvanya pa "module"
3. Nyora kodhi yatinokusiira pazasi woimhanyisa: Kana wangodaro, dzokera kuExcel uye wodzvanya Alt + F8 kuvhura "macros."

Sub SendMailFromExcel()
Dim OutlookApp sechinhu
Dim Mail Sechinhu
Dim i As Integer
Dim Sheet SePepa Rekushanda
Set Sheet = ThisWorkbook.Sheets(«Sheet1») 'Iva nechokwadi chokuti zita repepa rakarurama

Seta OutlookApp = GadziraObject("Outlook.Application")

For i = 2 To Sheet.Masero(Sheet.Rows.Count, 1).End(xlUp).Row
Seta Tsamba = OutlookApp.CreateItem(0)
Netsamba
.Kuti = Sheet.Masero(i, 1).Kukosha 'Column A ine kero dzeemail
.Chinyorwa = “Chinyorwa chetsamba”
.Body = «Mhoro » & Sheet.Masero(i, 2).Kukosha & «,» & vbNewLine & «Iyi iemail yakazvimiririra kubva kuExcel.»
.Send
Gumira Na
Inotevera ini

Seta OutlookApp = Hapana
Seta Mail = Hapana
Chikamu Chekupedzisira

Zvino kana iwe wakatevera matanho aya uchave nesarudzo yekumhanyisa macro. Mushure mekuenda kuAlt + F8 uchafanirwa kusarudza iyo macro "Tumira tsamba kubva kuExcel" uye imhanye. Kana iwe wasvika kure watova nekutanga nzira yekudzidza kutumira maemail zvakananga kubva kuExcel.

Tumira maemail kubva kuExcel uchishandisa yekuwedzera-mukati

Sezvatataura, iyo yapfuura inogona kuomesesa nekuda kwekuti iwe waifanira kuisa iyo kodhi, asi yaingove kukopa nekuisa uye kuita macro. Ndizvo zvakabikwa nenzira iyoyo uye ungadai wakatodzidza kutumira maemail zvakananga kubva kuExcel. Neiyi nzira iwe uchafanirwa isa iyo Excel yekuwedzera-mukati, Usanetseka, zviri nyore.

Pane zvinhu zviviri ane mukurumbira waunogona kudhawunirodha kubva kuMicrosoft chitoro, ivo Mail Merge Toolkit iyo inoshanda neOutlook, uye Ablebits, iyo inosanganisirawo maturusi akasiyana ekutumira maemail emunhu saka iwe unotoziva kutumira maemail zvakananga kubva kuExcel.

Sezvatinokuudza, iwe uchafanirwa kuenda kune avo akasiyana epamutemo mawebhusaiti kana iyo Microsoft webhusaiti uye kudhawunirodha nekuiisa. Tevedzera kugadzwa uye kumisikidza mirairo. Kana wangozviita, pinda muExcel uye iwe uchaona izvozvo Iwe unogona kusarudza vanogamuchira, ruzivo uye imwe data kuitira kutumira maemail. Nenzira iyi wakadzidza imwe nzira yekuziva kutumira maemail zvakananga kubva kuExcel.

Pakupedzisira, chiyeuchidze kuti mukati Tecnobits tenemos akawanda madhairekitori paExcel, muenzaniso ndeuyu pamusoro nzira yekudzima mitsetse isina chinhu muExcel nhanho nenhanho, kana zvakare mberi Shandisa AI muExcel kuverenga mafomula nenzira kwayo uye nyore. Tinovimba kuti wadzidza ikozvino kutumira maemail zvakananga kubva kuExcel