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.

No, but using Access you could set up links to the Excel Spreadsheets and
then use a Query to combine the information for use as a mailmerge
datasource.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Raj" . wrote in message
...
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.