Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
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
  #2  
Old 11-07-2016, 03:50 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 15,025
macropod is a name known to allmacropod is a name known to allmacropod is a name known to allmacropod is a name known to allmacropod is a name known to allmacropod is a name known to all
Default

Ordinarily, one would expect to have to put whatever spacing, line breaks, etc. one requires between the mergefields. That said, I'd have expected consecutively-inserted mergefields to look like:
«Name»«Address_1»«Address_2»«City»«State»«Post»
(note the '»«' pairs between the mergefields), not:
«NameAddress_1Address_2CityState»«Post»
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 11-07-2016, 04:03 AM
mendelsohnf mendelsohnf is offline Windows 10 Office 2016
Novice
 
Join Date: Nov 2016
Posts: 3
mendelsohnf is on a distinguished road
Default

Thanks, so how do I edit the spacing and line breaks between the mergefields?
Reply With Quote
  #4  
Old 11-07-2016, 04:43 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 15,025
macropod is a name known to allmacropod is a name known to allmacropod is a name known to allmacropod is a name known to allmacropod is a name known to allmacropod is a name known to all
Default

Ordinarily, one would do the formatting at the same time as inserting the mergefields, in an iterative process.

If you toggle Word's field code display 'on' (e.g. via Alt-F9), your mergefields should change appearance to something like:
{MERGEFIELD Name}{MERGEFIELD Address_1}{MERGEFIELD Address_2}{MERGEFIELD City}{MERGEFIELD State}{MERGEFIELD Post}
You can now add the required spacing, etc. between the }{ pairs. When you're done, toggle Word's field code display 'off' again (e.g. via Alt-F9).
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 11-07-2016, 05:08 AM
mendelsohnf mendelsohnf is offline Windows 10 Office 2016
Novice
 
Join Date: Nov 2016
Posts: 3
mendelsohnf is on a distinguished road
Default

Hi Paul,

Alt+F9 doesn't seem to do anything... any other way of toggling it on/off?
Reply With Quote
  #6  
Old 11-07-2016, 12:35 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 15,025
macropod is a name known to allmacropod is a name known to allmacropod is a name known to allmacropod is a name known to allmacropod is a name known to allmacropod is a name known to all
Default

That suggests a faulty Office installation. Try repairing (via Start > Windows Control Panel > Programs > Programs & Features > Microsoft Office (version) > Change > Repair).

As for an alternate means, go to File|Options|Advanced>Show document content and use the 'Show field codes instead of their values' option.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Tags
columns, merge fields
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 04:58 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft