Excel VBA to create Word document

[reefoid]

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

 

[reefoid]

No worries, found a solution now. Typical, spend an hour searching, find nowt, post on here for help and then next search I do I find a solution.

 

[alfalavala]

Mind linking what you found?

 

[reefoid]

Can't find the site now, but it was basically this spreadsheet.

Take a look at the code behind the button, should be self-explanatory. I've just got to work out how to handle cells with carriage returns and I'll be done.

 

[A[L]C]

thats pretty neat