Hi,
I am preparing a macro to send lotus notes mail. I have written the code and it is working fine.Following is the test data I have.
I have to send mail to the mail IDs listed in Column titled "Team" for the rows which have blank values. Condition being "Current date should be equal to the column date". Whichever column date is equal to the current date, system should consider only that column and should send mail to that specific mail IDs for blank values only in that column. I am not sure as to how to write that condition. Request your help in this regard.
Right now, I am manually giving the column name in the code. But I would like to automate this too coz am planning to schedule this activity. Please help!!
<tbody>
</tbody>
I am preparing a macro to send lotus notes mail. I have written the code and it is working fine.Following is the test data I have.
I have to send mail to the mail IDs listed in Column titled "Team" for the rows which have blank values. Condition being "Current date should be equal to the column date". Whichever column date is equal to the current date, system should consider only that column and should send mail to that specific mail IDs for blank values only in that column. I am not sure as to how to write that condition. Request your help in this regard.
Right now, I am manually giving the column name in the code. But I would like to automate this too coz am planning to schedule this activity. Please help!!
| Team | 4/1/2013 | 4/8/2013 | 4/15/2013 | 4/22/2013 | 4/29/2013 |
| A@abc.com | Y | N | N | Y | |
| B@abc.com | Y | N | N | ||
| C@abc.com | Y | N | Y | N | |
| D@abc.com | N | N | N |
<tbody>
</tbody>
