Mail Merge Help

[borris-bear]

Trying to merge so names and addresses from an excel file into a word letter.

The problem is that the address field in excel is just one column using alt>Enter to put the address on seperate lines.

When this is imported into word it puts the whole address on 1 line using little squares to separate the different lines of text that were in excel.

Is there a way of displaying the address correctly in the word document without having to create loads of new columns in the excel file and manually moving each line of the address into a new column and then doing the mail merge?

hope that made sense

[borris-bear]

Its ok i figured it out

thanks anyway