Thanks for the advice guys, but I'm afraid I can't get it to work as it
should. The mail merge idea should probably function, but as far as I
can see, I need to still manually select and edit every single record
to make the labels.

Additionally, I don't seem to be able to get Mail Merge to actually
extract the data I need from the Excel sheet. I can get up a listing
of the data, but I can't get anything to populate onto the Word
document.

The cells from each workbook I require are H3, H4, H5 and K6.


Can anybody please suggest anything that can help me automatically
extract the contents of these cells on hundreds of different records,
and put them into a single document, whether Excel or Word?


--
SmokingMirror
------------------------------------------------------------------------
SmokingMirror's Profile: http://www.excelforum.com/member.php...o&userid=12225
View this thread: http://www.excelforum.com/showthread...hreadid=472899