Merging Excel & Word Documents (Office 2003 products)

[Grizz]

I would like to merge selected cell data from an Excel SS and place it in a
Word document/table (ie: Names, telephone #'s, email, etc). What is the
process that I need to follow. I'm very familiar with mailmerges, but not
with compiling all of the info from a SS into a single Word document.

 

[Suzanne S. Barnhill]

A mail merge from Excel is really no different from one using a data source
within Word. It helps if your columns are labeled. Just select the Excel
sheet as the data source, choose the fields you want to insert (in the
Insert Merge Field dialog), and go. From the sound of it, what you want is a
Directory-type merge.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

 

[Grizz]

Suzanne,

Thank you for your response!

It is my hope to compile a directory of all the records in the spreadsheet

 

[Suzanne S. Barnhill]

If you're wanting this in a table, you set up a table with enough columns to
accommodate the number of fields, then put one field in each column. If you
want a paragraph format, arrange the fields in a paragraph. You did say that
you were very familiar with mail merge?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org