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 |
Request for Question Clarification by
rainbow-ga
on
22 Sep 2006 14:25 PDT
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
|
Clarification of Question by
googdan-ga
on
25 Sep 2006 13:29 PDT
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 <<Next Record>>. 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 <<Next record>> and I don't know what's going on.
I don't know why I'm getting stuck here, please help.
Thanks,
DJ
|
Request for Question Clarification by
rainbow-ga
on
25 Sep 2006 15:24 PDT
Do the instructions here help?
http://support.microsoft.com/kb/318117/en-us?spid=2530&sid=276
Rainbow~
|
Request for Question Clarification by
cynthia-ga
on
26 Sep 2006 02:57 PDT
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.
|
Request for Question Clarification by
cynthia-ga
on
26 Sep 2006 23:38 PDT
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:
<<Next Record>>
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 <<Address Block>> and not <<Next Record>>
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:
<<Next Record>><<Address Block>>
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
|
Request for Question Clarification by
cynthia-ga
on
27 Sep 2006 00:14 PDT
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..."
|
Clarification of Question by
googdan-ga
on
27 Sep 2006 16:27 PDT
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.
|
Request for Question Clarification by
cynthia-ga
on
27 Sep 2006 17:47 PDT
I use that procedure with a 700 line excel database for labels, you
just have to do it once, not for every page.
|
,
0 Comments
)