Indlela yokuthumela ama-imeyili ngqo kusuka ku-Excel

Indlela yokuthumela ama-imeyili ngqo kusuka ku-Excel Kukongela isikhathi esiningi uma uzinikela ekusebenzeni nsuku zonke ngalolu hlelo futhi uthumela imiphumela yalo. Ngo-2024, i-Excel isibe elinye lamathuluzi e-Microsoft Office asetshenziswa kakhulu, emsebenzini nasezingeni lomuntu siqu, nakuba ikakhulukazi esimweni sokuqala. I-Excel iyithuluzi elihle elingakusiza ngemisebenzi yansuku zonke nokunye okuningi.

Ngakho-ke, uma uke wazibuza cUngawathumela kanjani ama-imeyili ngqo kusuka ku-Excel kusuka Tecnobits Sizokuphendula ngomhlahlandlela noma indatshana yokufundisa lapho uzofunda ukuthi ungakwenza kanjani ukuze wonge futhi wandise isikhathi sakho sansuku zonke yomsebenzi. Sizochaza isinyathelo ngesinyathelo indlela yokwenza futhi njengoba sisho, uzokonga isikhathi nomzamo ekuthumeleni umsebenzi okhiqizwe ku-Excel. Ake siye lapho nesihloko. 

Izinzuzo zokuthumela ama-imeyili kusuka ku-Excel

Ngoba uma usufinyelele lesi sihloko kungenxa yokuthi ukholelwa ukuthi ukufunda ku Ungawathumela kanjani ama-imeyili usuka ku-Excel uzokunikeza izinzuzo ezithile, futhi iyakwenza lokho. Sizobeka amazwana kuzo ngezansi, nakuba sicabanga ukuthi ziyilokho obukulindele, ngoba yonke into ku-Excel Ibiyela ekwenziweni kahle kwesikhathi nokusebenza kahle. 

• Yenza inqubo ngokuzenzakalelayo: Into evamile ukuthi uma usebenzisa i-Excel ezingeni lomsebenzi uphatha amanani amakhulu kakhulu edatha futhi, njengomthetho ojwayelekile, eyinkimbinkimbi. Bangaphuma ohlwini lwabathintwayo ukuze bathengiswe, ulwazi ngabo nokunye okuningi. Nge-automation ye-imeyili uzokwazi, njengoba kusho igama, ukushiya konke okulungisiwe futhi kuthunyelwe ngokuzenzakalelayo.
• Ukwenza ngokwezifiso i-imeyili- Enza ngendlela oyifisayo ama-imeyili ayo yonke imininingwane egciniwe onayo ku-Excel. Uzokwazi ukwengeza izinto ezincane ezikhishwe kumaspredishithi akho e-Excel. Uma ubucabanga ukuthi ukufunda ukuthumela ama-imeyili ngokuqondile kusuka ku-Excel akuhambisani nokwenza kube ngokwakho, unephutha.
• Ukusebenza kahle kanye nokwenza kahle- Lungiselela ukuhamba kwakho komsebenzi futhi usebenze kahle. Uzoqeda izinyathelo eziningi zangaphambilini ezizokunikeza imisebenzi eyengeziwe noma ukuchitha isikhathi. Khohlwa ngokunamathisela nokukopisha ulwazi kusuka endaweni eyodwa kuya kwenye ngaphandle kokuma. Ngokushesha lapho ufunda laphaIndlela yokuthumela ama-imeyili ngokuqondile ukusuka ku-Excel izoshiya yonke into ngendlela ephumelela kakhulu ngangokunokwenzeka. 

Thumela ama-imeyili kusuka ku-Excel: umhlahlandlela wesinyathelo ngesinyathelo

 

Futhi manje, isikhathi esimaphakathi obusilindile sesifikile, lapho ufunda ngasoUngawathumela kanjani ama-imeyili usuka ku-Excel. Sizokuchazela ukuthi sikholelwa kukho Tecnobits que son izindlela ezingcono kakhulu futhi ngaphezu kwakho konke kulula ukuyisebenzisa. Njengoba ukusebenzisa i-Visual Basics For Applications kungekona okwawo wonke umuntu, sizophinde sikunikeze enye lapho kuzobe kusetshenziswa isengezo se-Excel kuphela. Uyanquma ukuthi iyiphi oyigcinayo. 

Isisekelo esibonakalayo sezinhlelo zokusebenza zokuthumela ama-imeyili ku-Excel

 

Kungase kube okuyinkimbinkimbi kakhulu, kodwa sizozama ukukuhlephula kancane kancane ukuze ukuqonde. I-VBA i Ithuluzi lokuhlela elidume kakhulu futhi lihlanganiswe ne-Microsoft Office. Ukuze ufunde laphaUngawathumela kanjani ama-imeyili usuka ku-Excel nge-VBA, landela lezi zinyathelo: 

1. Yenza kusebenze ithebhu kanjiniyela: Kuzodingeka uvule i-Microsoft Excel bese uye kokuthi "ifayela". Manje yiya kokuthi "izinketho" bese ungene lapho uye kumenyu engakwesokunxele bese ukhetha "iribhoni ngokwezifiso". Ngemuva kwalokhu, vula ibhokisi elithi "unjiniyela" futhi wamukele konke.
2. Vula Izinhlelo zokusebenza Ezibonakalayo Eziyisisekelo: Ungayivula ngokuqondile ngesinqamuleli sekhibhodi i-Alt + F11 futhi uma kungenjalo, ungaya kuthebhu "kanjiniyela" futhi ukuze uyivule. Manje ngaphakathi kwe-VBA khetha "faka" bese uchofoza "module"
3. Bhala ikhodi esikushiyela yona ngezansi bese uyiqhuba: Uma usukwenzile, buyela ku-Excel bese ucindezela u-Alt + F8 ukuze uvule "ama-macros."

I-Sub SendMailFromExcel()
Nciphisa i-OutlookApp Njengento
Nciphisa Imeyili Njengento
Dim i As Integer
Fiphalisa Ishidi Njengeshidi Lokusebenzela
Setha Ishidi = ThisWorkbook.AmaSpredishithi(«Ishidi1») 'Qinisekisa ukuthi igama leshidi lilungile

Setha i-OutlookApp = CreateObject("Outlook.Application")

Kwa i = 2 Kushidi.Amaseli(Sheet.Rows.Count, 1).End(xlUp).Row
Setha Imeyili = OutlookApp.CreateItem(0)
Ngemeyili
.Ku = Ishidi.Amaseli(i, 1).Inani 'Ikholomu A iqukethe amakheli e-imeyili
.Isihloko = “Isihloko semeyili”
.Body = «Sawubona » & Sheet.Cells(i, 2).Value & «,» & vbNewLine & «Lena i-imeyili ezenzakalelayo evela ku-Excel.»
.Thumela
End With
Next i

Setha i-OutlookApp = Akukho lutho
Setha Imeyili = Akukho
End Sub

Manje uma ulandele lezi zinyathelo manje usuzoba nenketho yokusebenzisa i-macro. Ngemuva kokuya ku-Alt + F8 kuzodingeka ukhethe i-macro "Thumela imeyili kusuka ku-Excel" bese uyiqhuba. Uma usufike lapha usuvele unendlela yokuqala yokufunda ukuthumela ama-imeyili ngqo kwa-Excel.

Thumela ama-imeyili kusuka ku-Excel usebenzisa isengezo

Njengoba sesishilo, eyedlule ingaba yinkimbinkimbi kakhulu ngenxa yokuthi bekufanele ufake ikhodi, kodwa bekuwukukopisha nokunamathisela bese wenza i-macro. Yilokho leyo ndlela eyabiliswa kukho futhi ubuyobe usufundile kakade ukuthi ungathumela kanjani ama-imeyili usuka ku-Excel. Ngale ndlela kuzodingeka faka isengezo se-Excel, Ungakhathazeki, kulula.

Nakhu izesekeli ezimbili edume kakhulu ongayilanda esitolo seMicrosoft, kunjalo Mail Merge Toolkit esebenza ne-Outlook, kanye Ablebits, okuhlanganisa namathuluzi ahlukene okuthumela ama-imeyili aqondene nawe ukuze ukwazi kakade ukuthi uwathumela kanjani ama-imeyili usuka ku-Excel.

Njengoba sikutshela, kuzodingeka uye kumawebhusayithi abo asemthethweni noma iwebhusayithi ye-Microsoft futhi uwalande futhi uwafake. Landela imiyalelo yokufaka neyokumisa. Uma usukwenzile, faka i-Excel futhi uzobona lokho Ungakhetha abamukeli, ulwazi nenye idatha ukuze uthumele ama-imeyili. Ngale ndlela ufunde enye indlela yokwazi ukuthumela ama-imeyili ngokuqondile kusuka ku-Excel.

Okokugcina, khumbula ukuthi ku Tecnobits tenemos inqwaba yeziqondiso ku-Excel, isibonelo yilesi esimayelana ungayisusa kanjani imigqa engenalutho ku-excel isinyathelo ngesinyathelo, noma futhi Sebenzisa i-AI ku-Excel ukuze ubale amafomula ngokunembile nalula. Sithemba ukuthi manje usufundile ukuthi uwathumela kanjani ama-imeyili usuka ku-Excel