So I have a conundrum, and a lot of questions. I am trying to merge an excel sheet into mail merge. Simple, understand the process straight up, but for this task I need to get a lot of complicated. But first, this is the excel sheet I'm looking at is attached.



What I want to do is basically:
IF the street name column has a value use the new value. IF the street name value is blank THEN use the last value notated. Continue until a new value is seen, and repeat.


But every type of formula I've thought of and tried, it has not been successful. Can I create that formula, if so where do I start. OR do I have to be rudimentary and just fill in the blanks. It's totally okay if that's the answer and I'm just trying to be far more clever than possible.

Thank you!

Attached Images

excel example.PNG (12.2 KB, 9 views)

Have you tried this concept?

Where the street name appears, apply a specific style to it that doesn't appear anywhere else. Then, use a field with these components
If {mergefield} = Blank then {StyleRef stylename} else {mergefield}

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

I'll try it!! Thank you!

I haven't tried that in a mail merge, but I think I would modify the Excel sheet first to basically fill down the street name. Insert a helper column (new B), and tell it, basically, in cell B2:

=IF(A2="",B1,A2)

and copy that down.