I am working on a form letter that will be used to recruit members for an association my firm manages. I have some data in an Excel spreadsheet for each of those members including things like what their dues would be.



Is there a way using mail merge or some other tool to create the letter so that other users can pull it up, type in the name of the recruiting target they want, and have the rest of the data tied to that recruiting target populate in the relevant spots in the letter?