Word can only use one sheet as the mailmerge data source. Therefore you
will need to add another sheet to the file and on it reference in a column
for each week, the cells C33 and F4 from the other 52 sheets and then use
that sheet as the data source for the mail merge.

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

"Kevin J Prince" wrote in message
...
OK all you clever ones will say a brain.....

I need to mail merge some data from an excel workbook, the workbook
consists of some 62 worksheets. 52 of which are identical structure but
with different (guess what ) weeks information in them.

I need to access the information from each of these 52 worksheets, the
cells in question are C33 and F4. How do I reference these in a Word mail
merge document?

I just do not seem to be able to get anything to work... I have labelled
C33 and F4, but even using the correct worksheet ref and the cell labels
or cell reference just wont work.

HELP please what have I missed.

Regards

--
Kevin J Prince