Is it possible to Create Word variables which link to Excel document?

Copper Contributor

In our company, we have an excel for each project, it looks something like this:



We also need to use this information in specific word documents like so for example:



Is there a way to create variables in Word, which link to specific cells in Excel? Preferably in a way where you can easily change the link to the Excel file, so you can quickly switch between projects.


2 Replies
best response confirmed by PieterL_S3A (Copper Contributor)

@PieterL_S3A The "poor man's" way of doing this would be to set up your data in the following format, 



and then use that workbook as the data source for Mail Merge.


Yess, thanks! I will have to make a file with all projects indeed.

For posterity: using 'more items' allows you to add a single variable quite simply (sorry that the image is in dutch)