Oct 22 2022 03:44 PM
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.
Oct 23 2022 03:23 AM
Perhaps you can use Graham Mayor's add-in Mail Merge 'Many-to-One', 'One to One' (both including Merge to E-mail with Attachments).