PDF will not attach to Outlook Email using VBA

[Jharrin]

Upgraded to Excel 2016 / Outlook 2016 today and it broke my excel app.

One of the functions I have created with the Excel app is to take the current sheet, convert to pdf then attach to Outlook email and .send. The PDF file is being generated and is appearing on the desktop. The code I am using is attached below. It will not attach the .pdf. Everything seems to work ok up to that point. Changing the code to .display shows there is nothing attached to the email message on creation. Please help with this before I lose it. Code attached below:

Sub SendWorkSheetToPDF()


Dim Wb As Workbook
Dim FileName As String
Dim OutlookApp As Object
Dim OutlookMail As Object


On Error Resume Next
Set Wb = Application.ActiveWorkbook
FileName = Wb.FullName
xIndex = VBA.InStrRev(FileName, ".")
If xIndex > 1 Then FileName = VBA.Left(FileName, xIndex - 1)
FileName = FileName & "_" + ActiveSheet.Name & ".pdf"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:=FileName, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False


Set OutlookApp = CreateObject("Outlook.Application")
Set OutlookMail = OutlookApp.CreateItem(0)
With OutlookMail
.To = "" ' Email address
.CC = ""
.BCC = ""
.Subject = "kte features"
.Body = "Please check and read this document."
.Attachments.Add FileName
.Display
End With
Kill FileName
Set OutlookMail = Nothing
Set OutlookApp = Nothing
End Sub


Thanks,
John

 

[mrshl9898]

Ignore, failed to notice this previously worked before 2016, apologies!!