Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 09-29-2013, 07:44 PM
macropod's Avatar
macropod macropod is offline how to show identical data once only? Windows 7 32bit how to show identical data once only? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi heidiau,

You could do this with some field coding.
First, insert a field coded as follows at the top of your document:
{IF MERGESEQ = 1 {SET School " "}}
Then, where your existing mergefield is, replace it with a field coded as follows:
{IF{REF School}<> {MERGEFIELD School_Name} {MERGEFIELD School_Name} ""}
Finally, insert a field coded as follows at the bottom of your document:
{SET School {MERGEFIELD School_Name}}

The above assumes your mailmerge field is named 'School_Name' - change it to match the actual field name.

Note: The field brace pairs (ie '{ }') for the above example are created in the body of the document via Ctrl-F9 (Cmd-F9 on a Mac) - you can't simply type them or copy & paste them from this message.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple identical fields snorkerz Word 4 06-25-2012 02:30 PM
how to show identical data once only? Two identical reports - merge fields into one of them cyndor Excel 3 06-21-2012 06:24 PM
how to show identical data once only? Show Items with no data DeborahBartlett Excel 1 01-24-2012 01:10 AM
how to show identical data once only? Copy from one word document to another no identical gmurphy Word 3 09-07-2011 04:28 AM
Show different Data depending on Imput Value Aton Word 0 09-15-2010 03:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:02 AM.


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