I was pleased to see the solution to the above by Jane and added the desired code as per instructions. At first sight it looked as if all was well but I then noted that if the person selected is female the husband's name is correctly listed in the 'spouse' column but if the person selected is male then his own name appears. If he is unmarried then the 'spouse' entry is correctly blank. I suspect I have missed something rather obvious and will be grateful for any guidance on how to get back on track. Many thanks Andy
Andy said: <snippet> I was pleased to see the solution to the above by Jane and added the desired code as per instructions. At first sight it looked as if all was well but I then noted that if the person selected is female the husband's name is correctly listed in the 'spouse' column but if the person selected is male then his own name appears. If he is unmarried then the 'spouse' entry is correctly blank. I suspect I have missed something rather obvious and will be grateful for any guidance on how to get back on track. Many thanks <snippet> Yes - Unfortunately, Jane's first suggestion of INDI.FAMS[1]>~SPOU[1]> does exactly as you describe. It should have been INDI.~SPOU>NAME but as mentioned in subsequent replies this only copes with the 1st of multiple marriages/partnerships. Try the later suggestions that cope with up to 4 marriages/partnerships but remember that E-mails sometimes wrap long lines over several lines and all the Expression must be entered on just one line: =Text(%INDI.~SPOU>NAME%." ".%INDI.~SPOU[2]>NAME%." ".%INDI.~SPOU[3]>NAME%." ".%INDI.~SPOU[4]>NAME%) Or =CombineText(,%INDI.~SPOU>NAME%,CombineText(" , ",%INDI.~SPOU[2]>NAME%,CombineText(" , ",%INDI.~SPOU[3]>NAME%,CombineText(" , ",%INDI.~SPOU[4]>NAME%,,),),),) Happy New Year, Mike Tate