I want to be able to click a button in excel which uses the data and then
turns it into an order letter. Most of the text is standard in the word
document so I want to set up a template with defined sections (or bookmarks)
where the data will go. On clicking this button it will open the word
document and input the cells into the designated places.

Any ideas how to do that?

Raphiel,

What you're describing is called mail-merge, and is best done from Word. Look in Word's help for
assistance using mail merge.

HTH,
Bernie
MS Excel MVP


"raphiel2063" wrote in message
...
I want to be able to click a button in excel which uses the data and then
turns it into an order letter. Most of the text is standard in the word
document so I want to set up a template with defined sections (or bookmarks)
where the data will go. On clicking this button it will open the word
document and input the cells into the designated places.

Any ideas how to do that?