Forum Discussion
Solved
Excel help
Dears, Could you please help me regarding the attached sheet as i want to send a recurrent email to every employee with his salary through the excel. N.B: Sheet password 123 Thanks
The sample workbook has column V for email address. The code checks that this column is not empty:
If ws1.Range("V" & r).Value <> "" Then
So it should not create an email message for rows that have no email address.
You modified the code correctly.
As I wrote in my PM, I added a folder path for the attachments; that appears to prevent the error.
Thank you so much Mr. Hans