Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-14-2015, 06:33 AM
versjan versjan is offline label merge category based... Windows 8 label merge category based... Office 2013
Novice
label merge category based...
 
Join Date: Jul 2015
Posts: 2
versjan is on a distinguished road
Default label merge category based...

https://support.microsoft.com/en-us/kb/294686 is working but I want to get this working with labels and not with pages.... is this possible?

Reply With Quote
  #2  
Old 07-14-2015, 03:14 PM
macropod's Avatar
macropod macropod is offline label merge category based... Windows 7 64bit label merge category based... 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

Perhaps you could explain what you're trying to achieve? Directory/Catalogue merges and label merges are quite different.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 07-14-2015, 08:58 PM
gmayor's Avatar
gmayor gmayor is offline label merge category based... Windows 7 64bit label merge category based... Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 3,570
gmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to behold
Default

If based on your message title, and reading between the lines, you mean merge by Outlook categories, then the link is not the way forward. You must start the merge to labels from Outlook - see http://www.gmayor.com/mailmerge_from_outlook.htm
__________________
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
  #4  
Old 07-15-2015, 12:53 AM
versjan versjan is offline label merge category based... Windows 8 label merge category based... Office 2013
Novice
label merge category based...
 
Join Date: Jul 2015
Posts: 2
versjan is on a distinguished road
Default

Thanks for the fast replies on this topic!
Setup:
xls with Registration for swimming championchips
xls contains a row per stroke (for example row1 "athleteid" "distance & stroke" "entry time")
so multiple rows for 1 athleteid or possible...
I solved this by merging rows, afterwards it was easy to merge the labels

1) installed extra ribbon ablebits data -> combine rows & delete doubles
2) max subscriptions for each athlete is 8, so in my label layout I entered a table with 8 rows... so rows not needed will not be shown

setup was to create a badge for each athlete with his name, id and all the strokes she or he has to do (with the necessary info available like heat/lane/...)

If somebody needs further explanation, shoot!
Reply With Quote
  #5  
Old 07-15-2015, 01:06 AM
macropod's Avatar
macropod macropod is offline label merge category based... Windows 7 64bit label merge category based... 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

OK, for future reference, to get multiple records onto the same label without modifying the data source, you'd need to use a DATABASE field in conjunction with the mailmerge. This can be quite fiddly to set up.

If re-arranging the data source isn't an issue, you could have, say, one row per competitor, with a separate column for each event. It then becomes a fairly simple matter of inserting all the event fields into each label, with the appropriate switches to suppress empty lines.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
label merge category based... Mail Merge - Send Each Category to a New Page cjw Mail Merge 2 10-23-2014 01:25 PM
label merge category based... How to start a label mail merge at a specific label? DHKaplan Mail Merge 2 04-17-2014 07:33 PM
label merge category based... Need advice on category sorted e-mail merge GeoB Mail Merge 3 09-08-2011 11:03 PM
Record Retention based off Category jerelp Outlook 0 02-18-2010 08:06 AM
Archive rule based on Category jerelp Outlook 0 02-18-2010 08:04 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:41 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