Auto number in custom task form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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/articles/ricardosilva/vbscriptoutforms.asp

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