Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How can I merge address list from excel to a word premade format?

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,203
Default How can I merge address list from excel to a word premade format?

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.

"Perez84" wrote:

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert Word address list to Excel Mluera Excel Discussion (Misc queries) 2 November 2nd 08 11:08 PM
How do I merge address information in Excel into Word? Matt Excel Discussion (Misc queries) 1 August 30th 07 05:34 PM
How do I make an address label in excel, then merge it with Word. Marcdavid62 Excel Discussion (Misc queries) 7 November 23rd 06 12:33 PM
In XP how do I merge Word doc with Excel list and email? macinga New Users to Excel 1 January 12th 06 03:39 PM
Merge address in XL to Word letter template TheOne Excel Discussion (Misc queries) 1 December 7th 05 10:25 PM


All times are GMT +1. The time now is 03:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"