bdouglas1011
New Member
- Joined
- Jul 28, 2014
- Messages
- 38
I have this code
Sometimes it looks for a file that did not get generated but I would like it to continue and just give a message to correct it for next time.
It is a runtime error saying cant find file verify path and name are correct.
Is this possible
VBA Code:
With olEmail
.Display
.HTMLBody = EmailBody & .HTMLBody
.To = GetSurveyEmailDistList
.CC = GetSurveyEmailCCList & "[EMAIL]Remote@legacydirectional.com[/EMAIL]"
.Subject = ESubject
'Attach files. The var "i" should start at the first row of file names, and go to the last row
For i = row + 2 To row + 15
If cells(i, col).Value = "Yes" Then
.Attachments.Add (Directory & cells(i, col + 2).Value)
End If
Next i
End With
Sometimes it looks for a file that did not get generated but I would like it to continue and just give a message to correct it for next time.
It is a runtime error saying cant find file verify path and name are correct.
Is this possible