[VBA Code]How to send emails from Excel without Outlook
*****
Private Sub CommandButton1_Click()
Dim iMsg As Object
Dim iConf As Object
Dim strbody As String
Dim Flds As Variant
Set iMsg = CreateObject("CDO.Message")
Set iConf = CreateObject("CDO.Configuration")
iConf.Load -1 ' CDO Source Defaults
Set Flds = iConf.Fields
With Flds
.Item("http://schemas.microsoft.com/cdo/configuration/smtpusessl") = True
.Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1
.Item("http://schemas.microsoft.com/cdo/configuration/sendusername") = "sender@thebigshot.co"
.Item("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "password"
.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "mail.thebigshot.co"
.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 465
.Update
End With
strbody = "<H3>Topic Here:</H3>" & _
"Body here<BR>"
'Paste selected range for formatted text
Dim cRange As Range
Set cRange = Worksheets("Sheet1").Range("A2:B8").SpecialCells(xlCellTypeVisible)
cRange.Select
cRange.Copy
cRange.PasteSpecial '???
'Application.ScreenUpdating = False
With iMsg
Set .Configuration = iConf
.To = "recepient@gthebigshot.co"
.CC = ""
.BCC = ""
.From = """Sender Name"" <sender@thebigshot.co>"
.Subject = "Subject here"
.HTMLBody = strbody
.send
End With
MsgBox ("Email has been sent successfully.")
End Sub
Pages
Tuesday, August 11, 2020
[VBA Code]How to send emails from Excel without Outlook
Popular Posts
-
Advanced Excel Success: A Practical Guide to Mastering Excel DOWNLOAD DOWNLOAD 2 🎁Like Fanpage and Read online bellow⏬ Khung iFrame ...
-
DOWNLOAD DOWNLOAD 2 Excel Formulas and Functions: The Step by Step Excel Guide on how to Create Powerful Formulas 📌 Do you want to master...
-
DOWNLOAD DOWNLOAD 2 📌 Khung iFrame DOWNLOAD New Excel Shortcuts Chea...
-
DOWNLOAD DOWNLOAD 2 Brilliant Excel VBA Programming. Ken Bluttman 📌 Bluttman, Ken This title is for those that use Excel and want to know...
-
DOWNLOAD DOWNLOAD 2 📌 Khung iFrame DOWNLOAD Excel VBA Programming: T...
-
DOWNLOAD DOWNLOAD 2 101 Most Popular Excel Formulas PDF 2023 John Michaloudis, Bryan Hong PDF 2023 Learn the Most Popular Excel Formulas Eve...
-
DOWNLOAD DOWNLOAD 2 📌 Khung iFrame DOWNLOAD Python in a Nutshell : A B...
-
Excel Formulas Bible 2023 Free PDF This is one single document which contains close to 100 formulas dealing with various situations. Usefu...
-
DOWNLOAD DOWNLOAD 2 Top 50 + Tips to Master Excel 2023 Free PDF DOWNLOAD MORE EBOOK PDF FREE HERE
Popular Posts
-
DOWNLOAD DOWNLOAD 2 Top 101+ Most Popular Excel Formulas new Free PDF 2023 John Michaloudis , Bryan Hong Learn the Most Popular Excel Formu...
-
DOWNLOAD DOWNLOAD 2 Top 50 + Tips to Master Excel 2023 Free PDF DOWNLOAD MORE EBOOK PDF FREE HERE
-
DOWNLOAD LINK DOWNLOAD 2 DOWNLOAD 3 101 Most Popular Excel Formulas John Michaloudis , Bryan Hong Learn the Most Popular Excel Formulas Eve...
-
DOWNLOAD DOWNLOAD 2 Excel Formulas and Functions: The Step by Step Excel Guide on how to Create Powerful Formulas 📌 Do you want to master...
-
DOWNLOAD DOWNLOAD 2 101 Most Popular Excel Formulas PDF 2023 John Michaloudis, Bryan Hong PDF 2023 Learn the Most Popular Excel Formulas Eve...
-
DOWNLOAD DOWNLOAD 2 Data Analysis in Microsoft Excel: Deliver Awesome Analytics in 3 Easy Steps Using VLOOKUPS, Pivot Tables, Charts And M...
-
Excel Cheat Sheet 2021 FREE PDF - CustomGuide DOWNLOAD LINK DOWNLOAD 2 DOWNLOAD 3 DOWNLOAD 4 🎁Like Fanpage and Read online bellow. #evba ...
-
DOWNLOAD DOWNLOAD 2 DOWNLOAD 3 101 Most Popular Excel Formulas new 2023 Free PDF John Michaloudis , Bryan Hong Learn the Most Popular Ex...
-
2021 Microsoft Formulas and Functions: A Simplified Guide With Examples on how to take advantage of built-in Excel Formulas and Functions ...
-
The Excel Master Guidebook Series FREE EBOOK PDF Expert , Excel DOWNLOAD LINK DOWNLOAD 2 Overview: This comprehensive book series (7 books)...
Popular Posts
-
DOWNLOAD DOWNLOAD 2 Data Analysis in Microsoft Excel: Deliver Awesome Analytics in 3 Easy Steps Using VLOOKUPS, Pivot Tables, Charts And M...
-
DOWNLOAD DOWNLOAD 2 Excel Formulas and Functions: The Step by Step Excel Guide on how to Create Powerful Formulas 📌 Do you want to master...
-
DOWNLOAD DOWNLOAD 2 Top 50 + Tips to Master Excel 2023 Free PDF DOWNLOAD MORE EBOOK PDF FREE HERE
-
Advanced Excel Success: A Practical Guide to Mastering Excel DOWNLOAD DOWNLOAD 2 🎁Like Fanpage and Read online bellow⏬ Khung iFrame ...
-
DOWNLOAD DOWNLOAD 2 📌 Khung iFrame DOWNLOAD Microsoft Excel Formula...
-
DOWNLOAD DOWNLOAD 2 Power BI for the Excel Analyst: Your Essential Guide to Power BI Author(s): Wyn Hopkins Publisher: Tickling Keys, Inc....
-
DOWNLOAD DOWNLOAD 2 101 Most Popular Excel Formulas PDF 2023 John Michaloudis, Bryan Hong PDF 2023 Learn the Most Popular Excel Formulas Eve...
-
DOWNLOAD DOWNLOAD 2 Python for Excel: A Modern Environment for Automation and Data Analysis 📌 Felix Zumstein While Excel remains ubiquito...
-
DOWNLOAD DOWNLOAD 2 Excel 2023: The #1 Guide to Master All the Functions and Formulas to Become a Professional in Just 7 Days With Practic...