Automatically Initialize a Field when a New Task is Created?

[Rick.W.Gregory]

I would like outlook to automatically assign a "Case Number" to all my
tasks when they are created. Logically, I want the numbers to begin at
a certain number and then increase by one every time a new task is
created (accumulator).

Can Outlook 2003 handle this? Is this possible?

Thanks.
--Rick

 

[Sue Mosher [MVP-Outlook]]

Yes, that would be possible with code behind a custom task form. If you need a sequential number, not just a unique number, here are some methods you can use:

3) Use an autonumber table in SQL Server or Microsoft Access. (In my book, Listing 23.7 with Listing 23.4 or 23.3 to open the database. You can download the sample code from http://www.outlookcode.com/member/book.aspx )

4) In a custom Outlook form, republish the form after each use to reset the number. See http://www.outlookexchange.com/articles/ricardosilva/vbscriptoutforms.asp

5) Use an Excel worksheet that contains VBA code to increment the number. See http://www.microsoft.com/office/com...sers&mid=5489e140-9794-41b7-a9ba-1324e136ff3a



--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers