Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hyperlinking from an Excel cell to a bookmark in Word | Excel Discussion (Misc queries) | |||
linking to a bookmark in a Word doc | Excel Discussion (Misc queries) | |||
Microsoft Word bookmark content into an Excel cell using VBA | Excel Discussion (Misc queries) | |||
Copy/Paste Excel Cell Range to Word Bookmark | Excel Programming | |||
Place an X next to a cell that contains a word | Excel Discussion (Misc queries) |