How do i create a record form out of each rows?

[Zen1st]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi

I would like to transform rows into a record form.

Instead of info showing in rows

I want it to look like a description.

Example

Artist: Michael Jackson
Album: Thriller
Label: Epic
Code: EC-4782

Thanks

Dom

 

[Michel Bintener]

Hi Dom,

it largely depends on what you want to do with the form. I would
recommend using Word and its Mail Merge Manager to create labels or form
letters; that way, you can create a layout you really like and use your
spreadsheet as a source for the merge process.

If that sounds like an interesting option to you, and if you need help
with this, just post back, and you'll get more detailed instructions.

 

[Zen1st]

Hi

Yes that's exactly it.

I don't want a really fancy layout but mostly to know how to merge my excel info into the word layout.

Thanks a lot.

Dom

 

[Michel Bintener]

Hello again,

the first thing to verify is that your Excel document is formatted
appropriately. If you want to use the Mail Merge Manager in Word, make
sure that the data in your Excel spreadsheet is clearly structured, with
the first row being the header row, and every entry being placed
together, one right next to/below each other.

Once you've done that, open Word, then search for the following article
in Word's Help feature (Help>Word Help): "Create a form letter by using
the Mail Merge Manager". This will explain all the basics of mail
merging. If anything is unclear, just post back!