How do I merge only sheet2 of an excel doc to a word document?

  • Thread starter Thread starter Guest
  • Start date Start date
Select the columns in sheet 2 and Insert-Name-Define and call it MyData.
Then, when merging from Word, choose MyData as the range.
**** Hope it helps! ****

~Dreamboat
Excel VBA Certification Coming Soon!
www.VBAExpress.com/training/
********************************
 
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

Merge data from an ascii file into a Word doc 1
Why does my excel to word mail merged doc not merge last entry? 3
Exporting information to a word doc 1
Excel Moving data to sheet2 from sheet1 0
Get selected word documents from user's choice and merge those documents as a single doc file 0
How to merge one document to another? 1
How to unlink TOC from a doc 0
Mail Merge Functionality 1

Back
Top