Conditional Mail Merge Help

S

Susan Ramlet

I'm trying to do a conditional mail merge into labels. Multiple people
belong to a single distribution list, and I want to show the name of the
distribution list (like an index) when the list changes. My data source is
Excel and is sorted by Distribution List.

The first label cell looks like this:

{IF {REF INDEX \* MERGEFORMAT } <> { MERGEFIELD DISTRIBUTIONLIST } "**{
MERGEFIELD DISTRIBUTIONLIST \* MERGEFORMAT }**" "{MERGEFIELD
"FIRST_NAME" }}{ SET INDEX { MERGEFIELD DISTRIBUTIONLIST }}

So, if the distribution list in a record is different from the previous one,
then print the name of the distribution list. Otherwise, print the name of
the person in the record.

The subsequent cells look the same with the addition of
{NEXT}

The problem is that the name of the first person in the distribution list is
never shown, because the merge goes to the next record after printing the
label for the distribution list for that particular record.

What am I missing? I've looked at Cindy Meister's conditional formatting
information--the one reference from the KB is the only one that appears to
apply to this situation, but I'm unable to make a connection from it back to
this scenario.

Any suggestions would be appreciated.
 

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