View Single Post
 
Old 11-07-2016, 03:14 AM
mendelsohnf mendelsohnf is offline Windows 10 Office 2016
Novice
 
Join Date: Nov 2016
Posts: 3
mendelsohnf is on a distinguished road
Default Merge Fields are not separated

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.



Reply With Quote