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.
thank you it works will, but for the embty emails it send an emails for them with the first.
is there any way to send the line that including emails only
is there any way to send the line that including emails only
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.
Dear Mr. Hans,
Could you please help me for the attached issue as i did some modification in the master data sheet (adding culumns and rearrange some of them) but it shows error when i tried to run the macro.
and sorry for send my issue in a private message.
Thanks in advance
See the attached version.
- Thank you Mr. Hans it works well.
Could you please show me where are the mistakes as i just change the new column for the Email
in the code screen
- Thank you Mr. Hans