Database field in Word to lookup a cell in an excel workbook

[BeJay]

Hi all,

Probably very simple query but any help would be great.

Have successfully been able to insert a whole worksheet using database
field into my merge document using the worksheet name as the link to
the data from my progress database - the main data source.

I now to create another database field to merge just 1 cell of data
from Excel.

I.e. where { MERGEFIELD CUSTOMER REF } = A10000 (in progress), find
A10000 in column A(in excel) and insert the value from column B

I can only insert the entire workbook.

Thanks in advance for any help

Cheers, Bev