![]() |
|
|
|
#1
|
||||
|
||||
|
You have embedded a sub within a sub
Private Sub CommandButton1_Click() Sub Send_PDF_As_Attachment() and similarly at the end you have End Sub End Sub Remove one of the End Subs and the line Sub Send_PDF_As_Attachment() and provided the code is associated with the button you should be getting somewhere.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
|
#2
|
|||
|
|||
|
I now get a error expected function or variable and it highlights saveas2. Could it be that it is an Active X button? I know this is getting annoying for you I appreciate the help.
Code:
Private Sub CommandButton1_Click()
Dim oOutlookApp As Object
Dim oItem As Object
Dim olInsp As Object
Dim strFname As String
Dim wdDoc As Document
Dim oRng As Range
With ActiveDocument
strFname = .SaveAs2(FileName:="C:\Users\" & Environ("Username") & "\Documents\" & _
.SelectContentControlsByTitle("Title")(1).Range.Text & ".PDF", _
FileFormat:=wdFormatPDF)
End With
On Error Resume Next
'Get Outlook if it's running
Set oOutlookApp = GetObject(, "Outlook.Application")
'Outlook wasn't running, start it from code
If Err <> 0 Then
Set oOutlookApp = CreateObject("Outlook.Application")
End If
On Error GoTo 0
'Create a new mailitem
Set oItem = oOutlookApp.CreateItem(0)
With oItem
Set olInsp = .GetInspector
Set wdDoc = olInsp.WordEditor
Set oRng = wdDoc.Range
oRng.Collapse 1
oRng.Text = "This is the message body"
.to = "someone@somewhere.com"
.Subject = "This is the subject"
.BodyFormat = 2
.Attachments.Add strFname
.Display
End With
'Clean up
Set oItem = Nothing
Set oOutlookApp = Nothing
Set olInsp = Nothing
Set wdDoc = Nothing
Set oRng = Nothing
lbl_Exit:
Exit Sub
End Sub
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
How can I save a Word Document as a PDF file with a merged field filename?
|
kp2009 | Word VBA | 5 | 08-27-2015 11:45 PM |
Auto update Filename field
|
Oliver Beirne | Word VBA | 4 | 10-19-2012 03:33 AM |
| Macro to populate a text form field based on dropdown selection | koloa | Word | 0 | 10-20-2011 11:52 AM |
Save Filename using Document Text
|
Knawl | Word | 11 | 10-10-2011 03:00 AM |
Selecting merge field based on whether or not text is present
|
amym | Mail Merge | 1 | 12-07-2010 05:14 AM |