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?

Not without macros.
You could teach them to use the Find Recipient tool to search for that name.

Thanks for the info, I appreciate it.

I assume that you are not using Office 2016 on Widows XP.