MailMerge from Excel with Embedded MERGEFIELD
Trying to run a mail merge for a long document with multiple options. I can get the options selected OK its just that within this Excel Cell I am trying to Mail Merge to Word document a variable that is already called out in the body of the document. All of the main documents' mergefields are working; BUT...the text from the cell in Excel just comes in as <<Company>> and doesn't get updated/merged.
When I select my options in Excel and load the cell with text , I can't get the imported merged text in the main document to recognize the the <<Company>> imported/merged from Excel and Change it to "ABC Company"
I have tried wrapping some of the Excel text %<<Company>>% etc but nothing seems to be working. Please let me know if someone has a solution for this. Thank you from CT.
|