Including multiple records in Mailmerge Doc

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nospaminlich - 14 Apr 2008 17:49 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 14 Apr 2008 20:59 GMT

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/cindymeister/mergfaq1.htm#DBPic

Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

or at:

http://cornell.veplan.net/article.aspx?&a=3815

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 am trying to use Mailmerge to create invoices for attendance at a club.
>
[quoted text clipped - 23 lines]
> 01/04/08 - 30/04/08 4 Sessions $40
> 01/06/08 - 31/07/08 3 Sessions $30

Reply to this Message

Rate this thread: