VBOffice

Create a Serial Number

This sample creates a serial number, which you could use, for instance, to index task items.

Last modified: 2006/01/20 | Accessed: 75.399  | #15
◀ Previous sample Next sample ▶
ReplyAll ReplyAll
ReplyAll alerts you before unintentionally replying all, or if you are a confidential BCC recipient of the e-mail.

This sample creates a serial number and stores it in a simple text file. Please note, the directory must already exist while the file will automatically be created if necessary.


tip  How to add macros to Outlook
Public Function GetNextID() As Long
  Dim lCurrID As Long
  Dim File As String

  File = "C:Sample.txt"
  lCurrID = Val(ReadFile(File))
  lCurrID = lCurrID + 1
  WriteFile File, CStr(lCurrID), False
  GetNextID = lCurrID
End Function
OLKeeper OLKeeper
OLKeeper reliably prevents users from closing their Outlook window and thus possibly missing reminders or e-mails.
email  Send a message