Hi

Is there a way I can use some sort of lookup function from word into Excel
when I am mail merging.

Basically I have an Excel spreadsheet (AandR.XLS) that is generated by
another application the Excel spreadsheet (AandR.XLS) is overwritten every
time this other application runs.

I mail merge most of the data in word using the above excel spreadsheet
(AandR.xls) as the data source, except a set of values that I need to lookup
in another excel spreadsheet (HOD.xls).

I cannot incorporate data from HOD.xls into AandR.xls as the AandR.xls file
is overwritten each time my external application runs.

So is there a clever way in Word that I can use lookup into the HOD.xls
using one of the mail-merged fields as the basis of the lookup.

Many thanks in advance.