Thanks Luke. I tried the your formula but it did not work. Following details might throw some light;
Event E-mail id | Date |Birthday |Marriage Anniversary | Christmas | New Year
Marriage Anniversary
Birthday
Marriage Anniversary
Christmas
Newyear
1) Event Column contains...
Hello Friends,
I have another problem with respect unlocking/locking of cells based on conditions. Following are the details:
Below are the columns in my sheet.
Column1 Cloumn2 Column3 Column4 Column5
------- ------- ------- ------- -------
Event 1 True
Event 2 False
Event 3...
Thanks, Luke. I went through that link while I was struggling through the formula. However, I am a beginner when it comes to VBA. Hence, I cannot use that code for now. I want to resolve this through the formula. Let me know if you have any ideas.
Thanks again. :)
Hello Friends,
I used a formula from this site which helped me to send an Outlook e-mail via excel.(Thanks a ton for the same).I now want to add a picture in the e-mail's body such that when I click the hyperlink in excel it automatically puts the picture,which is stored on my computer, in the...