Printing address cards from a spreadsheet

[Sharoncita]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I have an old Appleworks data base file which I use to print name and address cards for my business. Is there a way I can do this from Excel? I can SEE a data form by clicking "Form" on the "Data" menu, but I can't find a way to print it.

 

[CyberTaz]

I thought it was just me being dense, but I believe the overall lack of
response to your question is because nobody seems to understand what you
mean by "name and address cards". If you can provide a clearer description
of exactly what you want to print I'm sure there are suggestions to be
offered.

 

[Sharoncita]

Thanks for the reply. I thought no one was responding because there is no answer I have a Name and address list. I want to print old style Rolodex-style cards, a 3x5 card with name, phone number, email address to keep track of my students. In Excel I can bring up the spreadsheet and, as I said, if I click the "Data" Menu and then "Form" I can SEE each entry individually like this:
   NAME: Sally Jones
   HOME PHONE: 555-1234
   MOBILE PHONE: 123-4567
   EMAIL: (e-mail address removed)
but I can't seem to PRINT that view. Does that make it clearer?

 

[CyberTaz]

Indeed, that helps a great deal

The Data Form you're referring to is for entry & management of records in an
Excel worksheet. It isn't able to be printed or to be used for printing
records. In fact, what you want to do 'can' be done in Excel but it is more
complex & time-consuming than what the result is worth.

Assuming your Name & Address list is setup as an actual list [Captions/Field
Names in the first row, data records listed consecutively in the rows
immediately below] it would be far more practical to do a Merge using Word
as if you were merging to mailing labels. Word supplies you with rotary card
templates from both MACO/Wilson Jones, Avery & perhaps others. You can print
to the 'store-bought' sheets of cards or to plain paper.

One of the few topics Word 2008 Help covers well is merge. See the topics;

Create mailing labels by using mail merge

Create & print mailing labels - Step #1 (to confirm the setup of your list).

HTH |:>)
Bob Jones
[MVP] Office:Mac