Share via

Auto Fill Multiple Documents

Anonymous
2016-01-14T16:53:27+00:00

Is there a way to create one word document which can auto fill information into multiple other word documents? For a business, I am trying to take one form and fill in information, such as clients name, number, etc., and have that information autofill into other word document templates which are specific for that case. Is this possible?

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Doug Robbins - MVP - Office Apps and Services 323.1K Reputation points MVP Volunteer Moderator
2016-01-15T02:31:58+00:00

As the saying goes, "There's more ways than one to skin a cat"

The low tech way would be to use mail merge for which you would create a Word Document with a table, or an Excel spread sheet in the first row of the table or spread sheet which you have a name for each piece of data (clients name, number, etc.) and you have the data in a subsequent row.  Then you use that Word document or workbook as the data source for each of the documents and you insert the relevant mergefields at the locations in the document where the data is required.

Then there are numerous other ways, which involve the use of Visual Basic for Applications.

Was this answer helpful?

3 people found this answer helpful.
0 comments No comments

0 additional answers

Sort by: Most helpful