#1
|
|||
|
|||
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?
|
#2
|
||||
|
||||
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] |
#3
|
||||
|
||||
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 |
#4
|
|||
|
|||
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! |
#5
|
||||
|
||||
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] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge - Send Each Category to a New Page | cjw | Mail Merge | 2 | 10-23-2014 01:25 PM |
How to start a label mail merge at a specific label? | DHKaplan | Mail Merge | 2 | 04-17-2014 07:33 PM |
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 |