Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Mail Merge from Word
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mail Merge from Word
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 " wrote: 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 -- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mail Merge from Word
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 " wrote: 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 -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mail merge from XL to word | Excel Discussion (Misc queries) | |||
how to mail merge zero to word | Excel Discussion (Misc queries) | |||
how to mail merge zero to word | Excel Discussion (Misc queries) | |||
mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
Mail merge to word | Excel Discussion (Misc queries) |