I am trying to attach a file I have saved to the desktop to an Outlook Object. Outlook seems to ignore the file though. Any help would be much appreciated.
v_WksFldrDest = CreateObject("WScript.Shell").SpecialFolders("Desktop") & Application.PathSeparator
EmailAttachDest= v_WksFldrDest & v_TempFileName
Dim OutApp As Object
Dim OutMail As Object
Dim strbody As String
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
strbody = Range(ReviewerName & "ReqBy_EmailTxt").Value & vbNewLine & vbNewLine & _
"Please reply to: " & Range(ReviewerName & "ReplyTo_Name").Value & _
" at " & Range(ReviewerName & "ReplyTo_Email").Value & " and CC to " & Range(ReviewerName & "ReplyCC_Email").Value
On Error Resume Next
With OutMail
.To = Range(GKName & "_GatekeeperEmail").Value
.CC = Range(ReviewerName & "ReqCC_Email").Value
.BCC = ""
.Subject = v_TempFileName
.Body = strbody
'You can add a file like this
.Attachments.Add (EmailAttachDest)
'.Send or use
.Display
End With
On Error GoTo 0
Set OutMail = Nothing
Set OutApp = Nothing