How can I merge address list from excel to a word premade format?

[Perez84]

List is like

First, Last Name
Adress
City St Zip
Phone Number

I know how to convert it to Cvs but I have a premade format in which these
lists need to go into the word document is there a way I can do this

It would save me a lot of time if someone could help.

the list from excel just has to go in to the word document in a specific
section is there any codes?

Anything would be appreciated.

Thank You

 

[JLatham]

To be used as data source (list) for a mail merge, your records need to be on
a row instead of in a column, so you'd need to arrange them like this

First Last Address City State Zip
Phone

assume 1 column for each field, and I'd break them out as separate first and
last names and different columns for city, state and zip. That will make
managing the list and putting together your mailings easier. Be sure your
first row in the Excel file has (simple) names for the information in the
column, something like I've shown above.

I don't know what you've got set up in Word right now for bringing in the
information, but if you simply save the file as a regular Excel file and work
through the Word mail merge process it will show you how to identify the
Excel file as your data source. Once you do that, the column names (as in
Row 1) will then appear as fields you can insert into your word document
where you want them.