I want to do a mail merge.
For this, each line of the address is supposed to be on one line of Excel
(e.g address 1, address 2).
However, the entire address for each (person to be mailed) has been put in
one cell, on one row.
Is there a way to do a mailmerge or do I need to put each line of the
address into a different row? IF so, how can I do this without wading
through every single line?
Most of the addresses have commas between the line of address, eg Richard
Hart, 2 Letsby Avenue, .. if that helps.