Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 02-10-2017, 08:37 PM
DazedandConfused DazedandConfused is offline Windows 7 64bit Office 2016
Novice
 
Join Date: Feb 2017
Posts: 2
DazedandConfused is on a distinguished road
Default Embed merge field into another

I have an excel data source see the crude example below:



Name | performance dropdown box | Date of appraisal
Joe | { MERGEFIELD "Name" } is a good employee |2017/02/10



What I am trying to do is merge data to a template appraisal form and I want to personalize the performance comments by embedding the first name into the list of value chosen. I can't concatenate since the name may be required in different positions in the text. Can this be done somehow?

Thanks
Reply With Quote
  #2  
Old 02-10-2017, 08:45 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,199
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

It's not clear what you want, but you can't add mergefields to dropdowns; you can insert them before the dropdown, however, provided the dropdown is a content control - dropdown formfields don't survive a mailmerge.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 02-10-2017, 09:04 PM
DazedandConfused DazedandConfused is offline Windows 7 64bit Office 2016
Novice
 
Join Date: Feb 2017
Posts: 2
DazedandConfused is on a distinguished road
Default

The dropdown is in excel the datasource! I figured that if I use the substitute function to add the name to the appraisal comment it will work in excel then I merge after to the word document. Thanks for looking at it!
Reply With Quote
  #4  
Old 02-10-2017, 09:07 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,199
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Well, if you've got:
Name | performance dropdown box | Date of appraisal
Joe | is a good employee | 2017/02/10
in Excel - since you can't possibly have a mergefield there, you should be able to merge the data to Word, where you can have { MERGEFIELD "Name" }, etc. scattered throughout the document as often as you need.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge how to link mail merge field value to a column heading dsummers Mail Merge 1 05-08-2014 02:59 PM
Date field inserting merge date in blank field Lesley Mail Merge 5 09-30-2013 01:49 AM
How to ignore a mail merge field if the field is blank redzan Mail Merge 1 05-16-2013 08:34 AM
Merge field source data field kckay Mail Merge 4 03-25-2013 11:06 AM
Can I embed a Ref field in an If field in Word 2003? skarden Word 2 01-05-2012 03:55 PM


All times are GMT -7. The time now is 07:44 PM.


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