Okay, I think I found a work around by modifying the Birthdayreminder template. I'll be using the cell references from there so you can follow along. On the birth-day reminder worksheet, remove all the formulas from the Mail Link column. We'll be using this column to flag which emails have...
I'd check out these templates of Chandoo then, either a basic hyperlink template:
http://chandoo.org/wp/2010/10/26/birthday-reminder-template/
Or this more VB intensive version:
http://chandoo.org/wp/2012/04/23/send-mails-using-excel-vba-and-outlook/
The latter gives you more control over...
...a criteria to generate a Mail Link that takes input for the Receiver Name, Subject and Body from the Excel cells (Similar to the BirthdayReminder in this site). In the body of the message I need to send the Expiry Date of the Software. In the genarted mail link, the date field is substituted...
@NOVICE007,
You also may want to look at the following thread to adapt the technique to your need.
http://chandoo.org/wp/2010/10/26/birthday-reminder-template/
Kaushik
Hallo everybody.
first of all thank you an Chandoo for such great site for excel.
I have read the artikel about birthdayreminder where you can use HYPERLINK() formula to generate a mailto hyperlink and it was very helpful because due my work I need to work on Excel sheet without macros.
I...
Hi Chandoo.
I saw you video about BirthdayReminder.
And i have quarry about this field i.e. if we have 50 friends out of 100 and their birthday falls in particular day (12-12-11). and we want to attached a photos each person but different. how we can do this???
kindly explain it...
Sjagan
Firstly, Welcome to the Chandoo.org Forums
Did you actually try typing BirthdayReminder in the Google Search Box at the Top Right corner of every page at Chandoo.org?
...helps me, I had hoped there was a way to set up a distribution list in Excel containing a list of emails i.d. which I could attach to a button perhaps and have that populate an email with a message ,,, i guess king of similar to the Birthdayreminder workbook posted by Chandoo a while back.
Hi Chandoo,
Thanks a lot for sharing the excellent excel stuffs with all.
I have one question regarding 'Birthday Reminder in Excel'.
I can't use this function where in the mail body is big or has more number of charaters. Is there any way in which we can use this function for mail body...