Home Forums Discussions Problems trying to make labels-help!

OK-so I haven't toyed around with Excel since college. When the addresses are exported from AC-they are exported to EXCEL. How the heck do I make the labels? I need to send out my Xmas cards and would prefer not having staff handwrite the addresses. HELP!

sfernandez,

There are a couple of ways. If you have a DYMO label printer (i.e. you would need to purchase one: the Dymo 400), it is easy to print as many labels or as few labels as you wish by importing the data from Excel. I could also give you software to allow printing lab labels, etc. from the Dymo.

For what you are trying to do, I am sure it is easy enough by going to help and following those directions. It is easiest, though, to export the data to Access first and then print labels from there.

I have done this, but I use Office 2007, which makes it a snap. I don't think you need Excel 2007, but I am using both and Access 2007's wizards make it a breeze.

You export the home addresses to an Excel file on your desktop or wherever. You then open Access and click on External Data, then click on Excel. The wizard will walk you through importing the Excel addresses into Access.

You then, click on the Create tab on the ribbon and choose Labels, and the wizard walks you through everything and allows you to make labels in hundreds of formats and sizes. The wizards in 2007 are very nice.

You can download the entire Office 2007 Professional version for a two month trial at:

http://tinyurl.com/yt7ahg

Hope this helps.

Cheers

Thanks Bert! I was wondering the same thing.

You're welcome.