Excel 2003 :: VBA Code To Add Letter Suffix To Number

From an Excel 2003 workbook I generate some product labels. Each label has a 5 digit job number and a quantity that are passed to variables. If the quantity is 1, then I have no problems in printing my label. My problem is where the quantity is greater than 1. If a job has more than 1 item (can be up to 40 or 50) I need to add a series of letter (or letters) to the end of the job number.

For example:

Job number 12345
qty 1

number on label 12345

Job number 12346
qty 4

numbers on labels 12346A, 12346B, 12346C, 1234D

so that each printed label has a unique job number