I need Outlook to assign a unique number to each new task that is entered by
many users sharing the same task folder.
The unique number will consist of yyyymmxxxx (where xxxx is a running number
from 0001 to 9999).
The number will be entered in to a custom field each time a new task form is
saved.
Can this be done?
Many thanks

If you need a sequential number, not just a unique number, here are some methods you can use:

1) 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)

2) In a custom Outlook form, republish the form after each use to reset the number. See http://www.outlookexchange.com/artic...ptoutforms.asp

3) Use an Excel worksheet that contains VBA code to increment the number. See http://www.microsoft.com/office/comm...a-1324e136ff3a

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Paul White" wrote in message ...
I need Outlook to assign a unique number to each new task that is entered by
many users sharing the same task folder.
The unique number will consist of yyyymmxxxx (where xxxx is a running number
from 0001 to 9999).
The number will be entered in to a custom field each time a new task form is
saved.
Can this be done?
Many thanks