VBA in Word to send out body of Word doc in Outlook
I have created a document in Word with a "Submit" button that uses VBA to send the document via Outlook as an attachment. My preference would be to send the information included in the Word document in the body of the email message vs. an attachment.
Cut and Paste from developer in Word:
Private Sub Submit_Click()Dim OL As ObjectDim EmailItem As ObjectDim Doc As DocumentApplication.ScreenUpdating = FalseSet OL = CreateObject("Outlook.Application")Set EmailItem = OL.CreateItem(olMailItem)Set Doc = ActiveDocumentDoc.SaveWith EmailItem .Subject = "Quote Request" .To = "firstname.lastname@example.org" .CC = "email@example.com" .Importance = olImportanceNormal .Attachments.Add Doc.FullName .DisplayEnd WithApplication.ScreenUpdating = TrueSet Doc = NothingSet OL = NothingSet EmailItem = NothingEnd Sub