{"id":4640,"date":"2024-07-16T11:43:38","date_gmt":"2024-07-16T08:43:38","guid":{"rendered":"https:\/\/uzmanposta.com\/blog\/?p=4640"},"modified":"2024-07-16T11:43:40","modified_gmt":"2024-07-16T08:43:40","slug":"excelde-otomatik-mail-gondermek","status":"publish","type":"post","link":"https:\/\/uzmanposta.com\/blog\/excelde-otomatik-mail-gondermek\/","title":{"rendered":"Excel&#8217;de Otomatik Mail G\u00f6ndermek"},"content":{"rendered":"\n<p>Microsoft Excel&#8217;den mail g\u00f6ndermek i\u00e7in yaln\u0131zca birka\u00e7 basit komut dosyas\u0131 gerekir. Bu i\u015flevi elektronik tablolar\u0131n\u0131za ekledi\u011finizde Excel&#8217;de \u00e7ok daha fazlas\u0131n\u0131 ba\u015farabilirsiniz.<\/p>\n\n\n\n<p>Excel makrolar\u0131, \u00e7ok fazla programlama bilgisine ihtiya\u00e7 duymadan VBA komut dosyalar\u0131n\u0131n yapabildi\u011fi \u015feylerin \u00e7o\u011funu yapabilir. VBA, t\u00fcm PC bilgilerinizi i\u00e7eren bir elektronik tablo raporu olu\u015fturmak gibi daha geli\u015fmi\u015f rutinleri uygulaman\u0131za olanak tan\u0131r.<\/p>\n\n\n\n<p>Microsoft Excel&#8217;den mail g\u00f6ndermek i\u00e7in yaln\u0131zca birka\u00e7 basit komut dosyas\u0131 gerekir. Bu i\u015flevi elektronik tablolar\u0131n\u0131za ekledi\u011finizde, Excel&#8217;de \u00e7ok daha fazlas\u0131n\u0131 ba\u015farabilirsiniz.<\/p>\n\n\n\n<p>Excel makrolar\u0131, \u00e7ok fazla programlama bilgisine ihtiya\u00e7 duymadan VBA komut dosyalar\u0131n\u0131n yapabildi\u011fi \u015feylerin \u00e7o\u011funu yapabilir. VBA, t\u00fcm bilgisayar bilgilerinizi i\u00e7eren bir elektronik tablo raporu olu\u015fturmak gibi daha geli\u015fmi\u015f rutinleri uygulaman\u0131za olanak tan\u0131r.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Neden Excel&#8217;den Mail G\u00f6ndermelisiniz?<\/h2>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/uzmanposta.com\/blog\/wp-content\/uploads\/2024\/07\/neden-excelden-mail-gondermelisiniz-1024x576.jpeg\" alt=\"\" class=\"wp-image-4647\" srcset=\"https:\/\/uzmanposta.com\/blog\/wp-content\/uploads\/2024\/07\/neden-excelden-mail-gondermelisiniz-1024x576.jpeg 1024w, https:\/\/uzmanposta.com\/blog\/wp-content\/uploads\/2024\/07\/neden-excelden-mail-gondermelisiniz-300x169.jpeg 300w, https:\/\/uzmanposta.com\/blog\/wp-content\/uploads\/2024\/07\/neden-excelden-mail-gondermelisiniz-768x432.jpeg 768w, https:\/\/uzmanposta.com\/blog\/wp-content\/uploads\/2024\/07\/neden-excelden-mail-gondermelisiniz-750x422.jpeg 750w, https:\/\/uzmanposta.com\/blog\/wp-content\/uploads\/2024\/07\/neden-excelden-mail-gondermelisiniz-1140x641.jpeg 1140w, https:\/\/uzmanposta.com\/blog\/wp-content\/uploads\/2024\/07\/neden-excelden-mail-gondermelisiniz.jpeg 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<p>E-posta g\u00f6ndermek i\u00e7in Excel kullanman\u0131n arkas\u0131ndaki temel neden, \u00e7al\u0131\u015fma saatleriniz boyunca \u00e7ok say\u0131da e-posta g\u00f6ndermeniz gerekti\u011finde s\u00fcreci otomatikle\u015ftirmektir.&nbsp;<\/p>\n\n\n\n<p>\u00d6rne\u011fin, fatura tutarlar\u0131 ile birlikte bir m\u00fc\u015fteri tablosu var ve m\u00fc\u015fterilerin zaman\u0131nda \u00f6deme yapmas\u0131 i\u00e7in bir hat\u0131rlatma g\u00f6ndermeniz gerekiyor.<\/p>\n\n\n\n<p>Excel ve Outlook uygulamalar\u0131 aras\u0131nda gidip gelerek verileri ilkinden ikincisine kopyal\u0131yor ve g\u00f6ndermeniz gereken t\u00fcm e-postalar i\u00e7in ayr\u0131 ayr\u0131 e-posta taslaklar\u0131 m\u0131 haz\u0131rl\u0131yorsunuz?&nbsp;<\/p>\n\n\n\n<p>Bu s\u00fcre\u00e7 \u00e7ok fazla zaman al\u0131r. Bu y\u00fczden e-posta i\u00e7eri\u011finin bir k\u0131sm\u0131 Excel \u00e7al\u0131\u015fma kitab\u0131nda oldu\u011funda, t\u00fcm e-posta g\u00f6nderme s\u00fcrecini otomatikle\u015ftirmek i\u00e7in bir sonraki b\u00f6l\u00fcmde belirtilen y\u00f6ntemleri takip edebilirsiniz.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Excel&#8217;i otomatik raporlar olu\u015fturmak ve bunlar\u0131 e-posta yoluyla g\u00f6ndererek ilgili al\u0131c\u0131lara tek bir t\u0131klamayla zaman\u0131nda teslim edilmesini sa\u011flamak i\u00e7in kullanabilirsiniz.<\/li><li>Ayr\u0131ca, veri analizi veya hesaplamalar\u0131n sonu\u00e7lar\u0131n\u0131 i\u015f arkada\u015flar\u0131n\u0131zla veya m\u00fc\u015fterilerinizle kolayca payla\u015fabilirsiniz.<\/li><li>Excel&#8217;i her zaman toplant\u0131lar, randevular veya son tarihler i\u00e7in hat\u0131rlat\u0131c\u0131lar planlamak ve g\u00f6ndermek i\u00e7in kullanabilirsiniz.<\/li><li>K\u00fc\u00e7\u00fck \u00f6l\u00e7ekli e-posta pazarlamas\u0131 i\u00e7in Excel, ki\u015fi listelerini y\u00f6netmek i\u00e7in kullan\u0131labilir.<\/li><li>Excel, konuk listelerini y\u00f6netmenize ve etkinlikler i\u00e7in davetiyeler veya g\u00fcncellemeler g\u00f6ndermenize yard\u0131mc\u0131 olabilir.<\/li><li>Yeni i\u015fe al\u0131nanlara teklif mektuplar\u0131, i\u015fe al\u0131m bilgileri veya e\u011fitim materyalleri g\u00f6ndermek gibi \u0130K s\u00fcre\u00e7lerini otomatikle\u015ftirmenize olanak tan\u0131r.<\/li><li>Ba\u015far\u0131lar\u0131 ve ilerlemeyi sergilemek i\u00e7in performans raporlar\u0131n\u0131n y\u00f6neticilere veya m\u00fc\u015fterilere otomatik olarak e-posta ile g\u00f6nderilmesini planlayabilirsiniz.<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li>\u0130\u015f ak\u0131\u015f\u0131n\u0131 kolayla\u015ft\u0131rmak.<\/li><li>E-posta olu\u015fturma ve g\u00f6nderme s\u00fcrecinde harcanan zaman\u0131 azaltmak.<\/li><li>E-posta olu\u015fturma ve g\u00f6nderme s\u00fcrecinde olu\u015fabilecek hata olas\u0131l\u0131\u011f\u0131n\u0131 en aza indirmek.<\/li><li>Otomasyon her \u015feye dahil edilebilir. \u00d6rne\u011fin, elektronik tablolar\u0131 veya t\u00fcm belgeleri s\u0131k s\u0131k de\u011fi\u015ftiren \u00e7al\u0131\u015fanlar\u0131n\u0131z veya ekip arkada\u015flar\u0131n\u0131z varsa; Excel, h\u00fccre de\u011feri her de\u011fi\u015fti\u011finde, Excel belgesi g\u00fcncellendi\u011finde veya bir ko\u015ful kar\u015f\u0131land\u0131\u011f\u0131nda size otomatik e-postalar g\u00f6nderebilir.<\/li><li>Excel elektronik tablolar\u0131ndaki m\u00fc\u015fteri bilgileri e-posta\u2019lar\u0131n\u0131za dahil edilebilir, b\u00f6ylece e-posta\u2019lar \u00f6zelle\u015ftirilmi\u015f ve daha ilgi \u00e7ekici hale gelir.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">VBA Kullanarak Excel&#8217;den E-posta Nas\u0131l G\u00f6nderilir?<\/h2>\n\n\n\n<p>VBA kullanarak Excel&#8217;den e-posta g\u00f6ndermek i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyebilirsiniz:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Outlook uygulama nesnesi, e-posta konusu, g\u00f6vdesi ve al\u0131c\u0131n\u0131n e-posta adresi gibi \u00f6nemli bilgileri depolamak i\u00e7in de\u011fi\u015fkenleri ba\u015flatman\u0131z gerekir.<\/li><li>Ard\u0131ndan, Outlook uygulamas\u0131n\u0131n bir \u00f6rne\u011fini ve yeni bir posta \u00f6\u011fesi nesnesi olu\u015fturun.<\/li><li>Konu, g\u00f6vde ve al\u0131c\u0131lar gibi ilgili \u00f6zelliklerini ayarlayarak e-postan\u0131n i\u00e7eri\u011fini \u00f6zelle\u015ftirebilirsiniz.<\/li><li>Ayr\u0131ca, &#8220;Attachments.Add&#8221; y\u00f6ntemini kullanarak e-postaya dosya ekleyebilirsiniz.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Excel ile Outlook Entegrasyonunu Ayarlama<\/h2>\n\n\n\n<p>Do\u011frudan Excel&#8217;den e-posta g\u00f6ndermek i\u00e7in Outlook entegrasyonunu yap\u0131land\u0131rman\u0131z gerekir. Bu s\u00fcre\u00e7, Outlook hesab\u0131n\u0131z\u0131 Excel&#8217;e ba\u011flamay\u0131 ve gerekli eklenti veya ara\u00e7lar\u0131 etkinle\u015ftirmeyi i\u00e7erir.&nbsp;<\/p>\n\n\n\n<p>A\u015fa\u011f\u0131daki listede Excel ile Outlook entegrasyonunu nas\u0131l yap\u0131land\u0131raca\u011f\u0131n\u0131z\u0131 bulabilirsiniz:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Excel&#8217;i a\u00e7\u0131n ve Geli\u015ftirici sekmesine gidin. Geli\u015ftirici sekmesini g\u00f6rm\u00fcyorsan\u0131z Excel Se\u00e7enekleri&#8217;nden etkinle\u015ftirebilirsiniz.<\/li><li>Visual Basic D\u00fczenleyicisini (VBE) a\u00e7mak i\u00e7in &#8220;Visual Basic&#8221; butonuna t\u0131klay\u0131n.<\/li><li>VBE&#8217;de Ara\u00e7lar &gt; Referanslar&#8217;a gidin ve &#8220;Microsoft Outlook XX.X Nesne Kitapl\u0131\u011f\u0131&#8221;n\u0131n yan\u0131ndaki kutuyu i\u015faretleyin (XX.X&#8217;i Outlook s\u00fcr\u00fcm\u00fcn\u00fczle de\u011fi\u015ftirin).<\/li><li>VBE&#8217;yi kapat\u0131n ve Excel \u00e7al\u0131\u015fma kitab\u0131n\u0131za geri d\u00f6n\u00fcn.<\/li><li>Outlook Nesne Kitapl\u0131\u011f\u0131&#8217;n\u0131 etkinle\u015ftirdikten sonra, e-posta g\u00f6revlerini do\u011frudan Excel&#8217;den otomatikle\u015ftirmek i\u00e7in VBA kodunu kullanmaya ba\u015flayabilirsiniz. E-postalar\u0131 programl\u0131 olarak olu\u015fturmak, yap\u0131land\u0131rmak ve g\u00f6ndermek i\u00e7in Outlook Nesne Modelini kullanman\u0131z gerekir.<\/li><\/ul>\n\n\n\n<p>A\u015fa\u011f\u0131da, Outlook&#8217;u kullanarak e-posta g\u00f6nderen basit bir VBA kodu \u00f6rne\u011fi verilmi\u015ftir:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Sub SendEmail()\nDim OutApp As Outlook.Application\nDim OutMail As Outlook.MailItem\nSet OutApp = New Outlook.Application\nSet OutMail = OutApp.CreateItem(olMailItem)\nWith OutMail\n.To = \"isim@sirketadi.com\"\n.Subject = \"Test E-postas\u0131\"\n.Body = \"Bu Excel'den g\u00f6nderilen bir test e-postas\u0131d\u0131r.\"\n.Send\nEnd With\nSet OutMail = Nothing\nSet OutApp = Nothing\nEnd Sub<\/code><\/pre>\n\n\n\n<p>Excel&#8217;i Outlook&#8217;a ba\u011flayarak ve VBA kodunu kullanarak ki\u015fiselle\u015ftirilmi\u015f iletiler, ekler ve raporlar g\u00f6ndermek gibi \u00e7e\u015fitli e-posta g\u00f6revlerini do\u011frudan Excel \u00e7al\u0131\u015fma kitaplar\u0131n\u0131zdan otomatikle\u015ftirebilirsiniz. Daha geli\u015fmi\u015f otomasyon i\u00e7in i\u015f ak\u0131\u015f\u0131n\u0131z\u0131 kolayla\u015ft\u0131rmak amac\u0131yla sosyal yard\u0131m ve takibi otomatikle\u015ftirmeyi d\u00fc\u015f\u00fcnebilirsiniz.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Excel Verilerini Kullanarak E-posta \u0130\u00e7eri\u011fi Olu\u015fturma<\/h2>\n\n\n\n<p>Excel, verileri depolamak ve d\u00fczenlemek i\u00e7in g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r ve ki\u015fiselle\u015ftirilmi\u015f e-posta i\u00e7eri\u011fi olu\u015fturmak i\u00e7in bu verilerden yararlanabilirsiniz. Excel form\u00fcllerini ve VBA komut dosyalar\u0131n\u0131 kullanarak e-tablonuzdaki bilgilere dayal\u0131 olarak dinamik olarak e-posta adresleri, konu sat\u0131rlar\u0131 ve g\u00f6vde metni olu\u015fturabilirsiniz.&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Al\u0131c\u0131 e-posta adreslerini, konu sat\u0131r\u0131 \u015fablonlar\u0131n\u0131 ve g\u00f6vde metni \u015fablonlar\u0131n\u0131 depolamak i\u00e7in Excel h\u00fccrelerini kullan\u0131n.<\/li><li>H\u00fccre referanslar\u0131n\u0131 kullanarak Excel verilerini e-posta i\u00e7eri\u011finize ekleyin. \u00d6rne\u011fin, e-posta adresini A2 h\u00fccresinden VBA komut dosyan\u0131za \u00e7ekmek i\u00e7in <code>=A2<\/code> gibi bir form\u00fcl kullanabilirsiniz.<\/li><li>Statik metni dinamik h\u00fccre referanslar\u0131yla birle\u015ftirerek e-posta konu sat\u0131rlar\u0131n\u0131 ve g\u00f6vde metnini \u00f6zelle\u015ftirin. \u00d6rne\u011fin, B2 h\u00fccresinde saklanan ay ad\u0131n\u0131 eklemek i\u00e7in &#8220;<code>=B2 i\u00e7in Ayl\u0131k Sat\u0131\u015f Raporu<\/code>&#8221; gibi bir konu sat\u0131r\u0131 \u015fablonu olu\u015fturabilirsiniz.<\/li><\/ul>\n\n\n\n<p>A\u015fa\u011f\u0131da Excel verilerine dayal\u0131 olarak ki\u015fiselle\u015ftirilmi\u015f e-posta i\u00e7eri\u011fi olu\u015fturan bir VBA komut dosyas\u0131 \u00f6rne\u011fini bulabilirsiniz:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Sub SendPersonalizedEmails()\nDim OutApp As Outlook.Application\nDim OutMail As Outlook.MailItem\nDim rng As Range\nDim cell As Range\nSet OutApp = New Outlook.Application\nSet rng = Range(\"A2:A10\")\nFor Each cell In rng\nSet OutMail = OutApp.CreateItem(olMailItem)\nWith OutMail\n.To = cell.Value\n.Subject = \"Ayl\u0131k Sat\u0131\u015f Raporu \" \\u0026 cell.Offset(0, 1).Value\n.Body = \"Say\u0131n \" \\u0026 cell.Offset(0, 2).Value \\u0026 \",\" \\u0026 vbNewLine \\u0026 vbNewLine \\u0026 \"Ayl\u0131k sat\u0131\u015f raporunu ekte bulabilirsiniz.\" \\u0026 cell.Offset(0, 1).Value \\u0026 \".\" \\u0026 vbNewLine \\u0026 vbNewLine \\u0026 \"Sayg\u0131lar\u0131mla,\" \\u0026 vbNewLine \\u0026 \"Sat\u0131\u015f Ekibiniz\"\n.Send\nEnd With\nNext cell\nSet OutMail = Nothing\nSet OutApp = Nothing\nEnd Sub<\/code><\/pre>\n\n\n\n<p>Bu \u00f6rnekte, VBA komut dosyas\u0131, e-posta adreslerini i\u00e7eren bir dizi h\u00fccre (A2:A10) aras\u0131nda d\u00f6ng\u00fc yapar ve her al\u0131c\u0131 i\u00e7in ki\u015fiselle\u015ftirilmi\u015f konu sat\u0131rlar\u0131 ve g\u00f6vde metni olu\u015fturmak \u00fczere biti\u015fik h\u00fccrelerdeki verileri kullan\u0131r. Excel verilerinden bu \u015fekilde yararlanarak, \u00f6zel e-postalar\u0131 verimli bir \u015fekilde olu\u015fturabilir ve \u00e7ok say\u0131da al\u0131c\u0131ya g\u00f6nderebilirsiniz.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Excel&#8217;den VBA Kullanarak E-posta G\u00f6nderirken Dikkat Edilmesi Gereken Hususlar<\/h2>\n\n\n\n<p>Excel&#8217;den VBA kullanarak e-posta g\u00f6nderirken, ak\u0131lda tutulmas\u0131 gereken birka\u00e7 \u00f6nemli nokta vard\u0131r. Bunlar a\u015fa\u011f\u0131dakileri i\u00e7erir:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Excel&#8217;den imzal\u0131 bir e-posta g\u00f6ndermek i\u00e7in VBA kullan\u0131rken, imza e-posta g\u00f6vdesine dahil edilmeyebilir. Varsay\u0131lan olarak, VBA arac\u0131l\u0131\u011f\u0131yla olu\u015fturulan e-posta g\u00f6vdesi kullan\u0131c\u0131n\u0131n Outlook imzas\u0131n\u0131 i\u00e7ermez. Bu nedenle, imzay\u0131 VBA kodunuzda a\u00e7\u0131k\u00e7a i\u015flemeniz gerekir.<\/li><li>Excel aral\u0131\u011f\u0131ndan e-posta g\u00f6ndermek i\u00e7in VBA kullan\u0131rken, e-posta verilerini i\u00e7eren h\u00fccre aral\u0131\u011f\u0131n\u0131 do\u011fru bir \u015fekilde belirtin. Aral\u0131\u011f\u0131n, al\u0131c\u0131lar\u0131n e-posta adresleri, konu ve g\u00f6vde i\u00e7eri\u011fi dahil olmak \u00fczere gerekli t\u00fcm bilgileri i\u00e7erdi\u011finden emin olun. Verilerin istenen e-posta d\u00fczeniyle uyumlu olacak \u015fekilde d\u00fczenlendi\u011finden emin olun.<\/li><li>Oft \u015fablonunu kullanarak Excel&#8217;den e-posta g\u00f6ndermek i\u00e7in VBA kullan\u0131rken, &#8220;<code>Outlook.Application<\/code>&#8221; ve &#8220;<code>Outlook.MailItem<\/code>&#8221; gibi gerekli Outlook nesnelerini bildirmek ve olu\u015fturman\u0131z \u00f6nemlidir.<\/li><li>VBA kullanarak Excel&#8217;den ekli e-posta g\u00f6nderirken, dosya yollar\u0131n\u0131n do\u011fru ve eri\u015filebilir oldu\u011fundan emin olun. Dosya boyutu s\u0131n\u0131rlamalar\u0131n\u0131 ve e-posta teslimat\u0131 ile al\u0131c\u0131n\u0131n gelen kutusu \u00fczerindeki etkisini g\u00f6z \u00f6n\u00fcnde bulundurun.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">En \u00c7ok Sorulan Sorular<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. Excel VBA kullanarak Outlook&#8217;tan toplu e-postalar nas\u0131l g\u00f6nderilir?<\/h3>\n\n\n\n<p>VBA kullanarak Outlook&#8217;tan toplu e-posta g\u00f6ndermek i\u00e7in Excel&#8217;den e-posta g\u00f6nderin, a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyin:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\u00d6ncelikle, al\u0131c\u0131 e-posta adreslerini, konuyu ve g\u00f6vdeyi i\u00e7eren bir Excel elektronik tablosu haz\u0131rlay\u0131n.<\/li><li>VBA&#8217;da &#8220;Microsoft Outlook Nesne Kitapl\u0131\u011f\u0131&#8221; referans\u0131n\u0131 etkinle\u015ftirin.<\/li><li>Elektronik tabloda d\u00f6ng\u00fc olu\u015fturmak ve e-posta g\u00f6ndermek i\u00e7in bir VBA alt rutini yaz\u0131n. Bunu yapmak i\u00e7in, a\u015fa\u011f\u0131daki kodu kullanarak \u00e7al\u0131\u015fma sayfas\u0131nda bir e-posta adresi aral\u0131\u011f\u0131 ayarlayabilirsiniz:<\/li><\/ul>\n\n\n\n<p><code>\"Set Recipients = Sheets(\"Sheet1\").Range(\"A2:A10\")<\/code> &#8216; Sayfa ad\u0131n\u0131 ve aral\u0131\u011f\u0131 gerekti\u011fi gibi g\u00fcncelleyin&#8221;<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>&#8220;CreateObject&#8221; kullanarak Outlook uygulamas\u0131 ve posta \u00f6\u011fesi nesnelerini bildirin.<\/li><li>Bir d\u00f6ng\u00fc kullanarak her al\u0131c\u0131y\u0131 yineleyin. Bu, a\u015fa\u011f\u0131daki kod kullan\u0131larak yap\u0131labilir:<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>For Each Recipient In Recipients\n\n        \u2018 Create a new email\n\n        Set OutlookMail = OutlookApp.CreateItem(0<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Toplu e-posta g\u00f6ndermek i\u00e7in kodu \u00e7al\u0131\u015ft\u0131r\u0131n.<\/li><li>Geri bildirime dayal\u0131 olarak s\u00fcreci g\u00f6zden ge\u00e7irin ve iyile\u015ftirin.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">2. VBA kullanarak Excel \u00e7al\u0131\u015fma sayfas\u0131ndan otomatik olarak e-posta nas\u0131l g\u00f6nderilir?<\/h3>\n\n\n\n<p>VBA kullanarak bir Excel \u00e7al\u0131\u015fma sayfas\u0131ndan otomatik olarak e-posta g\u00f6ndermek i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyin:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Excel \u00e7al\u0131\u015fma sayfas\u0131n\u0131 gerekli e-posta ayr\u0131nt\u0131lar\u0131yla haz\u0131rlay\u0131n.<\/li><li>VBA&#8217;da &#8220;Microsoft Outlook Nesne Kitapl\u0131\u011f\u0131&#8221; referans\u0131n\u0131 etkinle\u015ftirin.<\/li><li>E-postalar\u0131 otomatik olarak g\u00f6ndermek i\u00e7in bir VBA alt rutini yaz\u0131n.<\/li><li>&#8220;CreateObject&#8221; kullanarak Outlook uygulamas\u0131n\u0131 ve posta \u00f6\u011fesi nesnelerini bildirin.<\/li><li>\u00c7al\u0131\u015fma sayfas\u0131 de\u011ferlerini kullanarak posta \u00f6\u011fesi \u00f6zelliklerini (Kime, <a href=\"https:\/\/uzmanposta.com\/blog\/cc-ve-bcc-nedir\/\">CC, BCC<\/a>, Konu, G\u00f6vde) ayarlay\u0131n.<\/li><li>Kullan\u0131c\u0131 m\u00fcdahalesi olmadan e-posta g\u00f6ndermek i\u00e7in &#8220;Send&#8221; y\u00f6ntemini kullan\u0131n.<\/li><li>Olas\u0131 sorunlar\u0131 ele almak i\u00e7in hata i\u015flemeyi uygulay\u0131n.<\/li><li>Do\u011fruluk i\u00e7in kodu test edin ve hata ay\u0131klay\u0131n.<\/li><li>Gerekirse ekler veya HTML bi\u00e7imlendirmesi ekleyin.<\/li><li>E-postalar\u0131 otomatik olarak g\u00f6ndermek i\u00e7in VBA kodunu \u00e7al\u0131\u015ft\u0131r\u0131n.<\/li><li>Al\u0131c\u0131n\u0131n gelen kutusunda ba\u015far\u0131l\u0131 teslimat\u0131 do\u011frulay\u0131n.<\/li><li>Geri bildirimlere g\u00f6re kodu iyile\u015ftirin ve optimize edin.<\/li><li>VBA kodunu i\u00e7eren Excel dosyas\u0131n\u0131n bir yede\u011fini al\u0131n.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">3. Excel VBA&#8217;da ekli bir e-postay\u0131 nas\u0131l g\u00f6nderirim?<\/h3>\n\n\n\n<p>Yeni bir posta \u00f6\u011fesi olu\u015fturduktan ve al\u0131c\u0131lar, konu ve g\u00f6vde gibi temel \u00f6zellikleri ayarlad\u0131ktan sonra e-posta&#8217;ya bir dosya ekleyebilirsiniz. Eklentinin dosya yolunu belirtin ve dosyay\u0131 eklemek i\u00e7in &#8220;Attachments.Add&#8221; y\u00f6ntemini kullan\u0131n.<\/p>\n\n\n\n<p>\u00d6rne\u011fin, Excel dosyas\u0131yla ayn\u0131 dizinde bulunan &#8220;<code>ornek.xlsx<\/code>&#8221; adl\u0131 bir dosyay\u0131 eklemek i\u00e7in a\u015fa\u011f\u0131daki kodu kullan\u0131rs\u0131n\u0131z:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>EmailItem.Attachments.Add ThisWorkbook.Path &amp;amp; \"\\ornek.xlsx\"\n\u015eimdi, \"G\u00f6nder\" y\u00f6ntemini kullanarak e-postay\u0131 g\u00f6nderin:\nEmailItem.Send<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">4. Excel VBA&#8217;dan e-posta g\u00f6ndermek neden \u00e7al\u0131\u015fm\u0131yor?<\/h3>\n\n\n\n<p>Excel VBA&#8217;dan e-posta g\u00f6ndermenin \u00e7al\u0131\u015fmamas\u0131n\u0131n birka\u00e7 nedeni olabilir. Baz\u0131 olas\u0131 nedenler a\u015fa\u011f\u0131dakileri i\u00e7erir:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Yanl\u0131\u015f e-posta yap\u0131land\u0131rmas\u0131: <a href=\"https:\/\/uzmanposta.com\/blog\/smtp-nedir\/\">SMTP<\/a> sunucusu, ba\u011flant\u0131 noktas\u0131, kullan\u0131c\u0131 ad\u0131 ve parola dahil olmak \u00fczere e-posta hesab\u0131 ayarlar\u0131n\u0131n VBA kodunuzda do\u011fru \u015fekilde yap\u0131land\u0131r\u0131ld\u0131\u011f\u0131ndan emin olun.<\/li><li>Eksik veya g\u00fcncel olmayan referanslar: Microsoft Outlook veya Microsoft Office Nesne Kitapl\u0131\u011f\u0131 gibi gerekli referanslar\u0131n VBA d\u00fczenleyicisinde do\u011fru \u015fekilde ayarlan\u0131p ayarlanmad\u0131\u011f\u0131n\u0131 kontrol edin.<\/li><li>G\u00fcvenlik ayarlar\u0131 veya g\u00fcvenlik duvarlar\u0131: Antivir\u00fcs yaz\u0131l\u0131m\u0131, g\u00fcvenlik duvarlar\u0131 veya bilgisayar\u0131n\u0131zdaki g\u00fcvenlik ayarlar\u0131 e-posta g\u00f6nderme i\u015flevini engelliyor olabilir.<\/li><li>Ge\u00e7ersiz e-posta adresleri: Al\u0131c\u0131lar\u0131n, CC veya BCC e-posta adreslerinin do\u011fru girildi\u011fini do\u011frulay\u0131n.\u00a0<\/li><li>Dahili k\u0131s\u0131tlamalar: Baz\u0131 i\u015fletmelerin otomatik e-postalar\u0131n g\u00f6nderilmesini engelleyen dahili politikalar\u0131 veya k\u0131s\u0131tlamalar\u0131 olabilir.<\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel&#8217;den mail g\u00f6ndermek i\u00e7in yaln\u0131zca birka\u00e7 basit komut dosyas\u0131 gerekir. Bu i\u015flevi elektronik tablolar\u0131n\u0131za ekledi\u011finizde Excel&#8217;de \u00e7ok daha fazlas\u0131n\u0131 ba\u015farabilirsiniz. Excel makrolar\u0131, \u00e7ok fazla programlama bilgisine ihtiya\u00e7 duymadan VBA komut dosyalar\u0131n\u0131n yapabildi\u011fi \u015feylerin \u00e7o\u011funu yapabilir. VBA, t\u00fcm PC bilgilerinizi i\u00e7eren bir elektronik tablo raporu olu\u015fturmak gibi daha geli\u015fmi\u015f rutinleri uygulaman\u0131za olanak tan\u0131r. Microsoft Excel&#8217;den [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":4646,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-4640","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-nedir-nasil-yapilir"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel&#039;de Otomatik Mail G\u00f6ndermek - Uzman Posta<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/uzmanposta.com\/blog\/excelde-otomatik-mail-gondermek\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de Otomatik Mail G\u00f6ndermek - Uzman Posta\" \/>\n<meta property=\"og:description\" content=\"Microsoft Excel&#8217;den mail g\u00f6ndermek i\u00e7in yaln\u0131zca birka\u00e7 basit komut dosyas\u0131 gerekir. Bu i\u015flevi elektronik tablolar\u0131n\u0131za ekledi\u011finizde Excel&#8217;de \u00e7ok daha fazlas\u0131n\u0131 ba\u015farabilirsiniz. Excel makrolar\u0131, \u00e7ok fazla programlama bilgisine ihtiya\u00e7 duymadan VBA komut dosyalar\u0131n\u0131n yapabildi\u011fi \u015feylerin \u00e7o\u011funu yapabilir. VBA, t\u00fcm PC bilgilerinizi i\u00e7eren bir elektronik tablo raporu olu\u015fturmak gibi daha geli\u015fmi\u015f rutinleri uygulaman\u0131za olanak tan\u0131r. Microsoft Excel&#8217;den [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/uzmanposta.com\/blog\/excelde-otomatik-mail-gondermek\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/uzmanposta\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-07-16T08:43:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-16T08:43:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/uzmanposta.com\/blog\/wp-content\/uploads\/2024\/07\/excelde-otomatik-mail-gonderme.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"675\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Sibel Ho\u015f\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@uZmanPosta\" \/>\n<meta name=\"twitter:site\" content=\"@uZmanPosta\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sibel Ho\u015f\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 dakika\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de Otomatik Mail G\u00f6ndermek - Uzman Posta","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/uzmanposta.com\/blog\/excelde-otomatik-mail-gondermek\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de Otomatik Mail G\u00f6ndermek - Uzman Posta","og_description":"Microsoft Excel&#8217;den mail g\u00f6ndermek i\u00e7in yaln\u0131zca birka\u00e7 basit komut dosyas\u0131 gerekir. Bu i\u015flevi elektronik tablolar\u0131n\u0131za ekledi\u011finizde Excel&#8217;de \u00e7ok daha fazlas\u0131n\u0131 ba\u015farabilirsiniz. Excel makrolar\u0131, \u00e7ok fazla programlama bilgisine ihtiya\u00e7 duymadan VBA komut dosyalar\u0131n\u0131n yapabildi\u011fi \u015feylerin \u00e7o\u011funu yapabilir. VBA, t\u00fcm PC bilgilerinizi i\u00e7eren bir elektronik tablo raporu olu\u015fturmak gibi daha geli\u015fmi\u015f rutinleri uygulaman\u0131za olanak tan\u0131r. Microsoft Excel&#8217;den [&hellip;]","og_url":"https:\/\/uzmanposta.com\/blog\/excelde-otomatik-mail-gondermek\/","og_site_name":"Blog","article_publisher":"https:\/\/www.facebook.com\/uzmanposta\/","article_published_time":"2024-07-16T08:43:38+00:00","article_modified_time":"2024-07-16T08:43:40+00:00","og_image":[{"width":1200,"height":675,"url":"https:\/\/uzmanposta.com\/blog\/wp-content\/uploads\/2024\/07\/excelde-otomatik-mail-gonderme.jpeg","type":"image\/jpeg"}],"author":"Sibel Ho\u015f","twitter_card":"summary_large_image","twitter_creator":"@uZmanPosta","twitter_site":"@uZmanPosta","twitter_misc":{"Yazan:":"Sibel Ho\u015f","Tahmini okuma s\u00fcresi":"10 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/uzmanposta.com\/blog\/excelde-otomatik-mail-gondermek\/#article","isPartOf":{"@id":"https:\/\/uzmanposta.com\/blog\/excelde-otomatik-mail-gondermek\/"},"author":{"name":"Sibel Ho\u015f","@id":"https:\/\/uzmanposta.com\/blog\/#\/schema\/person\/ac85212a35ebcaaf56c92a7e051813d6"},"headline":"Excel&#8217;de Otomatik Mail G\u00f6ndermek","datePublished":"2024-07-16T08:43:38+00:00","dateModified":"2024-07-16T08:43:40+00:00","mainEntityOfPage":{"@id":"https:\/\/uzmanposta.com\/blog\/excelde-otomatik-mail-gondermek\/"},"wordCount":1981,"publisher":{"@id":"https:\/\/uzmanposta.com\/blog\/#organization"},"image":{"@id":"https:\/\/uzmanposta.com\/blog\/excelde-otomatik-mail-gondermek\/#primaryimage"},"thumbnailUrl":"https:\/\/uzmanposta.com\/blog\/wp-content\/uploads\/2024\/07\/excelde-otomatik-mail-gonderme.jpeg","articleSection":["Nedir? Nas\u0131l Yap\u0131l\u0131r?"],"inLanguage":"tr"},{"@type":"WebPage","@id":"https:\/\/uzmanposta.com\/blog\/excelde-otomatik-mail-gondermek\/","url":"https:\/\/uzmanposta.com\/blog\/excelde-otomatik-mail-gondermek\/","name":"Excel'de Otomatik Mail G\u00f6ndermek - Uzman Posta","isPartOf":{"@id":"https:\/\/uzmanposta.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/uzmanposta.com\/blog\/excelde-otomatik-mail-gondermek\/#primaryimage"},"image":{"@id":"https:\/\/uzmanposta.com\/blog\/excelde-otomatik-mail-gondermek\/#primaryimage"},"thumbnailUrl":"https:\/\/uzmanposta.com\/blog\/wp-content\/uploads\/2024\/07\/excelde-otomatik-mail-gonderme.jpeg","datePublished":"2024-07-16T08:43:38+00:00","dateModified":"2024-07-16T08:43:40+00:00","breadcrumb":{"@id":"https:\/\/uzmanposta.com\/blog\/excelde-otomatik-mail-gondermek\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/uzmanposta.com\/blog\/excelde-otomatik-mail-gondermek\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/uzmanposta.com\/blog\/excelde-otomatik-mail-gondermek\/#primaryimage","url":"https:\/\/uzmanposta.com\/blog\/wp-content\/uploads\/2024\/07\/excelde-otomatik-mail-gonderme.jpeg","contentUrl":"https:\/\/uzmanposta.com\/blog\/wp-content\/uploads\/2024\/07\/excelde-otomatik-mail-gonderme.jpeg","width":1200,"height":675,"caption":"Excel'de Otomatik Mail G\u00f6ndermek"},{"@type":"BreadcrumbList","@id":"https:\/\/uzmanposta.com\/blog\/excelde-otomatik-mail-gondermek\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog","item":"https:\/\/uzmanposta.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Nedir? Nas\u0131l Yap\u0131l\u0131r?","item":"https:\/\/uzmanposta.com\/blog\/nedir-nasil-yapilir\/"},{"@type":"ListItem","position":3,"name":"Excel&#8217;de Otomatik Mail G\u00f6ndermek"}]},{"@type":"WebSite","@id":"https:\/\/uzmanposta.com\/blog\/#website","url":"https:\/\/uzmanposta.com\/blog\/","name":"Blog","description":"","publisher":{"@id":"https:\/\/uzmanposta.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/uzmanposta.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/uzmanposta.com\/blog\/#organization","name":"Uzman Posta","url":"https:\/\/uzmanposta.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/uzmanposta.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/uzmanposta.com\/blog\/wp-content\/uploads\/2020\/05\/logo.png","contentUrl":"https:\/\/uzmanposta.com\/blog\/wp-content\/uploads\/2020\/05\/logo.png","width":131,"height":60,"caption":"Uzman Posta"},"image":{"@id":"https:\/\/uzmanposta.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/uzmanposta\/","https:\/\/x.com\/uZmanPosta","https:\/\/www.instagram.com\/uzmanposta\/","https:\/\/www.linkedin.com\/company\/uzmanposta\/","https:\/\/www.youtube.com\/channel\/UCk2n1vp1YJ0n3XaDRWBi88Q"]},{"@type":"Person","@id":"https:\/\/uzmanposta.com\/blog\/#\/schema\/person\/ac85212a35ebcaaf56c92a7e051813d6","name":"Sibel Ho\u015f","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/secure.gravatar.com\/avatar\/f925f03d20ff0803ddb37c96d39d3793c085014ce56421050f24823c23db1c2a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f925f03d20ff0803ddb37c96d39d3793c085014ce56421050f24823c23db1c2a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f925f03d20ff0803ddb37c96d39d3793c085014ce56421050f24823c23db1c2a?s=96&d=mm&r=g","caption":"Sibel Ho\u015f"},"sameAs":["https:\/\/sibelhos.com\/","https:\/\/www.instagram.com\/bismoothie\/","https:\/\/www.linkedin.com\/in\/sibelhos\/"]}]}},"_links":{"self":[{"href":"https:\/\/uzmanposta.com\/blog\/wp-json\/wp\/v2\/posts\/4640","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/uzmanposta.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/uzmanposta.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/uzmanposta.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/uzmanposta.com\/blog\/wp-json\/wp\/v2\/comments?post=4640"}],"version-history":[{"count":0,"href":"https:\/\/uzmanposta.com\/blog\/wp-json\/wp\/v2\/posts\/4640\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/uzmanposta.com\/blog\/wp-json\/wp\/v2\/media\/4646"}],"wp:attachment":[{"href":"https:\/\/uzmanposta.com\/blog\/wp-json\/wp\/v2\/media?parent=4640"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/uzmanposta.com\/blog\/wp-json\/wp\/v2\/categories?post=4640"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/uzmanposta.com\/blog\/wp-json\/wp\/v2\/tags?post=4640"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}