In order to use mail merge you must have one worksheet,
that worksheet must be the first worksheet in the workbook
and each label generated must get it's data from a row on
that spreadsheet.
You appear to have the exact opposite of all requirements.
Seems that the system is very poorly designed, and that it
should have been a database application. If these spreadsheets
were actually generated from some other system then you
should be getting your data from that source.
The cells from each workbook I require are H3, H4, H5 and K6.
Not only do you not have cells in sheet you have them across
multiple workbook, you have them in a column instead of a row.
You will have to write a macro to read the directory/directories
that the workbooks are in, get the fields out of the worksheets
you need to get them out of.
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"SmokingMirror" wrote in message
news:SmokingMirror.1wf8ya_1128503116.7755@excelfor um-nospam.com...
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