Convert Word labels to Excel spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know how to use the mail merge feature from Excel to Word, but how about
from existing labels in Word to a usable Excel spreadsheet. My approaches
have been to save word as .txt and then get external data in Excel. That
works great accept I need to be able to have different column fields like
Name, Address, City, State etc. What is the best way to go about doing this?
Any help?? Thank you in advance.
 
How about reformatting the Word document to put all of the information from
one label on a single line, separated by tabs. Then you could import that into
Excel.
 
Thank you for responding. I am not sure how to get them out of the
three column lable template into nice neat rows in word. I have
converted table to text and then they are inthe format of an address
label still. I need to get all the names and addresses into rows
somehow. Any ideas how to do that?
 
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

Convert Word Table to Excel Spreadsheet 1
Convert a Word address label file to an Excel spreadsheet 2
Eliminate blank fields in mail merge from Excel to Word 1
print address labels from existing excel spreadsheet 1
Mail Merge from Word 2
How do I print labels from an existing excel spreadsheet? 1
Importing List from Excel to Word printing labels spacing problems 1
Excel to Word 1

Back
Top