Email:      Pass:    Pass?


Advertisements


Free Excel Forum

Convert Word Labels To Excel Spreadsheet

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

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.



Similar Excel Video Tutorials

Helpful Excel Macros

Open Microsoft Word from Excel
- This free macro will open the Microsoft Word program on your computer. You do need to have this program first. This wi
Open a Word Document from Excel
- This Microsoft Excel macro will open a Microsoft Word document from excel. With this macro, you can open any word docume
Extract the First Word from a Cell in Excel - User Defined Delimiter Text Extraction - UDF
- This free Excel UDF (user defined function) returns the first word from a cell in Excel. This extracts the first word f
Extract a Word from a Sentence / Cell in Excel with this UDF - Allows for a User-Defined Delimiter
- Extract whole words from a cell or sentence in Excel with this UDF. This allows you to specify which word from a cell y
Capitalize the First Letter of Every Word in a Cell
- This macro will make the text of any selected cell in excel proper case. This means that the first letter of any word in

Similar Topics







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.




Hi -
I have a number of word documents that are labels, not originating from a data merge from excel, that I need to get into an excel document.

They are set up in tables in word for labels, but I need each label to be its' own row in Excel, and separate each field.

An example:

First Name Last Name
Company
Address
City St Zip

I need the excel document to be in rows, with each field it's own cell:
First Name | Last Name | Company| Address| City | St | Zip

Is there any way to get this word information into an excel spreadsheet without having to retype all of it?

Any help would be greatly appreciated!


I have a mailing list that I need to 'export' or 'copy' to either a Word Document (for mailing labels) or just dumped into a word document formated.

I no NOTHING beyond how to enter data into an excel document (and cut and paste obviously).

The excel spreadsheet is set up with each name, company name, address, city, state and zip in each column. This spans 500 names for 500 rows.

What's the easiest way to export the entire column so it displays so I can do labels...

Chris Powers


Hi, I wonder if anyone can help me? I need to copy some address (c.2000!) from a mail merge document (labels) in Word to Excel. I have converted the Word Doc to a Text (txt) document but when I paste this into Excel the address are not being separated by columns. For example, Mr Tickle, Tickle House, Tickle Street, Tickleshire, TI1 CKL is not copying into five different rows (A1, B1, C1, D1 and E1) it is only pasting the whole address into RowA1. I would be really grateful for a solution. Many thanks in advance. KTee


I'm using Windows 98 SE
MS Excel 2000
MS Word 2000

I'm trying to merge a sheet of mailing addresses from Excel to Word so as to print them.
All goes well until MS Word's wizard instructs me to "Insert Field".
I have a header row#1 on my Excel sheet and using columns A for Name,
Column B for street/po box, and Column C for City, State / Zip.

All I can get merged is:




It merges exactly as shown above. When I inserted the fields, I put a space between each item and hit enter so as to have the Name on top, street under the name, and city state zip under the Street.

I have the document set up for Avery 8160 labels and they all 30 come out exactly as shown above.

Can someone advise me of my error/errors?

Thank you for your help.


I'm not very familiar with this and wanted to make sure it will work before I start. Can I make a database in Excel 2000 and import it to MS Word 2000 to use as a mail merge? I want to use it to add a different company name, address, city, state, etc to a Word document, plus I want to make labels for mailing too. Thanks for all help.


Hello,

I have a Word document that is set up to mail merge with one of my Excel spreadsheets. All the fields look as they should. However, when I do the merge, some of the fields lose the formating they had in my Excel document. (i.e. the "Effective Date" field should read December 15, 2007 (it does in my spreadsheet) but, once I mail merge with Word, it reads 12/15/2007.)

This is also happening with a currency field that should not have any decimal places. The spreadsheet shows what I want, but when I mail merge to Word, it suddenly has the decimals added.

Has anyone run into this problem? Can you help? I just want my mail merge fields in Word to bring over EXACTLY what my Excel sheet shows.

Thanks in advance for any help offered.
Sandra


I'm looking for some suggestions and help on printing (barcode)labels from within Excel.
I have standard data like Referencenumber ,name , address , etc.. in some rows.
For this data i'd like to print labels (size to be determined).
I know about mail merge in Word , but how can i automate the use of a mailmerge from Excel.
The user will push a button on a userform in Excel to print the labels.

Does anyone have a suggestion or other possible options to use?


Using Windows XP-Pro and Office 2003

Is it possible to show/hide formatting marks in Excel? That option is
available in Word, but cannot seem to find it in Excel.

I have a client who has entered names and addresses in Excel to use as merge
data to labels via Word. She has entered the address information as two
lines in the same cell. Address is on first line, then she says she used
Alt+Enter to move to a second line for city, state, and zip information. (I
know!! I know!! I wish she had talked to me first, but the data base is
already created.)

I'd like to see the manual line break formatting so that I can try to make
this Excel data a little easier to merge onto labels via Word.





Using Windows XP-Pro and Office 2003

Is it possible to show/hide formatting marks in Excel? That option is
available in Word, but cannot seem to find it in Excel.

I have a client who has entered names and addresses in Excel to use as merge
data to labels via Word. She has entered the address information as two
lines in the same cell. Address is on first line, then she says she used
Alt+Enter to move to a second line for city, state, and zip information. (I
know!! I know!! I wish she had talked to me first, but the data base is
already created.)

I'd like to see the manual line break formatting so that I can try to make
this Excel data a little easier to merge onto labels via Word.





Here's the deal, we merge excel columns into address labels. Everything works great. Problem is when we have an address where there's no first or last name, just a company name. WE set up the labels like this:

<<First>> <<Last>>
<<Company>>
<<Address>> etc

When there's no first or last name, the space that we manually insert in word remains there, so that when the company name gets moved up to the top line it ends up looking like this:

Company X
123 Main Street
Anytown, CA

The company name is indented by that one space. Is there any way to get Word (or Excel) to ignore that space if there's no first name and last name?


I have a question I was hoping the guru's here could assist with. I have an excel .csv file with about 3000 entries of alumni address from our school database.

There are many columns with various info in the spreadsheet, but I need to grab the First name, Last name, Address, City, State, Zip code column info and put them into a Word label document. So I can have all the labels printed off in a day or two. There is no way I can do this in time by simply copy/pasteing.

Any shortcut options?

Help would be EXTREMELY appreciated!


Hi there. I am trying to setup my Excel 7 sheet to be merged into Word 7 to create mailing labels. I am confused as to how to do this.

I have three columns set up like this:
<<Name>> <<Address>> <<City>>

When I open up a Word document and go through the process of creating a mail merge to create labels, the information from the Excel sheet isnt showing up in the merge.

I am not sure if I made sense (my apologies if so).

I need to get this done in the next hour so I dont have time to go through past answers for this problem.

Your help is much appreciated!!!


I have a Word document where someone who didn't know the value of mail merge keyed in all 200 labels by hand. They each have 2 lines per label and 30 labels per page. I would like to "reverse merge" and import the data from these labesl into an excel spreadsheet. Haven't been successful without major cleanup. Any ideas?


I currently have an Excel spreadsheet with headings (name, title, address, city, state, zip). Is there a way to make mailing labels in Word from this spreadsheet? It would save me a lot of time instead of re-typing the information. Thanks.


I have a four column Excel spreadsheet which I have Mail Merged into Word to
create labels.
One of the columns in Excel contains a list of four digit numbers. Some of
those numbers begin with a zero.
When I have merged the data into Word labels, the four digit numbers
starting with a zero have the zero missing.
I have tried all sorts of number formats in Excel but can't get the zeros to
stay there when merged to Word.
Can anyone help???? I'm using Office 2003.



I would like to write a macro that exports a spreadsheet of Names and Addresses to Word and call a procedure that creates labels. I would like to be able to open the spreadsheet, enable macros and end up with printable labels. Does anyone know how to do this? I am versatile with VBA and Excel, but do not know where to begin when 'Word' comes into play. This is something that happens frequently and I am tired of doing the Word wizard. Any comments... suggestions?


I have 35 pages of labels in MS Word that I would like to export in to Excel. Is there a way to do this? I would like to be able to seperate the information (Name, Street Address, City, State, and Zip) if it is possible without having to retype everything that is there.


Even though formatted as zip codes, I cannot get the leading zero to show in
my zip codes when using Word mail merge to create address labels.

Example: 04103 shows up on the label as 4103



I have a six column spreadsheet (Last Name, First Name, Address, City, State, Zip Code).

When I merge with a Word doc for labels, everything is fine, except only the first page converts. I've tried to set print area. What am I doing wrong? Sandy


I can do a mail merge with Excel and Word, beyond just address labels. I am embarrassed to say even that took several months to learn how to do.

Now I would like to create an Excel 2007 dataset and send out personalized e-mails just like I can send out personalized Word letters.

What I was hoping to do was set up the body portion of any e-mail program with the general text along with the merge fields that would personalize the information. I wanted to also place the merge field for the address and a merge field for the subject.

I've search this site, finding a von-pookie topic back to 2002, where she was trying to get Excel to play nice with Lotus Notes. I did not see anything that would do what I am trying to accomplish.

I tried to do an e-mail merge with Word. I can set up their somewhat simplistic dataset for e-mail to do what I want. However the test did not work. i.e. I did not receive the test messages

So there are two question he
1-Can I use Excel to send personalize e-mails using, for example, Thunderbird?
2-Can I place Excel merge fields in the body of the composition window to allow personalization similar to personalization in Word documents??

As always you guidance and insight is greatly appreciated.

k


Can anyone help me? I use Excel 2007 and I would like to perform a mail merge. I know I can use Word, but both my form and data sheet are in excel formats. In other words, I have an Excel sheet which has Reps, names, address, city, state, zip, all in their own column. Then I have an excel form which has a spot where each of these information need to go. I need to create a 3rd document that would have a form for each name on the list with information. Can this be done? Her is an example.

Info Form:
A, B, C, D, E, F
1 Rep, name, address, city, state, zip
Ed, A-1 store, 5800....
--------------------------------------------------------------
Form:
A, B, C, .......
1 Rep: (here I want what I find in A1 above)
2 Name:
3 Address:


I recently got a new computer at work that includes Microsoft Excel 2003 and Microsoft Word 2003. I'm having formatting issues with a mail merge document that worked correctly on my older computer with the previous version of Word (2000 I believe). The data in the Excel spreadsheet that is the source for the mail merge includes several fields with percentages and decimals. These figures are not merging into Word in the correct format, and even with using the switches suggested in Word are not working. I know there should be a way to have the fields on the Word document format correctly so I don't have to go through the whole Excel spreadsheet and convert numbers to import properly. For example, one Excel column is a percentage, say 100%, and in the merged Word document it comes out as 1. I've tried the recommended switches \# #.##%, \# 0.00%, and even \# "#.##%" in the merge field, but the result keeps coming out as 1.00%. This is the case with any of the merge fields pulling a percentage in, the result in Word is coming out as the decimal version of the percentage (ie 15.76% in the Excel worksheet imports as .16%, 37.65% imports a .38%). If there is a way to do this without changing the values in the Excel spreadsheet I would love to know how to do it, as I'm concerned about data integrity issues if I have to go through and convert the numbers on the Excel sheet.


Mr. Excel Forum,

I have looked all over, and cannot find how to do this.

I have hundreds of stamp labels in a word document in this format:

Business name
Street Address
City, State, ZIP

However, I want to export these into an Excel document, except I want to sort it like this:

Column A: Column B: Column C:
Business St Address City, State ZIP

How would I go about doing this?

Thanks,
Jared


I have an excel spreadsheet #1 with 20+/- differnent columns, some columns have a vlookup to another spreadsheet that has names and address. I use this spreadsheet for the unique information that will be needed in my word mail merge. I also have another spreadsheet #2 that after printing my mail merge, I will cut copy and paste spreadsheet #1 to the record keeper spreadsheet #2. Is there a way I could put another column in my spreadsheet #1, that when entered a Y for printed it will automatically post over to spreadsheet #2? Also, I just want the value on spreadsheet #2 not any of the formulas.