Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
nospaminlich nospaminlich is offline
external usenet poster
 
Posts: 3
Default Including multiple records in Mailmerge Doc

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


  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Including multiple records in Mailmerge Doc

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




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mailmerge MS Access multiple records EiEiohh Mailmerge 2 February 20th 08 12:38 PM
Mailmerge multiple records in same letter SJ Microsoft Word Help 2 June 14th 07 05:46 PM
deleting multiple pages including all formatting Scheduler Microsoft Word Help 1 June 2nd 06 09:23 AM
Include all page Numbers in TOC including multiple TOC pages. Paul, Eagle Av. Microsoft Word Help 1 October 3rd 05 09:36 AM
How do I get multiple Access records into a single mailmerge lett. Wiley W. Mailmerge 1 December 18th 04 05:47 PM


All times are GMT +1. The time now is 10:09 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"