Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-05-2020, 04:03 PM
tbdesigns tbdesigns is offline How to skip repetitive lines to unique entries? Windows 10 How to skip repetitive lines to unique entries? Office 2019
Novice
How to skip repetitive lines to unique entries?
 
Join Date: Jul 2020
Posts: 2
tbdesigns is on a distinguished road
Default How to skip repetitive lines to unique entries?

Hi,

I have a document where i need to skip repetitive lines until it comes to a unique entry.
I'm using an excel sheet and mail merging into a word directory.

For example :
https://media.publit.io/file/Annotat...-06-085617.png

If i have a book series title in one column, and the books in that series in another column. I would like the mail merge to print the book series title out once, and then the entries for the books underneath it. And then only print the next book series title if it's different to the one before.


So it would look like this :
Book series A

Book title 1


lorem ipsum doler sit

Book title 2
lorem ipsum doler sit

Book title 3
lorem ipsum doler sit

Book series B

Book title 1, etc

Currently it prints the book series for every entry.

EDIT: after some more Googling I think what I'm after is a list sorted by category? I'm pretty new to Mail-merge though so I'm not sure if that's correct.

Cheers,
Tara

Last edited by tbdesigns; 07-05-2020 at 08:08 PM.
Reply With Quote
  #2  
Old 07-05-2020, 11:04 PM
gmayor's Avatar
gmayor gmayor is offline How to skip repetitive lines to unique entries? Windows 10 How to skip repetitive lines to unique entries? Office 2016
Expert
 
Join Date: Aug 2014
Posts: 3,216
gmayor is a glorious beacon of lightgmayor is a glorious beacon of lightgmayor is a glorious beacon of lightgmayor is a glorious beacon of lightgmayor is a glorious beacon of lightgmayor is a glorious beacon of light
Default

See the sticky post at the start of the forum - https://www.msofficeforums.com/mail-...-tutorial.html
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Office 365 repetitive corruption? markg2 Office 0 10-23-2019 04:18 AM
How to skip repetitive lines to unique entries? alphabetize a list (manual index) with entries and sub-entries shmu Word 5 08-01-2016 11:15 PM
How to skip repetitive lines to unique entries? Entries of Drop-Down Box shall trigger lines/words Tim Tayler Word VBA 1 01-21-2016 01:48 PM
automating a repetitive process vthomeschoolmom Excel Programming 1 02-28-2012 07:41 PM
How to skip repetitive lines to unique entries? repetitive work in word vishalvijayan Word 1 03-31-2011 08:30 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 12:57 PM.


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