If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Next Record if ...
Firstly, thanks for reading this. I am trying to set up a mailmerge
between Word 2003 and Excel. It's basically lists of people attending events. Participant Date Event John 18/01/06 Wine Tom 18/01/06 Wine Mick 18/01/06 Wine Mary 18/01/06 Cheese William 18/01/06 Cheese I need to print out a sheet for each event. I need word to compare Event Field and when it moves on from Wine, the Cheese participants will print out on a new sheet. Does that make sence? At the moment it is printing all the participants on to a page and when it moves on the the next page the event data changes also ie wron participants on events!! Any help would be grateful Regards, Jake |
#2
|
|||
|
|||
Next Record if ...
You are 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 Articles http://support.microsoft.com/default...b;en-us;302665 http://support.microsoft.com/default...b;en-us;294686 -- 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 wrote in message oups.com... Firstly, thanks for reading this. I am trying to set up a mailmerge between Word 2003 and Excel. It's basically lists of people attending events. Participant Date Event John 18/01/06 Wine Tom 18/01/06 Wine Mick 18/01/06 Wine Mary 18/01/06 Cheese William 18/01/06 Cheese I need to print out a sheet for each event. I need word to compare Event Field and when it moves on from Wine, the Cheese participants will print out on a new sheet. Does that make sence? At the moment it is printing all the participants on to a page and when it moves on the the next page the event data changes also ie wron participants on events!! Any help would be grateful Regards, Jake |
#3
|
|||
|
|||
Next Record if ...
Many thanks for that Doug. ~ I'll give it a go.
Regards, John Doug Robbins - Word MVP wrote: You are 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 Articles http://support.microsoft.com/default...b;en-us;302665 http://support.microsoft.com/default...b;en-us;294686 -- 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 wrote in message oups.com... Firstly, thanks for reading this. I am trying to set up a mailmerge between Word 2003 and Excel. It's basically lists of people attending events. Participant Date Event John 18/01/06 Wine Tom 18/01/06 Wine Mick 18/01/06 Wine Mary 18/01/06 Cheese William 18/01/06 Cheese I need to print out a sheet for each event. I need word to compare Event Field and when it moves on from Wine, the Cheese participants will print out on a new sheet. Does that make sence? At the moment it is printing all the participants on to a page and when it moves on the the next page the event data changes also ie wron participants on events!! Any help would be grateful Regards, Jake |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Changes record when current is saved | Matt Sonic | Using Forms | 0 | December 21st, 2005 05:56 PM |
Last (blank) record on form will not delete! | [email protected] | General Discussion | 2 | December 16th, 2005 06:16 PM |
Next Record keeps making new record even if nothing entered on for | Groucho | Using Forms | 4 | November 1st, 2005 12:49 AM |
Access and appending records | rmoritzky | General Discussion | 2 | October 20th, 2005 11:58 AM |
Copy/Paste Record Problem | Rob Parker | Using Forms | 4 | May 12th, 2005 09:24 AM |