{"id":12108,"date":"2011-12-16T22:31:46","date_gmt":"2011-12-16T22:31:46","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=1061"},"modified":"2022-08-17T19:31:18","modified_gmt":"2022-08-17T19:31:18","slug":"how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2011\/12\/how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo\/","title":{"rendered":"How to Send an Email using Excel Macro from Gmail or Yahoo"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; _builder_version=&#8221;4.17.6&#8243; custom_padding=&#8221;0px|0px|0px|0px|true|true&#8221; da_disable_devices=&#8221;off|off|off&#8221; global_colors_info=&#8221;{}&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221;][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221;][et_pb_text _builder_version=&#8221;4.17.6&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]Dear Readers,<\/p>\n<p>In this article, we are going to learn how to send an email automatically by Excel Excel VBA. While executing the Excel Macro, sometimes you may need to send some Details or Results directly to your email ID or any other ID using Excel Macro. If you have some report or details which you want to send in a mail without log-in to your email account.<br \/>\nThis you are going to achieve by using <strong>CDO Object<\/strong>.<\/p>\n<h1>What is CDO (Collaboration Data Objects)??<\/h1>\n<p>.<br \/>\nThis Object is basically used for <strong>Active Messaging, Enables user to Access Global Server Objects and Address List<\/strong> For more about this read this <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms978698.aspx\" target=\"_blank\" rel=\"noopener\">Microsoft Help<\/a>.<\/p>\n<p>In Microsoft Excel, to use this Object you need to Add CDO Reference.<\/p>\n<div id=\"attachment_1063\" style=\"width: 469px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/12\/cdo-reference.png\"><img decoding=\"async\" aria-describedby=\"caption-attachment-1063\" src=\"https:\/\/www.vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/12\/cdo-reference.png\" alt=\"Add CDO Reference\" title=\"cdo-reference\" width=\"459\" height=\"370\" class=\"size-full wp-image-1063\" \/><\/a><p id=\"caption-attachment-1063\" class=\"wp-caption-text\">Add CDO Reference<\/p><\/div>\n<p><strong>Note:<\/strong> Without adding this reference you can Run the below Code. For running this Code, you can use below line to create Object runtime:<\/p>\n<pre><code class=\"language-vbnet\">\nSet myMail = CreateObject(&quot;CDO.Message&quot;)\n<\/code><\/pre>\n<p>In this article, i will explain you 2 simple methods, to send an email by Excel VBA.<\/p>\n<div class=\"alert alert-info\">\n<ul id=\"recentposts\">\n<li id=\"recentposts\">\n<a href=\"how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo\/#send-mail-gmail\">Excel VBA: Send email from Gmail<\/a>\n<\/li>\n<li id=\"recentposts\">\n<a href=\"how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo\/#send-mail-yahoo\">Excel VBA: Send email from Yahoo<\/a>\n<\/li>\n<li id=\"recentposts\">\n<a href=\"how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo\/#with-html-body\">Send Email with HTML Body<\/a>\n<\/li>\n<li id=\"recentposts\">\n<a href=\"how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo\/#with-attachment\">Send Email with an Attachment<\/a>\n<\/li>\n<\/ul>\n<\/div>\n<p><a name=\"send-mail-gmail\"><\/a><\/p>\n<h1>1. Excel VBA: Send email from Gmail<\/h1>\n<pre><code class=\"language-vbnet\">\n\nSub SendEmailUsingGmail()\n    \n    On Error GoTo Err\n    \n    Dim NewMail As Object\n    Dim mailConfig As Object\n    Dim fields As Variant\n    Dim msConfigURL As String\n    \n    Set NewMail = CreateObject(\"CDO.Message\")\n    Set mailConfig = CreateObject(\"CDO.Configuration\")\n    \n    ' load all default configurations\n    mailConfig.Load -1\n    \n    Set fields = mailConfig.fields\n    \n'Set All Email Properties\n    \n    With NewMail\n        .Subject = \"Test Mail from LearnExcelMacro.com\"\n        .From = \"email@gmail.com\"\n        .To = \"email2@gmail.com;email3@gmail.com\"\n        .CC = \"email4@gmail.com\"\n        .BCC = \"\"\n        .textbody = \"\"\n    End With\n    \n    msConfigURL = \"http:\/\/schemas.microsoft.com\/cdo\/configuration\"\n    \n    With fields\n        'Enable SSL Authentication\n        .Item(msConfigURL & \"\/smtpusessl\") = True\n        \n        'Make SMTP authentication Enabled=true (1)\n        .Item(msConfigURL & \"\/smtpauthenticate\") = 1\n        \n        'Set the SMTP server and port Details\n        'To get these details you can get on Settings Page of your Gmail Account\n        .Item(msConfigURL & \"\/smtpserver\") = \"smtp.gmail.com\"\n        .Item(msConfigURL & \"\/smtpserverport\") = 465\n        .Item(msConfigURL & \"\/sendusing\") = 2\n        \n        'Set your credentials of your Gmail Account\n        .Item(msConfigURL & \"\/sendusername\") = \"email@gmail.com\"\n        .Item(msConfigURL & \"\/sendpassword\") = \"********\"\n        \n        'Update the configuration fields\n        .Update\n        \n    End With\n    NewMail.Configuration = mailConfig\n    NewMail.Send\n    MsgBox (\"Mail has been Sent\")\n    \nExit_Err:\n    \n    Set NewMail = Nothing\n    Set mailConfig = Nothing\n    End\n    \nErr:\n    Select Case Err.Number\n    \n    Case -2147220973  'Could be because of Internet Connection\n        MsgBox \" Could be no Internet Connection !!  -- \" & Err.Description\n        \n    Case -2147220975  'Incorrect credentials User ID or password\n        MsgBox \"Incorrect Credentials !!  -- \" & Err.Description\n        \n    Case Else   'Rest other errors\n        MsgBox \"Error occured while sending the email !!  -- \" & Err.Description\n    End Select\n    \n    Resume Exit_Err\n    \nEnd Sub\n\n<\/code><\/pre>\n<p>\n<a name=\"send-mail-yahoo\"><\/a><\/p>\n<h1>2. Excel VBA: Send email from Yahoo<\/h1>\n<pre><code class=\"language-vbnet\">\n\nSub SendEmailUsingYahoo()\n    \n    On Error GoTo Err\n    \n    Dim NewMail As Object\n    Dim mailConfig As Object\n    Dim fields As Variant\n    Dim msConfigURL As String\n    \n    Set NewMail = CreateObject(\"CDO.Message\")\n    Set mailConfig = CreateObject(\"CDO.Configuration\")\n    \n    ' load all default configurations\n    mailConfig.Load -1\n    \n    Set fields = mailConfig.fields\n    \n'Set All Email Properties\n    \n    With NewMail\n        .Subject = \"Test Mail from LearnExcelMacro.com\"\n        .From = \"email@yahoo.co.in\"\n        .To = \"email1@gmail.com;email2@yahoo.com\"\n        .CC = \"email@email.com\"\n        .BCC = \"\"\n        .textbody = \"\"\n    End With\n    \n    msConfigURL = \"http:\/\/schemas.microsoft.com\/cdo\/configuration\"\n    \n    With fields\n        'Enable SSL Authentication\n        .Item(msConfigURL & \"\/smtpusessl\") = True\n        \n        'Make SMTP authentication Enabled=true (1)\n        .Item(msConfigURL & \"\/smtpauthenticate\") = 1\n        \n        'Set the SMTP server and port Details\n        'To get these details you can get on Settings Page of your yahoo Account\n        .Item(msConfigURL & \"\/smtpserver\") = \"smtp.mail.yahoo.com\"\n        .Item(msConfigURL & \"\/smtpserverport\") = 465\n        .Item(msConfigURL & \"\/sendusing\") = 2\n        \n        'Set your credentials of your yahoo Account\n        .Item(msConfigURL & \"\/sendusername\") = \"email@yahoo.co.in\"\n        .Item(msConfigURL & \"\/sendpassword\") = \"******\"\n        \n        'Update the configuration fields\n        .Update\n        \n    End With\n    NewMail.Configuration = mailConfig\n    NewMail.Send\n    MsgBox (\"Mail has been Sent\")\n    \nExit_Err:\n    \n    Set NewMail = Nothing\n    Set mailConfig = Nothing\n    End\n    \nErr:\n    Select Case Err.Number\n    \n    Case -2147220973  'Could be because of Internet Connection\n        MsgBox \" Could be no Internet Connection !!  -- \" & Err.Description\n        \n    Case -2147220975  'Incorrect credentials User ID or password\n        MsgBox \"Incorrect Credentials !!  -- \" & Err.Description\n        \n    Case Else   'Rest other errors\n        MsgBox \"Error occured while sending the email !!  -- \" & Err.Description\n    End Select\n    \n    Resume Exit_Err\n    \nEnd Sub\n \n<\/code><\/pre>\n<p>\n<a name=\"with-html-body\"><\/a><\/p>\n<h1> Excel VBA to Send Email with HTML Body<\/h1>\n<p>For sending HTML Body you just need to Change the Email Properties which you are setting above<\/p>\n<pre><code class=\"language-vbnet\">\n\nWith NewMail\n  .Subject = &quot;Test Mail from LearnExcelMacro.com&quot;\n  .From = &quot;email@yahoo.com&quot;\n  .To = &quot;email2@gmail.com;email3@yahoo.com&quot;\n  .CC = &quot;email@email.com&quot;\n  .BCC = &quot;&quot;\n  .HTMLBody = &quot;Write your complete HTML Page&quot;\nEnd With\n<\/code><\/pre>\n<p>\n<a name=\"with-attachment\"><\/a><\/p>\n<h1> Excel VBA to Send Email with an Attachment<\/h1>\n<pre><code class=\"language-vbnet\">\nWith NewMail\n  .Subject = &quot;Test Mail from LearnExcelMacro.com&quot;\n  .From = &quot;vishwamitra01@yahoo.com&quot;\n  .To = &quot;vishwamitra02@gmail.com;info@learnexcelmacro.com&quot;\n  .CC = &quot;vishwamitra01@gmail.com&quot;\n  .BCC = &quot;&quot;\n  .HTMLBody = &quot;Write your complete HTML Page&quot;\n\n' For multiple Attachment you can add below lines as many times\n\n  .AddAttachment &quot;C:\\ExcelMacro-help.xls&quot;\n  .AddAttachment &quot;C:\\ExcelMacro-help2.xls&quot;\nEnd With\n<\/code><\/pre>\n<p>[\/et_pb_text][et_pb_blurb title=&#8221;You may also like reading these articles: &#8221; use_icon=&#8221;on&#8221; font_icon=&#8221;&#xf5da;||fa||900&#8243; _builder_version=&#8221;4.17.6&#8243; _module_preset=&#8221;0249c68e-4de8-4f44-84ff-a9b1850785b6&#8243; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;]<\/p>\n<ol>\n<li>\n<a href=\"https:\/\/vmlogger.com\/excel\/2012\/01\/how-to-login-to-gmail-from-excel-macro\/\" target=\"_blank\" rel=\"noopener\">HOW TO INTERACT WITH HTML PAGES FROM EXCEL<\/a><\/li>\n<li><a href=\"https:\/\/vmlogger.com\/excel\/2012\/08\/send-more-than-one-sheet\/\" target=\"_blank\" rel=\"noopener\">HOW TO SEND MORE THAN ONE SHEET OF THE WORKBOOK IN MAIL<\/a><\/li>\n<li><a href=\"https:\/\/vmlogger.com\/excel\/2012\/06\/send-multiple-emails\/\" target=\"_blank\" rel=\"noopener\">DOWNLOAD : EXCEL MACRO APPLICATION TO SEND MULTIPLE EMAILS<\/a><\/li>\n<li><a href=\"https:\/\/vmlogger.com\/excel\/2012\/11\/download-excel-tool-to-send-multiple-emails\/\" target=\"_blank\" rel=\"noopener\">DOWNLOAD : EXCEL MACRO APPLICATION TO SEND MULTIPLE EMAILS \u2013 2.0<\/a><\/li>\n<li><a href=\"https:\/\/vmlogger.com\/excel\/2014\/04\/send-multiple-email-tool-ver-3-0\/\" target=\"_blank\" rel=\"noopener\">DOWNLOAD : EXCEL MACRO APPLICATION TO SEND MULTIPLE EMAILS \u2013 3.0<\/a><\/li>\n<\/ol>\n<p>[\/et_pb_blurb][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n<span class=\"et_bloom_bottom_trigger\"><\/span>","protected":false},"excerpt":{"rendered":"<p>Dear Readers, In this article, we are going to learn how to send an email automatically by Excel Excel VBA. While executing the Excel Macro, sometimes you may need to send some Details or Results directly to your email ID or any other ID using Excel Macro. If you have some report or details which [&hellip;]<\/p>\n","protected":false},"author":45,"featured_media":1063,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[5205,1682],"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>VBA code for sending email from Gmail or yahoo - LearnExcelMacro.com<\/title>\n<meta name=\"description\" content=\"VBA code to send email. How to send email with HTML body in Excel Macro. Send email with an attachment in Excel VBA. VBA code to send email from gmail. VBA code to send email from yahoo\" \/>\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\/2011\/12\/how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Send an Email using Excel Macro from Gmail or Yahoo\" \/>\n<meta property=\"og:description\" content=\"VBA code to send email. How to send email with HTML body in Excel Macro. Send email with an attachment in Excel VBA. VBA code to send email from gmail. VBA code to send email from yahoo\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2011\/12\/how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo\/\" \/>\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=\"2011-12-16T22:31:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-17T19:31:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/vmlogger.com_-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/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=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/12\/how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/12\/how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"How to Send an Email using Excel Macro from Gmail or Yahoo\",\"datePublished\":\"2011-12-16T22:31:46+00:00\",\"dateModified\":\"2022-08-17T19:31:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/12\/how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo\/\"},\"wordCount\":460,\"commentCount\":133,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"articleSection\":[\"Email\",\"Popular Articles\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2011\/12\/how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/12\/how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2011\/12\/how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo\/\",\"name\":\"VBA code for sending email from Gmail or yahoo - LearnExcelMacro.com\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"datePublished\":\"2011-12-16T22:31:46+00:00\",\"dateModified\":\"2022-08-17T19:31:18+00:00\",\"description\":\"VBA code to send email. How to send email with HTML body in Excel Macro. Send email with an attachment in Excel VBA. VBA code to send email from gmail. VBA code to send email from yahoo\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/12\/how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2011\/12\/how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/12\/how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo\/#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 an Email using Excel Macro from Gmail or Yahoo\"}]},{\"@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":"VBA code for sending email from Gmail or yahoo - LearnExcelMacro.com","description":"VBA code to send email. How to send email with HTML body in Excel Macro. Send email with an attachment in Excel VBA. VBA code to send email from gmail. VBA code to send email from yahoo","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\/2011\/12\/how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo\/","og_locale":"en_US","og_type":"article","og_title":"How to Send an Email using Excel Macro from Gmail or Yahoo","og_description":"VBA code to send email. How to send email with HTML body in Excel Macro. Send email with an attachment in Excel VBA. VBA code to send email from gmail. VBA code to send email from yahoo","og_url":"https:\/\/vmlogger.com\/excel\/2011\/12\/how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo\/","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":"2011-12-16T22:31:46+00:00","article_modified_time":"2022-08-17T19:31:18+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/vmlogger.com_-1.png","type":"image\/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":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2011\/12\/how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/12\/how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"How to Send an Email using Excel Macro from Gmail or Yahoo","datePublished":"2011-12-16T22:31:46+00:00","dateModified":"2022-08-17T19:31:18+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/12\/how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo\/"},"wordCount":460,"commentCount":133,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"articleSection":["Email","Popular Articles"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2011\/12\/how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2011\/12\/how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo\/","url":"https:\/\/vmlogger.com\/excel\/2011\/12\/how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo\/","name":"VBA code for sending email from Gmail or yahoo - LearnExcelMacro.com","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"datePublished":"2011-12-16T22:31:46+00:00","dateModified":"2022-08-17T19:31:18+00:00","description":"VBA code to send email. How to send email with HTML body in Excel Macro. Send email with an attachment in Excel VBA. VBA code to send email from gmail. VBA code to send email from yahoo","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/12\/how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2011\/12\/how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2011\/12\/how-to-send-an-email-using-excel-macro-from-gmail-or-yahoo\/#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 an Email using Excel Macro from Gmail or Yahoo"}]},{"@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\/12108"}],"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=12108"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12108\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12108"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12108"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12108"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}