Direct merge a row in Excel worksheet to a Word template

[Longman]

I have created a worksheet containing a register of transactions, and I wish to be able to generate a receipt as the transactions are entered using a word template that will pick up the contents of data entered within the row in focus.

I hope to be able to use a quick method (ie macro) to have the spreadsheet take the data with in the row in focus and automatically populate the associated word template with the relevant data. I could then just print the receipt.

I am hoping not to have to close Excel and generate a list to select from within Word as it will always just be the current row that I want to print the receipt for.

Thanks for any ideas and assistance.

 

[tactps]

What you are asking is most likely do-able, but I often find that simple is better.

Can't you create the receipt in Excel on a separate sheet and print that?