I've been googling for the last hour or so but don't seem to be find anything to help me. Basically I have some data in an Excel spreadsheet:
Column A: Ref Number
Column B: Address
Column C: Details
Column D: Status
Column E: Cost
Column F: Contact
There will be several rows of data. I want a user to be able to select a row by clicking any cell in that row, and then to click a button that will create a new Word document with the Excel data added into a template.
I can find guides on how to transfer complete sheets and do basic mail merges but I'm struggling to find info on how to do this.
Can anyone point me in the right direction on where I could find a decent tutorial for this?
Thanks
Column A: Ref Number
Column B: Address
Column C: Details
Column D: Status
Column E: Cost
Column F: Contact
There will be several rows of data. I want a user to be able to select a row by clicking any cell in that row, and then to click a button that will create a new Word document with the Excel data added into a template.
I can find guides on how to transfer complete sheets and do basic mail merges but I'm struggling to find info on how to do this.
Can anyone point me in the right direction on where I could find a decent tutorial for this?
Thanks