Search results for query: birthday reminder

Now this is perfect thank's a lot Hui

Whoops didn't look at all the code try this: Sub Reminder() Dim LR As Long, i As Long, msg As String 'With Sheets("Sheet1") With ActiveSheet LR = .Range("c" & Rows.Count).End(xlUp).Row For i = 1 To LR If IsDate(.Range("c" & i)) Then 'If .Range("A" & i).Value - Date < 30 Then...

Thank you Very much Hui this is what I wanted thanks a lot

Sub Reminder() Dim LR As Long, i As Long, msg As String With Sheets("Sheet1") LR = .Range("c" & Rows.Count).End(xlUp).Row For i = 1 To LR If IsDate(.Range("c" & i)) Then 'If .Range("A" & i).Value - Date < 30 Then If .Range("c" & i).Value >= Date And .Range("c" & i).Value <= Date +...

I want to make a birthday reminder with a popup message box, the below code works perfect if the birthday is between two dates i.e. if the birthday date is between today and next 14 days, but if there is no birthday in next 15 days than the message box popup does not work. I want the message...

Hi Niraj, Have you checked out some of the templates Chandoo has built previously? http://chandoo.org/wp/2010/10/26/birthday-reminder-template/

Hi Narayan, Thanks for your kind response. I have not yet got a workbook. I just followed Chandoo's Birthday Reminder video which is very brilliant in demonstrating how this could be done. However, in his video demonstration, he showed (with formula) how someone's birthday could be highlighted...

Hi Team, I have use ur blog to create a birthday reminder which is working fine, but only thing i want is instead a text in the body i want a jpg picture to be pasted in the body. =IF(AND(DAY(E45)=DAY(TODAY()),MONTH(E45)=MONTH(TODAY())),HYPERLINK("mailto:"&G45&"?subject="&$D$2&""&D45&" -...

Check out the code Chandoo used for his birthday reminder, which uses a similar idea for sending email on certain day. http://chandoo.org/wp/2010/10/26/birthday-reminder-template/

@Afarag Hi! When posting code do it in the proper window pane (5th icon from the right of the ribbon bar) or use the shortcut indicated just over that bar in the Reply text box. Regards! @Abhijeet Hi! I was yet missing your motto...

birthday reminder - how do I put mail body text to the right? I have used your template whith the Hiperlink code and would like to add an other code in order to align the text body to the right. Thank you Rico

Hi I want which dates are in the month those names.Which day before one day i want pop up & message card .Please give me Macro for this

Hai all, Again i came with some VBA doubt for my previous question. at last i have prepared nice excel birthday reminder which shows today's birthdays and coming 30 days birthdays. and i have put one button which sends mail to that concern person. 1)Now coming to the point in my VBA code...

Hai friends, Thanks for your suggestions.Now the formula works perfectly. For your reference i have attached my file . This file is for Birthdays reminder for that day and for coming 30 days birthdays. 1)In this file for Today's Birthday array formula in reminder sheet , i notice that #NUM...

Hi, praneethone! If you haven't performed yet the search herein, try going to the topmost right zone of this page (Search...), type the keywords used in the title when creating the topic or other proper words and press Search button. You'd retrieve many links from this website, like the...

Dear All, I would like have Cc: in birthday reminder workbook while sending. Please do help me out in this regard. Pls find attached file for requirement. Thanks in advance. Regards, Praneeth

Thanks a lot for your support please find the attached file. for example "Birthday Reminder Worksheet" ,when birthday (C9,C10,....)= current day , send email automaticly. BR

Free Birthday Reminder Template - Download today | Chandoo.org - Learn Microsoft Excel Online says: October 26, 2010 at 8:28 am http://chandoo.org/wp/2010/10/26/birthday-reminder-template/

Hi Dear, please see "birthday-reminder-workbook.xls" in download page,now , I want create button ,for example : when click on the button : - if E9="send e-mail" , active hyperlink and send email automaticly. please help . Thanks

Hi There Could someone please have a look at my uploaded file and kindly have a look at a formula I need to work out for a birthday reminder worksheet I have set up from Chandoo's fantastic 'birthday reminder' tutorial on YouTube. It all works absolutely fine for except when I have put in the...

You could probably use the same technique Chandoo used in the birthday reminder. http://chandoo.org/wp/2010/10/26/birthday-reminder-template/

Double posting is frowned on, the forum members lead their own lives, work, home, interests ect ect, and they answer questions and offer help willingly and for free. The world is a 24hr place and members live around the globe in different time zones, you may be up and about others may be...

By using hyperlink formula we can send(auto draft)mail. This was shown in Birthday reminder excel created by chandoo https://www.youtube.com/watch?v=uwaoP3A3Qyg Just wanted to know how to add "from" and "CC". PFB the hyperlink formula used to draft mail with "to", "subject" and "mailbody"...

how can we add cc and from in birthday reminder excel created using hyperlink formula.

Thinking outside the box, and trying to get a nice template start, check out Chandoo's Birthday reminder here: http://chandoo.org/wp/2010/10/26/birthday-reminder-template/ The tool uses formulas instead of macros. Granted, this is designed for birthdays, but the general idea is still the same...