Mail Merge from Word

[kathi]

I have a word doc that is address labels and what I need to do is make
this into an excel doc with company name, address, city, state and zip.
can anyone help me with how to do this? I have tried the mail merge
option in word but can't seem to make it work. I must be doing it
wrong. Any help would be great.

Kathi

 

[JCS]

Kathi,

If your data is in a table you should be able to copy and paste it into
excel. If you are using tabs you can copy and paste, however, depending on
how you have your tabs spaced, your data may or may not line up under your
fields. You don't explain how you have the fileds and data set up in your
Word doc. You may want to run this request through the Word discussion group.

John

 

[JCS]

Kathi,

As an adendum to my last reply, if you use tab stops to seperate fields
along with data, you can then copy and paste to and Excel worksheet and
everything will line up.

John