If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
***Birthdays***
On Wed, 7 Jul 2004 02:49:42 -0400, "Diane Poremsky [MVP]"
wrote: you'll need a custom form that calculates the date - http://www.outlook-tips.net/howto/age_form.htm Thanks! Ok, I have a problem - I went there and the formula was there [IIf([Birthday]"None",DateDiff("yyyy",[Birthday],Date())-IIf(DateDiff("d",CDate(Month([Birthday]) & "/" & Day([Birthday]) & "/" & Year(Date())),Date())0,1,0),"")] , but the template (and/or .zip) was unavailable. So, I attempted to make a form myself. I copied the formula and opened Outlook -Contacts -View - Arrange By - Current View - Customize Current View - Fields to create a custom contact field (and theoretically, insert the formula) but there is no option to make a "new field". No doubt, I'm doing something wrong. I feel like I'm ***almost there*** but I don't know anything about this kind of thing. I thought this would be a really simple "copy and paste" customization. OOPS. Plus, I apparently need another program to retroactively activate the formula and I'm impatient and frustrated. I know, it doesn't do any good, but there you are. Any help? |
#13
|
|||
|
|||
***Birthdays***
Sorry for the dups. Agent said it didn't send.
On Fri, 09 Jul 2004 12:34:16 -0400, wrote: On Wed, 7 Jul 2004 02:49:42 -0400, "Diane Poremsky [MVP]" wrote: you'll need a custom form that calculates the date - http://www.outlook-tips.net/howto/age_form.htm Thanks! Ok, I have a problem - I went there and the formula was there [IIf([Birthday]"None",DateDiff("yyyy",[Birthday],Date())-IIf(DateDiff("d",CDate(Month([Birthday]) & "/" & Day([Birthday]) & "/" & Year(Date())),Date())0,1,0),"")] , but the template (and/or .zip) was unavailable. So, I attempted to make a form myself. I copied the formula and opened Outlook -Contacts -View - Arrange By - Current View - Customize Current View - Fields to create a custom contact field (and theoretically, insert the formula) but there is no option to make a "new field". No doubt, I'm doing something wrong. I feel like I'm ***almost there*** but I don't know anything about this kind of thing. I thought this would be a really simple "copy and paste" customization. OOPS. Plus, I apparently need another program to retroactively activate the formula and I'm impatient and frustrated. I know, it doesn't do any good, but there you are. Any help? |
#14
|
|||
|
|||
***Birthdays***
BTW, What's the difference between a "form" and a "template"?
On Tue, 06 Jul 2004 21:21:45 -0400, wrote: I'm really bad at them. Having and actually using a calendar really helps. With the one I'm used to, I can put in betsy's date of birth and the program will tell me that it's her 13th birthday ... and keep track of it the next year, etc. Can outlook do this? If not, is there a 3rd party program that does this? |
#15
|
|||
|
|||
***Birthdays***
BTW, What's the difference between a "form" and a "template"?
On Tue, 06 Jul 2004 21:21:45 -0400, wrote: I'm really bad at them. Having and actually using a calendar really helps. With the one I'm used to, I can put in betsy's date of birth and the program will tell me that it's her 13th birthday ... and keep track of it the next year, etc. Can outlook do this? If not, is there a 3rd party program that does this? |
#16
|
|||
|
|||
***Birthdays***
it;s nice to know it's not just OE and the web interface that create dups
-- wrote in message ... Sorry for the dups. Agent said it didn't send. On Fri, 09 Jul 2004 12:34:16 -0400, wrote: On Wed, 7 Jul 2004 02:49:42 -0400, "Diane Poremsky [MVP]" wrote: you'll need a custom form that calculates the date - http://www.outlook-tips.net/howto/age_form.htm Thanks! Ok, I have a problem - I went there and the formula was there [IIf([Birthday]"None",DateDiff("yyyy",[Birthday],Date())-IIf(DateDiff("d",CDate(Month([Birthday]) & "/" & Day([Birthday]) & "/" & Year(Date())),Date())0,1,0),"")] , but the template (and/or .zip) was unavailable. So, I attempted to make a form myself. I copied the formula and opened Outlook -Contacts -View - Arrange By - Current View - Customize Current View - Fields to create a custom contact field (and theoretically, insert the formula) but there is no option to make a "new field". No doubt, I'm doing something wrong. I feel like I'm ***almost there*** but I don't know anything about this kind of thing. I thought this would be a really simple "copy and paste" customization. OOPS. Plus, I apparently need another program to retroactively activate the formula and I'm impatient and frustrated. I know, it doesn't do any good, but there you are. Any help? |
#17
|
|||
|
|||
***Birthdays***
it;s nice to know it's not just OE and the web interface that create dups
-- wrote in message ... Sorry for the dups. Agent said it didn't send. On Fri, 09 Jul 2004 12:34:16 -0400, wrote: On Wed, 7 Jul 2004 02:49:42 -0400, "Diane Poremsky [MVP]" wrote: you'll need a custom form that calculates the date - http://www.outlook-tips.net/howto/age_form.htm Thanks! Ok, I have a problem - I went there and the formula was there [IIf([Birthday]"None",DateDiff("yyyy",[Birthday],Date())-IIf(DateDiff("d",CDate(Month([Birthday]) & "/" & Day([Birthday]) & "/" & Year(Date())),Date())0,1,0),"")] , but the template (and/or .zip) was unavailable. So, I attempted to make a form myself. I copied the formula and opened Outlook -Contacts -View - Arrange By - Current View - Customize Current View - Fields to create a custom contact field (and theoretically, insert the formula) but there is no option to make a "new field". No doubt, I'm doing something wrong. I feel like I'm ***almost there*** but I don't know anything about this kind of thing. I thought this would be a really simple "copy and paste" customization. OOPS. Plus, I apparently need another program to retroactively activate the formula and I'm impatient and frustrated. I know, it doesn't do any good, but there you are. Any help? |
#18
|
|||
|
|||
***Birthdays***
They are mostly the same - a form is published, a template is in the windows
file system. Forms with script need published so the script works. Try this url - I'll get the one on the site fixed tonight. http://www.outlook-tips.net/howto/files/age.oft -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Author, Google and Other Search Engines (Visual QuickStart Guide) Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com Join OneNote Tips mailing list: http://www.onenote-tips.net/ Vote for your favorite Outlook and Exchange utilities in the Slipstick Ratings Raffle at http://www.slipstick.com/contest/ wrote in message ... BTW, What's the difference between a "form" and a "template"? On Tue, 06 Jul 2004 21:21:45 -0400, wrote: I'm really bad at them. Having and actually using a calendar really helps. With the one I'm used to, I can put in betsy's date of birth and the program will tell me that it's her 13th birthday ... and keep track of it the next year, etc. Can outlook do this? If not, is there a 3rd party program that does this? |
#19
|
|||
|
|||
***Birthdays***
They are mostly the same - a form is published, a template is in the windows
file system. Forms with script need published so the script works. Try this url - I'll get the one on the site fixed tonight. http://www.outlook-tips.net/howto/files/age.oft -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Author, Google and Other Search Engines (Visual QuickStart Guide) Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com Join OneNote Tips mailing list: http://www.onenote-tips.net/ Vote for your favorite Outlook and Exchange utilities in the Slipstick Ratings Raffle at http://www.slipstick.com/contest/ wrote in message ... BTW, What's the difference between a "form" and a "template"? On Tue, 06 Jul 2004 21:21:45 -0400, wrote: I'm really bad at them. Having and actually using a calendar really helps. With the one I'm used to, I can put in betsy's date of birth and the program will tell me that it's her 13th birthday ... and keep track of it the next year, etc. Can outlook do this? If not, is there a 3rd party program that does this? |
|
Thread Tools | |
Display Modes | |
|
|