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
"nospaminlich" wrote in message
...
I am trying to use Mailmerge to create invoices for attendance at a club.
This is OK where a member is invoiced for every meeting in a range of
dates
and therefore has one row of data but in my (Excel) data source I have
some
members who attend meetings between 2 dates then there's a gap then they
attend between another 2 dates. So, in my invoice for them I want to show
2
lines, 1 for each date range so they can see the breakdown.
I can't see how I can do this so would appreciate some help.
To make this a bit clearer (hopefully) this is what I mean....
Example 1 - This works fine....
John Smith
01/04/08 - 31/07/08 9 Sessions $90
Example 2
Harry Harrison - This is the one I'm stuck with....
01/04/08 - 30/04/08 4 Sessions $40
01/06/08 - 31/07/08 3 Sessions $30