How to convert rows of Excel addresses into a single column in Word?

[exceltm]

This is what I have in Excel, rows of addresses:

John Doe | 123 Anystreet | Anytown, NY 12345
Mary Doe | 123 Anystreet | Nowhere, NY 22333

This is how I want it to appear in Word, a single column of addresses:

John Doe
123 Anystreet
Anytown, NY 12345

Mary Doe
123 Anystreet
Nowhere, NY 22333

How do I convert them?

 

[Trevor G]

Use Mail Merge in Word to do this for you and just select the fields and place them as an address line.

 

[exceltm]

Use Mail Merge in Word to do this for you and just select the fields and place them as an address line.

I need more help or clarity, please

Yes, this works, but not how I want it to work. It puts 1 address on each page, and puts double-spaces between each line of the address.

I don't want this for letters with only 1 address per page. I want it for all the addresses in a single column.

 

[Trevor G]

You have to map the fields. Which version of MS Office are you using? Do you need all the addresses on a single page or single page per address?

 

[exceltm]

I wanted them to be in a single column, with a blank line in between each set. I figured it out. Simply use this "code" in MS Word Mail Merge, then copy it down the page, but with each new record beginning with the Next Record tag. Thanks for your advice.
«name»
«address»
«city» «state» «zip»
«phone»
«hours»
«Next Record»
«name»
«address»
«city» «state» «zip»
«phone»
«hours»
«Next Record»
«name»
«address»
«city» «state» «zip»
«phone»
«hours»