{"id":12149,"date":"2012-06-30T13:48:27","date_gmt":"2012-06-30T13:48:27","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=2071"},"modified":"2022-08-12T11:28:33","modified_gmt":"2022-08-12T11:28:33","slug":"send-email-automatically","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2012\/06\/send-email-automatically\/","title":{"rendered":"How to Send Email Automatically from Excel"},"content":{"rendered":"<p>Hello friends,<\/p>\n<p>In the <a href=\"\/excel\/2012\/06\/schedule-task-in-windows-7\/\">previous Article,<\/a> you learnt how to Schedule a Program in Windows.<\/a> In this article you are going to learn, How can we send emails from Excel on a Scheduled date and Time automatically without any manual intervention. I have taken an Example from Live Scenario, where you want to send an Email on a daily basis based on certain conditions and cafeterias.<br \/>\n<\/p>\n<h3><span class=\"pa-color-highlight\">Example:<\/span><\/h3>\n<p>Let&#8217;s assume that You are working as a Team Lead. You have 10 members on your team. You are responsible to assign Tasks to each member with a deadline (Date of Completion). You need to track that each team member is completing their assigned task on or before the deadline. If any of the team members are crossing the deadline one email should be sent to that person automatically from the Outlook configured on your system or Server wherever this Excel Tracker is kept.<br \/>\nDuring your daytime, your team will be working and your status will be updated by them. In the morning by 9:00 AM you want that Excel Macro should go and verify all the Tasks against each one of your team members and send an email to them if they are crossing the deadline.<br \/>\n<br \/>\nThe Excel Template which I have prepared looks like this:<br \/>\n<br \/>\n<div id=\"attachment_2073\" style=\"width: 740px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/sendMailAutomatically.png\"><img decoding=\"async\" aria-describedby=\"caption-attachment-2073\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/sendMailAutomatically.png\" alt=\"Send Email Automatically\" title=\"Send Email Automatically\" width=\"730\" height=\"243\" class=\"size-full wp-image-2073\" \/><\/a><p id=\"caption-attachment-2073\" class=\"wp-caption-text\">Send Email Automatically<\/p><\/div><br \/>\n <\/p>\n<h1>How to Set this up for your System <\/h1>\n<p>Follow the below Steps to Set up this Macro in your System:<br \/>\n&nbsp;<br \/>\n<strong>Step 1. <a href=\"https:\/\/vmlogger.com\/excel\/wp-content\/downloads\/Scheduled-Mail-Sending.xlsm\">Download the Workbook.<\/a><\/strong><br \/>\n<strong>Step 2.<\/strong> Save this Workbook at some Location in your system.<br \/>\n<strong>Step 3.<\/strong> Now Schedule this Workbook in Task Scheduler in your System. To know How to Schedule a Task in Windows <strong><a href=\"https:\/\/vmlogger.com\/excel\/2012\/06\/schedule-task-in-windows-7\/\">Read this article.<\/a><\/strong><br \/>\n<span class=\"pa-color-highlight\">Note: In the <strong>Slide Number 11,<\/strong><\/span> of the previous article, You need to give the Complete path of your Workbook where it is saved<br \/>\nIf the Path is not correct then this Scheduler will not run and through Error.<br \/>\n<\/p>\n<h1>How to Schedule a Task in Windows ?<\/h1>\n<p><span class=\"pa-color-highlight\">You can also download the &#8220;How to Schedule a Task in Windows PPT&#8221; from here<\/span><\/p>\n<div align=center>\n<a href=\"https:\/\/vmlogger.com\/excel\/wp-content\/downloads\/How-to-Schedule-a-Task-in-Windows.pptx\"><img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/download.jpg\" alt=\"Download Now\" title=\"Download Now\" width=\"280\" height=\"88\" class=\"size-full wp-image-2000\" \/><\/a>\n<\/div>\n<p><\/p>\n<span class=\"et_bloom_bottom_trigger\"><\/span>","protected":false},"excerpt":{"rendered":"<p>Hello friends, In the previous Article, you learnt how to Schedule a Program in Windows. In this article you are going to learn, How can we send emails from Excel on a Scheduled date and Time automatically without any manual intervention. I have taken an Example from Live Scenario, where you want to send an [&hellip;]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[5205,2077],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.9 (Yoast SEO v21.9.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Send Email Automatically from Excel - Let&#039;s excel in Excel<\/title>\n<meta name=\"description\" content=\"[FREE DOWNLOAD] Scheduling sending email via Excel VBA. Excel macro to send emails automatically. Scheduling excel macro in windows scheduler\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2012\/06\/send-email-automatically\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Send Email Automatically from Excel\" \/>\n<meta property=\"og:description\" content=\"[FREE DOWNLOAD] Scheduling sending email via Excel VBA. Excel macro to send emails automatically. Scheduling excel macro in windows scheduler\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2012\/06\/send-email-automatically\/\" \/>\n<meta property=\"og:site_name\" content=\"Let&#039;s excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2012-06-30T13:48:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-12T11:28:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/sendMailAutomatically.png\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/send-email-automatically\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/send-email-automatically\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"How to Send Email Automatically from Excel\",\"datePublished\":\"2012-06-30T13:48:27+00:00\",\"dateModified\":\"2022-08-12T11:28:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/send-email-automatically\/\"},\"wordCount\":349,\"commentCount\":53,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"articleSection\":[\"Email\",\"Excel Tools\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2012\/06\/send-email-automatically\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/send-email-automatically\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/send-email-automatically\/\",\"name\":\"How to Send Email Automatically from Excel - Let&#039;s excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"datePublished\":\"2012-06-30T13:48:27+00:00\",\"dateModified\":\"2022-08-12T11:28:33+00:00\",\"description\":\"[FREE DOWNLOAD] Scheduling sending email via Excel VBA. Excel macro to send emails automatically. Scheduling excel macro in windows scheduler\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/send-email-automatically\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2012\/06\/send-email-automatically\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/send-email-automatically\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Email\",\"item\":\"https:\/\/vmlogger.com\/excel\/send-email\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Send Email Automatically from Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let&#039;s excel in Excel\",\"description\":\"Let&#039;s share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore &amp; currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/twitter.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Send Email Automatically from Excel - Let&#039;s excel in Excel","description":"[FREE DOWNLOAD] Scheduling sending email via Excel VBA. Excel macro to send emails automatically. Scheduling excel macro in windows scheduler","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:\/\/vmlogger.com\/excel\/2012\/06\/send-email-automatically\/","og_locale":"en_US","og_type":"article","og_title":"How to Send Email Automatically from Excel","og_description":"[FREE DOWNLOAD] Scheduling sending email via Excel VBA. Excel macro to send emails automatically. Scheduling excel macro in windows scheduler","og_url":"https:\/\/vmlogger.com\/excel\/2012\/06\/send-email-automatically\/","og_site_name":"Let&#039;s excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2012-06-30T13:48:27+00:00","article_modified_time":"2022-08-12T11:28:33+00:00","og_image":[{"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/sendMailAutomatically.png"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/send-email-automatically\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/send-email-automatically\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"How to Send Email Automatically from Excel","datePublished":"2012-06-30T13:48:27+00:00","dateModified":"2022-08-12T11:28:33+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/send-email-automatically\/"},"wordCount":349,"commentCount":53,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"articleSection":["Email","Excel Tools"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2012\/06\/send-email-automatically\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/send-email-automatically\/","url":"https:\/\/vmlogger.com\/excel\/2012\/06\/send-email-automatically\/","name":"How to Send Email Automatically from Excel - Let&#039;s excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"datePublished":"2012-06-30T13:48:27+00:00","dateModified":"2022-08-12T11:28:33+00:00","description":"[FREE DOWNLOAD] Scheduling sending email via Excel VBA. Excel macro to send emails automatically. Scheduling excel macro in windows scheduler","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/send-email-automatically\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2012\/06\/send-email-automatically\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/send-email-automatically\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Email","item":"https:\/\/vmlogger.com\/excel\/send-email\/"},{"@type":"ListItem","position":3,"name":"How to Send Email Automatically from Excel"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let&#039;s excel in Excel","description":"Let&#039;s share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore &amp; currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/twitter.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12149"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=12149"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12149\/revisions"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12149"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12149"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12149"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}