Word can only use a single, flat datasource for mailmerge. You will have to
add a 5th worksheet to the file on which to bring together in the one place
all of the required information from the other four sheets.

--
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

"Donna" wrote in message
...
I need to do a mailmerge containing data from 4 worksheets from 1
spreadsheet
document. How do I select all 4 worksheets in order to merge the data?