View Single Post
 
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