Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-23-2014, 11:01 AM
cjw cjw is offline Mail Merge - Send Each Category to a New Page Windows 7 64bit Mail Merge - Send Each Category to a New Page Office 2010 32bit
Novice
Mail Merge - Send Each Category to a New Page
 
Join Date: Oct 2014
Posts: 2
cjw is on a distinguished road
Unhappy Mail Merge - Send Each Category to a New Page

I want to create a list of contact information of participants by table where they are seated. I also want one page for each table. The code below does what I need, except that it prints one page per person, instead of one page per table. Can anyone help?

{QUOTE{IF{MERGESEQ}=1 {SET Key””}}”{IF{MERGEFIELD Table}<>{REF Key}


“IF{MERGESEQ}>1}
Table {MERGEFIELD Table}
SET Key {MERGEFIELD Table}}”}
{MERGEFIELD First_} {MERGEFIELD Last} {MERGEFIELD Email}
{MERGEFIELD Street} {MERGEFIELD Phone}
{MERGEFIELD City_State}

“}
Reply With Quote
  #2  
Old 10-23-2014, 12:20 PM
macropod's Avatar
macropod macropod is offline Mail Merge - Send Each Category to a New Page Windows 7 64bit Mail Merge - Send Each Category to a New Page Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,224
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Your description suggests you're using a Letter merge instead of a Directory merge. Plus your field construction is missing the code that actually inserts the page break. It should be:
{QUOTE{IF{MERGESEQ}= 1 {SET Key ""}}"{IF{MERGEFIELD Table}<> {REF Key} "{IF{MERGESEQ}> 1 {QUOTE 12}}Table {MERGEFIELD Table}{SET Key {MERGEFIELD Table}}¶
" }{MERGEFIELD First_} {MERGEFIELD Last} {MERGEFIELD Email}¶
{MERGEFIELD Street} {MERGEFIELD Phone}¶
{MERGEFIELD City_State}¶
"}
where the ¶ is a real paragraph/line break.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-23-2014, 01:25 PM
cjw cjw is offline Mail Merge - Send Each Category to a New Page Windows 7 64bit Mail Merge - Send Each Category to a New Page Office 2010 32bit
Novice
Mail Merge - Send Each Category to a New Page
 
Join Date: Oct 2014
Posts: 2
cjw is on a distinguished road
Thumbs up Thanks

Paul,

Thank you for such a quick reply! That worked perfectly.
Reply With Quote
Reply

Tags
categories, mail merge, page break

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge - Send Each Category to a New Page Mail Merging - Mergeseq + Send Via Email Merge toughiv Mail Merge 38 10-24-2014 06:58 PM
Mail Merge - Send Each Category to a New Page How to use mail merge to create a list sorted by category in Word elisa2013 Mail Merge 5 03-14-2014 02:35 AM
Mail Merge - Send Each Category to a New Page mail merge in excel to send pdf forms heyullama Excel 7 12-01-2013 03:32 PM
Send e-mail message in Finish & Merge CDTom Mail Merge 1 08-24-2012 12:52 AM
Mail Merge - Send Each Category to a New Page Need advice on category sorted e-mail merge GeoB Mail Merge 3 09-08-2011 11:03 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:57 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft