Excel-VBA : Open a MS Word Document using Excel File using Explorer Window.Send Mail With Multiple Different Attachments From MS Outlook using Excel.Send Mail With Link to a Workbook, From MS Outlook using Excel.VBA-Excel: Modified Consolidator – Merge or Combine Multiple Excel Files Into One Where Columns Are Not In Order.VBA-Excel: Change Font, Color, Weight of Table Data in the Word document.VBA-Excel: Create or Add Worksheets at the Run time.VBA-Excel: Add Worksheets For All The Given Dates Except Weekends and Copy The Common Template In Each Worksheet.VBA-Excel: Create worksheets with Names in Specific Format/Pattern.VBA-Excel: Read XML by Looping through Nodes.Send a Mail using Predefined Template From MS Outlook Using Excel Send a Simple Mail From MS Outlook Using Excel – 2Įnter your email address to subscribe to this blog and receive notifications of new posts by email. MsgBox ("you Mail has been sent to " & SendID) Subject = mainWB.Sheets("Mail").Range("B3").Valueīody = mainWB.Sheets("Mail").Range("B4").Value SendID = mainWB.Sheets("Mail").Range("B1").ValueĬCID = mainWB.Sheets("Mail").Range("B2").Value Set olMail = otlApp.CreateItem(olMailItem) Set otlApp = CreateObject("Outlook.Application") Get the Document Object (for pasting) Set Doc = Ĭompose and Send mail using mail Item, use document object for paste the mail in body. Set otlApp = CreateObject("Outlook.Application")Ĭreate a Mail Item. In that case you will not fetch the text from a excel cell for body, instead you will copy and paste the entire cell into your mail body.Ĭreate object of Outlook Application.
In our earlier tutorial we have seen how to send a simple text mail using MS Outlook but how about when you want to send a proper composed mail, means your will compose the mail in a proper format in you excel and you want formatting to be retained while sending.