Excel row invoices for multiple creditors into word template

(0) Share

Report

Posted on by JemmaKSS

Hi all

I am trying to build the following flow:

excel list with a multiple rows per creditor and sorted by creditor
build an array to get all of the rows for the creditor
merge these into a word template with a repeat function
convert the doc to pdf and email it

the bit that I am struggling with is how to get the apply to each for the list rows function to build the array and then merge the information into the word doc at each creditor change.

I have tried using variables to set and reset the creditor but i keep running into issues. I have followed the process outlined in How to: Populate a Word Template with repeating content control (bythedevs.com) but this doesnt appear to allow for the mulitple creditor situation.

help!

Screenshot 2022-02-21 141227.png Screenshot 2022-02-21 141215.png Screenshot 2022-02-21 141149.png

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

JemmaKSS 95 on at

Like (0)

Report

Re: Excel row invoices for multiple creditors into word template

Here is the solution I finally found for anyone else.

I initialised variables, set them on the first run and had the apply to each condition change when the creditor changed, this way it would apply the correct variables to the 'no' run, clear the array and then apply the new variables for the next batch.

Was this reply helpful? Yes No