Link Excel to (Multiple) Word documents

[sleek12]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]PV no[/TD]
[TD]payee[/TD]
[TD]date[/TD]
[TD]amount[/TD]
[TD]method of payment[/TD]
[TD]cheque no.[/TD]
[TD]MPESA ref;[/TD]
[TD]cash[/TD]
[TD]Account[/TD]
[TD]No of installment[/TD]
[TD]Prepared by[/TD]
[TD]Approved by[/TD]
[/TR]
[TR]
[TD]45[/TD]
[TD]X ltd[/TD]
[TD]30/11/2017[/TD]
[TD]45000[/TD]
[TD]Cheque[/TD]
[TD]124[/TD]
[TD][/TD]
[TD][/TD]
[TD]General expenses[/TD]
[TD]4[/TD]
[TD]Me[/TD]
[TD]You[/TD]
[/TR]
[TR]
[TD]46[/TD]
[TD]XY Ltd[/TD]
[TD]30/11/2017[/TD]
[TD]55900[/TD]
[TD][/TD]
[TD][/TD]
[TD]LQWERTY1[/TD]
[TD][/TD]
[TD]printing/stationary[/TD]
[TD]1[/TD]
[TD]You[/TD]
[TD]Me[/TD]
[/TR]
[TR]
[TD]47[/TD]
[TD]XYZ ltd[/TD]
[TD]30/11/2017[/TD]
[TD]69000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]58720[/TD]
[TD]Consultancy[/TD]
[TD]0[/TD]
[TD]Her[/TD]
[TD]Boss[/TD]
[/TR]
</tbody>[/TABLE]
I want the above table to link to a payment voucher in word :-
I can link row 1(45) to one word document but what if if i wanted to process for the entire day, about 10 to 15 payment vouchers usually need to get prepared !!
see example of payment voucher(Word) to link to:-

 

[Macropod]

Perhaps you should consider setting up a mailmerge.

 

[sleek12]

Thanks for the tip, i watched a youtube video on it, & learnt about mailmerge, its a menu in word !!

 

[Macropod]

See: https://support.office.com/en-us/ar...nvelopes-f488ed5b-b849-4c11-9cff-932c49474705