It's not apparent from your last post where the "property at which they might not live" comes from and how that relates to [POST NR]]&" "&[@POST NAME]. Perhaps you could attach a trimmed-down copy of your workbook with some representative data plus your mailmerge main document to a post (delete/obfuscate anything sensitive). That way I might be able to suggest a way to achieve the desired result via field coding in Word rather than via formulae in Excel.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|