Virginia,
Thank you very much for your reply.
That is what I was afraid of - there is no simply solution using MailMerge.
I thought about rearranging the data. I would have to make 2 additional
copies of each record and insert them just after the "original" row.
In the first of 3 copies (in the "original") I would have to leave the data
for the first subject only, in the second of 3 copies to leave the data
for the second subject only and in the third copy of 3 copies to leave
the data for the third subject only.
I must admit that it is too difficult for me at the moment. I am not so good
at creating macros. In fact I am not good at it at all :-(
I think I'll have to merge the data for each subject separately and then
put the Word pages in order manually. :-(
Regards,
Zoska
Użytkownik "Earl Kiosterud" napisał w wiadomości ...
Zoska,
The mail merge produces one document for each record (Excel row). I think that's immutable. So I believe you'll have to get your
data rearranged so that there's a row for each Word document you want to be produced in the mail merge. Perhaps a macro that
produces another sheet in the necessary layout for the merge data source.
--
Regards from Virginia Beach,
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Zoska" wrote in message ...
Hi,
I have been using MailMerge for some time, usually to get
1 Word page from each Excel record.
Sometimes I use Skip a record if... when I want to skip some
records.
Now I have a new task and problem.
Fields (columns) in an Excel sheet are grouped into 3 groups,
each connected with different subject. Each subject must be
merged into a separate Word page. However in some records
all data for a subject can be equal to zero, so from 1 Excel
record I can get 1 or 2 or 3 Word pages depending on the data.
So the question is: how to get 1 or 2 or 3 Word pages from
each Excel record using the MailMerge?
I still use the MS Office 97 but if necessary I can install w newer
version of the programs.
I would be very grateful if someone could help me.
Regards,
Zoska