Excel columns in to address labels?

Hi, I need to make address labels out of an excel file which has some columns with the address info: i.e. ?Name?, ?Shipping 1?, etc. I think this should be pretty easy, but I can?t seem to do it easily. I have tried the word and excel help but their process didn?t seem to work out for me. I would be happy with a stable program to do this for me with just a few button clicks, or some other way which is more efficient than the current setup, which involves my having to copy/paste each line on to a word label template. Thanks, DJ

Hi DJ, Take a look at the explanation here and let me know if this fits your needs: http://pcdon.com/page25.html (Scroll down to Doing Envelopes & Labels with MSWord: Using Excel & MSWord) Best regards, Rainbow

Hi Rainbow, thanks for the response. I think you've helped me with questions in the past. That link doesn't really help. I have tried to go through the wizard myself in the past and the end result is after I choose the data source, and it looks like it is going to work out (step 3 in the word wizard), I just get a bunch of boxes saying <>. I don't see any progress from here. Here is the exact steps I take: Word 2003 Open new document Tools >> Letters and Mailing >> Mail Merge Labels Label Options >> 8460 Select Recipients >> Browse >> I select the properly formated list and it shows up nicely on the screen that comes up >> I say OK Now it just shows <> and I don't know what's going on. I don't know why I'm getting stuck here, please help. Thanks, DJ

Do the instructions here help? http://support.microsoft.com/kb/318117/en-us?spid=2530&sid=276 Rainbow~

I do this exact procedure at work several times a month. As soon as I get to work I'll get to the "next record" stage, and take note of exactly how I get by that. I know exactly what you are describing, but *this* computer has the wizard I don't like (Word 2000) so I have to use the same version you're using which is at work.. I'll report back tomorrow.

Hi googdan, I've did it for you. It's simple, you can do it right now. It's on page "Step 2 of 6" where the page shows all the labels: <> Go there now, we're going to do a walkthrough. There? At the bottom right you will see this: "Step 3 of 6" Next: Arrange your labels <-----CLICK Next, click "Address Block" on the right --and set up the layout on the label. It might take you a minute or two to get it right. Also, there's an important part here. When the window opens to arrange the label, you must also click to "MATCH FIELDS" --this means the TOP ROW across the spreadsheet, the top line in each column will match the what Word will select from Excel to complete the merge. You "match" the firlds. If you don't have a row for this at the top of your spreadsheet, you'll have to go to INSERT and ADD ROW and type in appropriate words. I use these that are matchable in the MATCH FIELDS option window. TOP ROW: NAME STREETADDR CITY STATE ZIP If you have to you can do it this way too: FIRSTNAME LASTNAME STREETADDR CITY STATE ZIP Note that as you arrange the label, you are formatting the top left label that says <> and not <> Do the same with "Greeting Line" - select a salutation. That's *probably* all your need in that list on the right. CLICK: Update all labels. Now, all the fields look like this: <><> Then, to see all the addresses: "Step 4 of 6" Next: Preview your labels <-----CLICK Voila! Let me know when you do this successfully and I will post in the answer box and collect the fee. Thanks, ~~Cynthia

Gawd that was a horrid sentence. Let me correct it: ..."I've done it for you. It's simple, you can do it right now..."

I appreciate all the wonderful help from everybody! I've got it down ok from the second link rainbow provided. I will close this question and give credit soon. The only thing I'm doing now is trying to figure out how I can make the procedure more efficient, and how to make it work so that if there are more than 1 page worth of labels, I don't have to do the procedure twice. And maybe I'll see about how I can make this just a couple-click operation since I have to do it multiple times a day. So I might have a couple bonus questions for a tip. But otherwise this is a satisfactory answer for a $7 question.

I use that procedure with a 700 line excel database for labels, you just have to do it once, not for every page.

Hi DJ, I'm glad the link I provided helped. Best regards, Rainbow

#If you have any other info about this subject , Please add it free.#

8 January 2009 | cameltoepants.com | edit