I am attempting to link an Excel file to a Word letter document. The Excel file has much information, but I want to pull names and email addresses (dependent on the contents of a column) into the Word document at the bottom of a letter as 'ec's'. Mail Merge does not seem to work - it creates multiple Word sheets.
Solved by D. L. in 24 mins