I am currently doing a mailmerge to the Electoral Register and have set my
headers in Excel as Title, First Name, Last Name, Add 1, Add2, Add3, Postcode
etc. The problem is that the register contains different information in Add1,
Add2 and Add3 fields eg. Add1 may contain Flat 1, Add2, Street name and
Number, Add3 Town etc. My issue is, in Add1 on some fields it contains no
Flat number and shows information for Add2. I have tried putting the fields
on the same line but it does not look professional having London etc on the
same line as the address. Is there a code I can insert to insert a hard
return should the information differ. I did look at some of the codes
adajacent to the mergefields tab but could not see anything. Thank you, if
you can, of coure assist.