Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
Question to MailMerge expert
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 |
#2
Posted to microsoft.public.word.newusers
|
|||
|
|||
Question to MailMerge expert
Sounds like you are probably trying to perform a "multiple items per
condition (=key field)" mailmerge which Word does not really have the ability to do: See the "Group Multiple items for a single condition" item on fellow MVP Cindy Meister's website at http://homepage.swissonline.ch/cindy...faq1.htm#DBPic Or take a look at the following Knowledge Base Article http://support.microsoft.com/default...b;en-us;211303 or at: http://cornell.veplan.net/article.aspx?&a=3815 -- 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 "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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question to MailMerge expert | Microsoft Word Help | |||
Mailmerge and VBA Question | Mailmerge | |||
Another mailmerge question | New Users | |||
I need a mail merge expert for one question. | Mailmerge | |||
Another mailmerge from Excel question | Mailmerge |