Conditional Formatting a Mail Merge Label

S

Steve

Hi I need to create labels for some storage shelves and thought mail merging
excel and word would be a good idea. I need to create labels using different
coloured font depending on the type of item. I can use the following code to
change the formatting

{If{MERGEFIELD “Categoryâ€} = “Category1†{MERGEFIELD “Item Descriptionâ€
\*CharFormat} {If{MERGEFIELD “Categoryâ€} = “Category2†{MERGEFIELD “Item
Description†\*CharFormat} {MERGEFIELD “Item Description†\*CharFormat}}}

However my problem is that I have about 10 different colour options thus
requiring a number of if statement, however once I go past a certain number
of lines the font disappears of the edge of the label and I can't see what I
am typing. Are there any dialog boxes within word I am unaware of? Or do I
simply temporarily expand the label box to see all the text and then shrink
once I have finished typing the statement?

Thanks
 
P

Peter Jamieson

I would develop and test your fields in a seperate document attached to
the same data source but either desinged to be a letter merge or a label
merge but with only 1 or 2 labels per page.

When you've got the fields right and tested them, copy/paste them back
into the first label of the label mail merge document you really want to
use, then "propagate" the label layout and perform the merge in the
usual way.

Peter Jamieson

http://tips.pjmsn.me.uk
 
S

Steve

Thanks very much

Peter Jamieson said:
I would develop and test your fields in a seperate document attached to
the same data source but either desinged to be a letter merge or a label
merge but with only 1 or 2 labels per page.

When you've got the fields right and tested them, copy/paste them back
into the first label of the label mail merge document you really want to
use, then "propagate" the label layout and perform the merge in the
usual way.

Peter Jamieson

http://tips.pjmsn.me.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top