Hi westconn1,

Thanks so much for the reply.

That is an excellent point regarding when the tracking number is assigned. I had not considered the possibility that the email may not be sent, thus 'spending' a tracking number on an unsent email. Would it be possible for the routine to assign the tracking number during the send process? For example... The user could hit a button which would insert a subject prefix such as "XXXX (GC-???) - ", and then manually enter a description into subject line. Then when the user hits a "send and track" button, the macro would read the tracking number from a database, and replace "???" in the subject line with the appropriate tracking number? After which that 'used' tracking number would be written back the database, and the next time the macro is used... The next number (previous number + 1) would be used.

As far as what type of database... I guess I used the term 'database' pretty loosely. The 'number register' could be anything it needs to be. I originally thought maybe a TXT file would suffice, but I would be happy for someone to advise me on what would be best.

I really know nothing about how to achieve the result, but I am willing to learn and am open to any and all suggestions.

Thanks again for taking the time to reply.