Print Excel various cell values on a adhesive label sheet? (Name, Street, City, Postal Code)
Posted on 2010-09-04
Hello Excel Experts!
On my daytime job I work at a library where every now and then I have to send out some envelopes to a list of public and private libraries. The thing is I want to make things easier when it comes to printing out the adhesive address labels.
Currently I have a Word document configured to work with the sheets margins. (I do not mind using any other application to export the values from the excel sheet. I would love to have Excel managing this whole task).
I have an excel spreadsheet with all the values. For instance: Column A has all the recipients names, Column B has all the recipients Department, Column C contains the Address ..and so on... meaning it is 1 line and 8 columns per person (per label).
Now here comes the tricky part. How to I get this 8 cell values on one label / cell? Keep in mind that I have over 800 contacts, each of them should occupy only 1 label. Each label should contain the values of column A,B,C...etc..
Is there any way to "export" these values to another sheet so I can print out the recipients addresses?
It sounds easier than it actually is!
I currently have Office 2003 and 2010.