Preserved Topic: Can Excel print labels???

Calling all Excel experts . . . . . . Help please . . . . . . .

I am trying to set up a system at work to save some of the guys having to hand-write labels every day.
We have set up quite an involved Excel worksheet that gathers all sorts of information from various different worksheets and puts together a nice looking label.

What we can't figure out is, can you set up Excel to print out on labels (102mm x 49mm) so that is prints correctly on each label. I know you can do it in Word, but seem to be stuck with Excel.

Can anyone tell me how to do this or how to get around it????

I wondered about writing a macro to take the info from excel and temporarily put it into word and then print the labels from word, but don't know if you can write macros to work cross-applications?

Any help/advise would be appreciated

i'm not sure if works with excel, but Avery has a special MS Office software to print labels, maybe it works!!!


.-rotate script by Mr.Max

Aside from copy/paste I'm not sure. I know that you can insert an Excel spreadsheet into a Word document but I'm not sure how labels would print from an inserted spreadsheet.

I'll ask around here and see if anyone can come up with an answer.

How is the data formatted? Is each field (Name, Address, City, State, ZIP) in a different cell in the spreadsheet or is it all in one large cell?

Hey! we are fast!!

Do you have both Excel and Word? Do a mail merge.

--------------
cheers.jay

Yep, go into word and create a mail merge. Use your Excel document as the source document. As long as you've broken down your spreadsheet well you'll be able to use it as a nice source.

Make sure that your data is in columns with a label like "FirstName" at the top. That label will become your field that you'll enter into your mail merge.

I just tried that and it works beautifully.

In Word use your mail merge and choose to create labels.

Select your spreadsheet as the source document.

Then all you have to do is set up the main document with the fields pulled in from your spreadsheet.

Voila!

One last thing Trix..

You need to make sure that the data in your spreadsheet is columnar. When you create a mail merge its going to create the fields from the column heading and then each cell below it will be a seperate label.

We were talking about several ways to do it and this seems to be the easiest. You may have to manipulate your data to get it into the correct format but once you get that done you'll be good to go.

If you have Access, import your data from excel into Access then use Access' label wizard. Very easy.

mobrul

Whooaa! You guys are fast today. . . . Cheers Krets

I've left the office and am at home now, so didn't see your replies when I was still at work. I have no idea how to do a mail merge at the moment but I know about the general idea. Sounds like the way to go. I will have a play around with it later on then spend some time at work tomorrow seeing if I can get it to work. We have also got MS Access so I will look into that idea also.

Get back to you later

Nice one guys. All the advice worked. I managed to set up the mail merge and that works a treat. I am also creating a simpler version of this for someone else at work. Wakos, you e#were right, I downloaded some free software from Averys site that helped with the printing (from Word , not excel but still cool).

Once again thanks for all the help