I am using this code to send emails from excel. It works 100%
I want to use the same code, but to send sheet1.Range("A1:N56") as the body
![]()
Sub SendEmail() Dim OutlookApp As Outlook.Application Dim MyItem As Outlook.MailItem Dim EmailAddr As String Dim Subj As String Dim Sender As String Dim Msg As Range Set OutlookApp = New Outlook.Application Set MyItem = OutlookApp.CreateItem(olMailItem) EmailAddr = Sheet2.Range("B1").Value Subj = "MANUAL TRANSMITTAL - " & Sheet1.Range("M5").Value & " - Notification" Sender = Sheet2.Range("E5").Value Msg = UserForm2.ComboBox1.Value & " " & UserForm1.TextBox1.Value & vbCrLf & vbCrLf Msg = Msg & UserForm2.TextBox2.Value & vbCrLf & vbCrLf Msg = Msg & UserForm2.ComboBox2.Value & vbCrLf Msg = Msg & Sender & vbCrLf & vbCrLf Msg = Msg & "Sent on " & Date & " at " & Time With MyItem .To = EmailAddr .Subject = Subj .Body = Msg If UserForm2.CheckBox1.Value = True Then .ReadReceiptRequested = True Else .ReadReceiptRequested = False End If If UserForm2.OptionButton1.Value = True Then .Display End If If UserForm2.OptionButton2.Value = True Then .Save End If If UserForm2.OptionButton3.Value = True Then .Send End If End With End Sub
Bookmarks