How to add data from 4 different excel sheets on the same page (mail merge)

Dear Experts,
How to add data from 4 different excel sheets on the same page of ms word.
please view sample pages attached.

thanks
roofi

A mailmerge can only use one data source, which in this case means one worksheet. Since you only have 100 data rows per sheet, it would hardly be taxing for Excel to have all the data on just one sheet - Excel 2007 & later can handle 1,048,576 rows per sheet.

ARGK: The title does say 'mail merge'.

Dear Macropod

thanks for your valued reply. ok i understand.
then what to do if i have one data source but i have to print 4 or 5 records on the same page in mail merge output.?

thanks n regards
Roofi

That's quite simple - use a directory or label merge.

<<deleted>>

DrNicket, your question is not related to the original question, even though it may have some similarities.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.