![]() |
|
#1
|
|||
|
|||
|
I am trying to do a basic mail merge of addresses from an excel file to word using Avery L7162 labels.
My excel sheet contains basic info which is grouped into these columns: Name, address1, address2, city, state, country. See attached image. Once I have started the mail merge and get to selecting INSERT MERGE FIELD the fields are not separated as per the columns, instead they are grouped together into one field which is: NameAddress_1Address_2CityStatePost -See the other attached image. My question is, how do I get Word to recognise that the excel columns should be separate Merge fields? Thank you. ![]()
|
| Tags |
| columns, merge fields |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge fields merge incorrectly and won't fix.
|
marym | Mail Merge | 3 | 04-09-2016 05:17 AM |
Displaying FORMTEXT fields when merge fields are empty or null
|
sfkHooper | Mail Merge | 6 | 01-19-2016 04:24 PM |
Bullet List Being Separated On Two Pages
|
spearo | Word | 1 | 09-01-2014 05:50 AM |
merge fields disappear in merge doc but prints
|
mdod | Word | 1 | 07-19-2013 06:33 PM |
Conditional merge fields in mail merge
|
Aude | Mail Merge | 1 | 01-06-2012 07:38 PM |