AnsweredAssumed Answered

Combining Two Names from Different Fields on Address Labels

Question asked by MarcSherrell on Aug 11, 2015
Latest reply on Aug 11, 2015 by philmodjunk

Title

Combining Two Names from Different Fields on Address Labels

Post

Hello,

I'm trying to generate address labels from an Excel spreadsheet.  The labels are for parents of students.  In the original Excel database, each student has two rows (one per parent name).  In my labels, I'd like to have the label say "Jane & John Doe" or "Mary Smith and John Doe."  The students are identified by a unique ID number, so there is a  connection between the student and parent names.  Right now, each student has two records (one record per parent), and that results in two address labels per student.  Any help is appreciated.  I'm using FM 10 Advanced for Mac.

Thanks in advance

Outcomes