Unusual Excel-to-Word merge. Is this possible?
May 6, 2014 7:05 AM Subscribe
Have Excel spreadsheet with a list of contacts with the name of the organization they belong to. Need a series of Word documents for each organization that includes the names and info of each contact. Read on for more detail.
posted by that's candlepin to Computers & Internet (4 answers total) 3 users marked this as a favorite
Asking for my lovely wife:
We have an Excel spreadsheet listing contacts for organizations. Each contact has a row in the spreadsheet, so there are multiple lines for each organization. We are trying to find a way to create a Word document for each organization that shows its basic demographic info once, and then lists all the contacts for that organization along with some of their basic info (their role, email, etc.).
So the final result would be a page with the organization name, address, etc. at the top, followed by a list of all contacts that belong to that organization. Is there a way to do this out of Excel? The ideal solution is one that can be largely automated so that the data in the sheet can be updated and the merge re-run every month with minimal intervention from a person.