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) You can download the sample code from http://www.outlookcode.com/member/book.aspx

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

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


"Chuck Rich" wrote in message ...
I'd like to use a sequential auto generated number in one of my Public
Folder Post forms. Is there a VBA script available for that or do I need to
link to an Access db to generate an auto number? If so, how?

Thanks