Hi,

I have a Word template that contains several docvariables, including a reference number (varRef). As it is right now, the user manually inputs the unique reference number into a userform but it would work better if this could be automated, with a specific format i.e. YY/0000 (eg 16/0001). I need the new document's reference number to increment by 1, but ideally recycle the number if the new document is abandoned.

I've tried a few solutions that I've seen elsewhere but nothing has worked so far and I would really appreciate any advice.

Many thanks,

Anne