Insert a cell into a defined place (or bookmark) in a word doc

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

writing excel data into word document 1
formattig word paragraphs from excel 5
Populate Bookmarkes in a Word Doc. with Excel 8
Create Word Docs From Excel Cell Data 4
Data from Excel to Word bookmarks 2
Saving a Word document as PDF from en Excel macro 2
Paste data to a Word bookmark 1
using excel vba ope a word doc and copy-paste into another word doc 0

Back
Top