Insert a cell into a defined place (or bookmark) in a word doc
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? |
Insert a cell into a defined place (or bookmark) in a word doc
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? |
All times are GMT +1. The time now is 09:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com