View Single Post
  #4   Report Post  
Posted to microsoft.public.word.formatting.longdocs
Suzanne S. Barnhill
 
Posts: n/a
Default Converting Word to Excel

If you have Word 2002 or 2003, create the table as a separate document. Put
your field names in the top row and mark it as a heading row. Then select
this as your data source when you come to the appropriate point in the
Wizard, or, if you're using the "express" method (see
http://sbarnhill.mvps.org/WordFAQs/E...MailMerges.htm), when you click on
the Open Data Source button on the Mail Merge toolbar.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Dennis Hughes" wrote in message
...
I've never used a word table as a base for the directory.

Will try it. Thanks,

Dennis

"Suzanne S. Barnhill" wrote in message
...
Why do you need to get it into Excel? Use Table | Convert | Text to

Table
to
convert the tab-delimited text into a table. You can then copy/paste

into
Excel if you like, but you can equally well use the Word table as a mail
merge data source. For only 409 properties, I'd be tempted to leave it

in
Word.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the

newsgroup
so
all may benefit.

"Dennis Hughes" wrote in message
...
I have inherited a neighborhood roster of 409 properties in MS Word.

I need to get it into Excel to make a bookfold directory in word.

I have manually placed each property on its own line with tabs between
the
fields i.e. name, address, telephone, etc..

I'm using Office2003 and have tried many ways to import it into excel,
but
to no avail.

What would you suggest?

Thanks,

Dennis