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.

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.

-- 
Regards |:>)
Bob Jones
[MVP] Office:Mac

<Sharoncita@officeformac.com> wrote in message 
news:59bb73c6.-1@webcrossing.JaKIaxP2ac0...
> 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. 

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 &quot;Data&quot; Menu and then &quot;Form&quot; I can SEE each entry individually like this: <br>
&nbsp;&nbsp;&nbsp;NAME: Sally Jones <br>
&nbsp;&nbsp;&nbsp;HOME PHONE: 555-1234 <br>
&nbsp;&nbsp;&nbsp;MOBILE PHONE: 123-4567 <br>
&nbsp;&nbsp;&nbsp;EMAIL: sallyj@hotmail.com <br>
but I can't seem to PRINT that view.  Does that make it clearer?

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


On 4/22/10 1:26 PM, in article 59bb73c6.1@webcrossing.JaKIaxP2ac0,
"Sharoncita@officeformac.com" <Sharoncita@officeformac.com> wrote:

> 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: sallyj@hotmail.com
> but I can't seem to PRINT that view.  Does that make it clearer?