Color fields on label.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robert Perkins - 21 Jul 2006 23:10 GMT

I am creating mailing labels in Word using Mail/Merge and using an Excel
worksheet as my data source. I would like the fields on the labels to reflect
the colors of the data in the cells of my source. [My labels have a field
showing my subscriber's expiration date. If the subscription has expired I
want to show the date in red.]

Reply to this Message

Doug Robbins - Word MVP - 22 Jul 2006 06:16 GMT

I think that you should be able to do this by the use of an
If...then...Else... field, but I would add a column to the spreadsheet that
contained a formula that returned either 1 or 0 if the date was expired or
not and then use the If...then....Else... field to check the entry in that
mergefield and use a \*charformat switch on the date merge fields in the
True and False results part of the If...then...Else... field construction
with the M of MERGEFIELD in each of those fields being formatted with either
Red or Black

{ IF { MERGEFIELD "DateFlag" } = 1 { MERGEFIELD "Date" \* charformat } {
MERGEFIELD "Date" \* charformat } }

The reason for setting up the DateFlag field in Excel is that it will be
much easier to do the comparison of the data in the Date field with the
current date in Excel than it will be in Word.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am creating mailing labels in Word using Mail/Merge and using an Excel
> worksheet as my data source. I would like the fields on the labels to
> reflect
> the colors of the data in the cells of my source. [My labels have a field
> showing my subscriber's expiration date. If the subscription has expired I
> want to show the date in red.]

Reply to this Message

Rate this thread: