How to create a dynamic table in word using mail merge from excel sheet?

Copper Contributor

Hi,

so if the question is a bit confusing here is some info for my question

So I create purchase orders for work, and recently I have found out about using mail merge with Word. This way I just have to input the text into a spreadsheet and it will automatically insert the words into the document.

However I still have to create and recreate the table in the word document for each purchase.

 

*not sure why I cant add photos here* 

 

For example, lets say I have 1 Item in the order the table will be looking like this,

ITEM     Price 

Water    1.99 

 

However, this only works if I only have 2 rows in the existing word template and the text for 1 order in the excel list.

 

If for example i have 2 items in the order, I will have to go in and add another row and add in the merge fields.

So what I want to do is to be able to create custom tables from my excel spreadsheet that has the values so that I do not have to go into word and add rows or delete rows to fit.

 

I hope this makes sense, and if someone can also let me know how to add photos on this question page that would be amazing.

 

 

 

 
1 Reply