Macro to insert sequential reference number into subject of email...

[lamensterms]

Hey guys,

Brand new to the forum, so Hi!

Just wondering if I could please have a bit of help coming up with a macro to insert a subject into an email. I am a draftsman and we number our jobs with 4 digit job numbers. I would like macro to enter a job number, plus a reference/tracking number into the email subject.

The format would be something like "XXXX (GC-001) -". Where XXXX represents the job number, and GC-001 represents a sequential tracking number to increase for each email sent (GC-001, GC-002, GC-003, etc).

The tricky part may be... I would like the latest tracking number to be read from a central database (stored on our local network), so each user can ensure that each tracking number is unique for that particular job.

I 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).

I have no experience writing macro code, so any help would be greatly appreciated.

I hope this is not asking too much.

Thanks a lot for taking the time to read.

Ps, we use Office/Outlook 2003.