{"id":12109,"date":"2011-12-17T17:24:01","date_gmt":"2011-12-17T17:24:01","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=1072"},"modified":"2022-08-12T11:29:13","modified_gmt":"2022-08-12T11:29:13","slug":"how-to-send-email-by-excel-macro-from-outlook","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2011\/12\/how-to-send-email-by-excel-macro-from-outlook\/","title":{"rendered":"How to send email from Excel Macro from Outlook"},"content":{"rendered":"
This is continuation of my Previous Article you learnt How to Send Email From Excel VBA<\/strong>, using Gmail and Yahoo Email Account.
\n
\nIn my Previous Article, How to send email from Excel Macro<\/a>,<\/strong> as you saw how to send email by Excel VBA from Gmail or Yahoo In this article you are going to learn how to send an email automatically by Excel VBA from my Outlook. Here in this you need to make sure that you have Outlook installed in your system where your excel macro is running. Also for sending email your Outlook must be configured already.
\nBefore we get in to the code details, we need to add Microsoft Outlook 12.0 Object Librar<\/strong> reference in your Excel.
\nIf you have not added this Reference then you need to create Outlook Objects run-time.<\/p>\n