![]() |
|
#2
|
||||
|
||||
|
There are a couple of issues that need attention in your code, but for the main part, the document you have created from your template can be saved as a temporary file, attached to the message and then deleted e.g. as follows. Personally I would use the code at Test if Outlook is open and open Outlook with VBA to open/start Outlook, but this will work with some minor changes.
Code:
Private Sub CommandButton1_Click()
'Graham Mayor - https://www.gmayor.com - Last updated - 27 Apr 2020
Dim OL As Object
Dim olInsp As Object
Dim EmailItem As Object
Dim Doc As Document
Dim wdDoc As Document
Dim oRng As Range
Dim strPath As String
strPath = Environ("TEMP") & "\Filename.docx" 'change name as required
Application.ScreenUpdating = False
Set OL = CreateObject("Outlook.Application")
Set EmailItem = OL.CreateItem(0)
Set Doc = ActiveDocument
Doc.SaveAs2 FileName:=strPath, FileFormat:=12, AddToRecentFiles:=False
With EmailItem
.Subject = "ENTER SUBJECT LINE HERE"
.To = "ENTER RECIPIENT EMAIL HERE"
'.CC = "ENTER A CC EMAIL ADDRESS AND REMOVE COMMENT OUT TO MAKE LIVE"
.Importance = 2
Set olInsp = .GetInspector
Set wdDoc = olInsp.WordEditor
Set oRng = wdDoc.Range
oRng.Collapse 1
.Display 'This line is required
oRng.Text = "ENTER MESSAGE HERE" '& vbCrLf & _
'"BODY SECND LINE" & vbCrLf & _
'"BODY THIRD LINE"
.Attachments.Add strPath
.Send
End With
Doc.Close 0
Kill strPath
Application.ScreenUpdating = True
Set OL = Nothing
Set EmailItem = Nothing
Set olInsp = Nothing
Set wdDoc = Nothing
Set oRng = Nothing
End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Command Button | herman777 | Excel Programming | 2 | 06-02-2019 06:45 AM |
| Show table list by using chek box command and save document on sharepoint by using command button | Zhibek | Word VBA | 3 | 08-16-2018 06:19 PM |
| Help with a Command Button | dkohnken | Word VBA | 5 | 03-18-2015 10:13 PM |
| Command Button | knp11 | PowerPoint | 2 | 01-18-2015 01:41 PM |
Command Button
|
cksm4 | Word VBA | 7 | 02-27-2011 08:47 PM |