Ok, so here goes....

The reference number is the URN generated by our case management system (which should also have been designed to produce a cover sheet....)

The reference number 22 characters long and is broken down into a number of differing components and would look like this; LON/00AJ/OLR/2015/0300

For this problem I'm looking for Word to be able to identify the bold highlighted part of the URN and return information in another field. For our example OLR would populate three fields within the word document with the following information; Field 1, New Lease of Flat, Field 2, Leasehold Reform Housing and Urban Development Act 1993 and Field 3, Section 48 There are 122 differing codes and they are detailed in the 2nd tab of the worksheet attached to my first post.