I'm currently looking at creating an automated field entry for reports at my company, extracting the data from an excel file. What I want, is to enter a job number, and it to automatically fill in the title field, author field, and client field from the job number. Essentially it's a lookup from word to excel.



I know that mail merge is a way of linking excel data through to word, but I haven't been able to find a way to have a specific entry to go through as opposed to the entire data field.


If anybody can give me any help on this it would be fantastic.