Mailmerge can only use a single flat datasource. I assume that what you
need to do is create two formletter merges, one for each worksheet, with
different content for each worksheet and then you want to create labels for
both letters. What you should do, so that the label merge can be executed
in one go, is to create a third worksheet into which you copy and paste the
relevant data from each of the other two worksheets.
There will be an issue if you later add records to the individual worksheets
as you will have to remember to copy the records to the "label" worksheet.
On the other hand, if you have Access, you could have each of the original
two worksheets as a separate table and use a union query to combine them and
form the source of the label type mailmerge. Then you would only have to
enter new records one time.

Signature
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
>I have an excel workbook that contains two separate worksheets for separate
> school member info. I need to create a mail merge letter and
[quoted text clipped - 6 lines]
>
> Please advise
Nursery School Volunteer - 07 Aug 2005 17:08 GMT
Thanks Doug. That is one limitation of mail merge I would like to see
enhanced. You are right, the best possible solution is combine the two
separate data onto a separate worksheet specifically for labels. I was just
hoping that somehow the "concantenanate" function would work on this type of
task also.
Thanks again.
Linda
> Mailmerge can only use a single flat datasource. I assume that what you
> need to do is create two formletter merges, one for each worksheet, with
[quoted text clipped - 21 lines]
> >
> > Please advise