{"id":12147,"date":"2012-06-29T15:49:45","date_gmt":"2012-06-29T15:49:45","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=2031"},"modified":"2022-08-12T11:34:14","modified_gmt":"2022-08-12T11:34:14","slug":"send-multiple-emails","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2012\/06\/send-multiple-emails\/","title":{"rendered":"Download : Excel Macro Application to Send Multiple Emails"},"content":{"rendered":"

Hello Friends,
\nI was getting queries on :
\nHow to send Email from Excel ?
\nHow to send Email from Gmail in Excel Macro ?
\nHow to Send Email from Yahoo in Excel Macro ?
\nHow to send email from Outlook in Excel Macro ?
\nHow to send Multiple emails using Excel Macro ?<\/p>\n

Keeping those queries in my mind, I have created one Excel Macro with proper UI (User Interface) to send multiple emails from GMAIL, YAHOO, REDIFFMAIL, NETSCAPE, HOTMAIL, AOL etc. It also has option to send multiple emails via Outlook. The User Interface of this tool looks like this:
\n
\n

\"Send<\/a>

Send Multiple Email<\/p><\/div><\/p>\n

<\/p>\n\n\n
\nEdited on: 21-Aug-2012<\/i>
\n 
\nThere is one Error which many of us faced while using this tool:
\n 
\n<\/p>\n
Run-time error -2147220973 (80040213). The transport failed to connect to the server.<\/div>\n

<\/strong>
\n 
\nOne of our frequent blog reader Mr. Charles Azrak<\/strong> found the solution by changing the port number to 587<\/strong> in the code for Gmail. That worked for him. Thanks Charles. See his comment<\/a>
\n 
\nIf you are also facing the same issue then try using port number as 587 for Gmail.<\/p>\n<\/td>\n<\/td>\n<\/table>\n

<\/p>\n

To know more about How to send email using Excel Macro from GMAIL, Yahoo, Outlook etc, Read this Article<\/strong><\/a><\/p>\n

The above tool has following features:<\/h3>\n

1. Using this Tool you can send unlimited number of individual emails: <\/strong> What is Individual Mail? If you want to send an email to 1000 different email ID, ONE by ONE, means you are not keeping all the 1000 IDs in TO<\/strong> list and sending one single mail, is called individual mail. In such case it becomes very difficult to send same email 1000 times. This tool will help you doing this just by a single Click.<\/p>\n

2. You can input CC and BCC IDs as well :<\/strong> Wherever you want any email ID in CC or BCC, you have freedom to put.<\/p>\n

3. All the emails sent SUCCESSFULLY will remain in white background color :<\/strong> The emails sent successfully will remain in WHITE BACKGROUND.<\/p>\n

4. All the emails which are FAILED, will be marked in RED Background Color :<\/strong> The emails which could not be sent successfully will be marked as RED BACKGROUND<\/p>\n

5. Number of Successful and Failed Email Sent will be displayed at the end: <\/strong> On top of the Tool, below the Selection Area, at the end of the Mail Sending Process, Total Number of Successful and Failed records will be displayed.<\/p>\n

5. Error Description: <\/strong> In Excel Sheet there is a Column for the Error Description. For all the Emails which are failed, Error Description will be put there. For Successful mails, it is set to blank.<\/p>\n

Kindly provide me Feedback and Suggestion to improve this tool. Based on your suggestions and feedback, soon a New Version of this Tool will be published with more features as suggested<\/h3>\n

 <\/p>\n

\"Download<\/a><\/div>\n<\/span>","protected":false},"excerpt":{"rendered":"

Hello Friends, I was getting queries on : How to send Email from Excel ? How to send Email from Gmail in Excel Macro ? How to Send Email from Yahoo in Excel Macro ? How to send email from Outlook in Excel Macro ? How to send Multiple emails using Excel Macro ? Keeping […]<\/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,1682],"tags":[],"class_list":["post-12147","post","type-post","status-publish","format-standard","hentry","category-send-email","category-excel-tools","category-popular-articles"],"yoast_head":"\nDownload : Excel Macro Application to Send Multiple Emails - Let's excel in Excel<\/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:\/\/vmlogger.com\/excel\/2012\/06\/send-multiple-emails\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Download : Excel Macro Application to Send Multiple Emails\" \/>\n<meta property=\"og:description\" content=\"Hello Friends, I was getting queries on : How to send Email from Excel ? How to send Email from Gmail in Excel Macro ? How to Send Email from Yahoo in Excel Macro ? How to send email from Outlook in Excel Macro ? How to send Multiple emails using Excel Macro ? Keeping […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2012\/06\/send-multiple-emails\/\" \/>\n<meta property=\"og:site_name\" content=\"Let'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-29T15:49:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-12T11:34:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/SendMultipleEmail.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-multiple-emails\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/send-multiple-emails\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Download : Excel Macro Application to Send Multiple Emails\",\"datePublished\":\"2012-06-29T15:49:45+00:00\",\"dateModified\":\"2022-08-12T11:34:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/send-multiple-emails\/\"},\"wordCount\":469,\"commentCount\":64,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/send-multiple-emails\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/SendMultipleEmail.png\",\"articleSection\":[\"Email\",\"Excel Tools\",\"Popular Articles\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2012\/06\/send-multiple-emails\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/send-multiple-emails\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/send-multiple-emails\/\",\"name\":\"Download : Excel Macro Application to Send Multiple Emails - Let's excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/send-multiple-emails\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/send-multiple-emails\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/SendMultipleEmail.png\",\"datePublished\":\"2012-06-29T15:49:45+00:00\",\"dateModified\":\"2022-08-12T11:34:14+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/send-multiple-emails\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2012\/06\/send-multiple-emails\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/send-multiple-emails\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/SendMultipleEmail.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/SendMultipleEmail.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/06\/send-multiple-emails\/#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\":\"Download : Excel Macro Application to Send Multiple Emails\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let's excel in Excel\",\"description\":\"Let'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\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"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 & currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.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":"Download : Excel Macro Application to Send Multiple Emails - Let's excel in Excel","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-multiple-emails\/","og_locale":"en_US","og_type":"article","og_title":"Download : Excel Macro Application to Send Multiple Emails","og_description":"Hello Friends, I was getting queries on : How to send Email from Excel ? How to send Email from Gmail in Excel Macro ? How to Send Email from Yahoo in Excel Macro ? How to send email from Outlook in Excel Macro ? How to send Multiple emails using Excel Macro ? Keeping […]","og_url":"https:\/\/vmlogger.com\/excel\/2012\/06\/send-multiple-emails\/","og_site_name":"Let's excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2012-06-29T15:49:45+00:00","article_modified_time":"2022-08-12T11:34:14+00:00","og_image":[{"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/SendMultipleEmail.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-multiple-emails\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/send-multiple-emails\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Download : Excel Macro Application to Send Multiple Emails","datePublished":"2012-06-29T15:49:45+00:00","dateModified":"2022-08-12T11:34:14+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/send-multiple-emails\/"},"wordCount":469,"commentCount":64,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/send-multiple-emails\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/SendMultipleEmail.png","articleSection":["Email","Excel Tools","Popular Articles"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2012\/06\/send-multiple-emails\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/send-multiple-emails\/","url":"https:\/\/vmlogger.com\/excel\/2012\/06\/send-multiple-emails\/","name":"Download : Excel Macro Application to Send Multiple Emails - Let's excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/send-multiple-emails\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/send-multiple-emails\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/SendMultipleEmail.png","datePublished":"2012-06-29T15:49:45+00:00","dateModified":"2022-08-12T11:34:14+00:00","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/send-multiple-emails\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2012\/06\/send-multiple-emails\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/send-multiple-emails\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/SendMultipleEmail.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2012\/06\/SendMultipleEmail.png"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2012\/06\/send-multiple-emails\/#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":"Download : Excel Macro Application to Send Multiple Emails"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let's excel in Excel","description":"Let'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":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"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 & currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.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\/12147"}],"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=12147"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12147\/revisions"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12147"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12147"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12147"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}