Building a mailing list with a couple of tricks

[victor_the_magician]

Hi, everyone.

I hope someone can help me with this. I have a database (names, addresses, cities, etc). In some cases I have only one name (first & last), and sometimes two (first & last, first2 & last2). I am trying to see if I could write a script so that records with two names would be printed twice, first in format "last, first" Return "last2, first2" and then "last2, first2" Return "SEE last, first". I hope I'm making myself clear. I have no idea if this is possible, though. If anyone has a hint, I'll be very grateful.

Many thanks!

[Oldfogey]

What you are asking is quite simple BUT it looks odd to me so I wonder if you need to expand your requirements a bit?

You don't need a script. You just need a few calculation fields

Line1 = last & "," & first

Line2 = Case (isempty(Line3), "", Line3)

Line3 = Case (isempty(last2) and isempty(first2), "", last2 & "," & first2)

Line4 = Case (isempty(Line3), "", "SEE " & Line1)

Then a layout with -

Line1

Line2

Line3

Line4

all sliding up, will give you what you've described.

The logic in Line3 is up to you. Can you have a last2 without a first2 and so on?