Hi Holger,
One more little problem. If there is no email id then I inserted a dash '-' sign in that cell. At this situation the program asks email id which I want to ignore by program. At this time the pop up message should pop up as follows:
MsgBox x(i, 1) & "'s Birthday Today! & has empty E-mail address", 48
How to insert this msg into the code?
Thank you.
Mukesh
Hi, Mukesh,
I donīt get why this message doesnīt pop up in your version. If I take the workbook, alter the birthday for the first 2 entries and delete the email in Column M for the first I get that message.
You would need to clarify what else you want but again: this is not the problem on which you started the thread.
Ciao,
holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks