Automatically Initialize a Field when a New Task is Created?

  • Thread starter Thread starter Rick.W.Gregory
  • Start date Start date
R

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
 
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
 
Back
Top