Hello
I've inserted an image of my spreadsheet and its pretty simple. I need Excel to send me an email on the first of each month to alert me when one of my employees has a birthday that month. The employee names are in cells B3:B12 and their dates of birth are in cells C3:C12. I'd like the email to tell me the name and DOB of each person who has a birthday that month. I have Excel 2010 but I'm not a programmer.
Put the following in the VBA for "ThisWorkbook"
And this in a Module
Please Login or Register to view this content.
Please Login or Register to view this content.
Thanks for your help. I plugged it in but I don't know if it works. I'll wait and see if I get an email
Thats probably not a good way to test, why not set up a fake employee or two or even just change the dates of 2 or 3 to this month?Originally Posted by worthm
If someone has helped you then please add to their Reputation
Thanks, that's good advice. I've added the two programming pieces to the right places and Ive also added two people which dates of birth of 11/15 and 11/20 but so far nothing has gone to my email address. I also changed the a = SendeMail("[email protected]", part to change the dummy email address to my own email address. Still nothing
And have you checked your open emails? the code as I posted it is designed to write the mail and Display it ready for the user to hit Send (once youve tested it you can then change that to .Send and it will send without user intervention. Do you have an open email sitting? Is there a date in A1?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks