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 |
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 |
All times are GMT +1. The time now is 02:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com