the tracking number should only be update on sending, to prevent multiple users getting the same number or numbers getting omitted if an email is cancelled for any reason, the database would also need to be updated immediately after use of current numberI was thinking the job number could be requested by the macro... So when the macro is executed, a text input box would open asking the user for the job number, then the macro would read the last tracking number from that job's database (or text file).
without knowing the type of database, hard to make working code, but presumably you can access the database using ADO, read the number to variable, update the number, then format the variable into message subject
how is the number stored in the database?
would the number be appended or prepended to any other subject string?
Reply With Quote