Printing Question - changing formats - print like a database!

[osmosys]

Hello,

I have an excel file that has the following row:

Borrower's Name Marketing Rep Site Address Site City/State Mail Address etc etc

Below these are a bunch of rows with all the client information. So A1 is "Borrowers Name", and A2 is the name of the borrower, and A3 is the name of the next borrower.

It's just a really simple layout to keep track of client information.

I want to print this information but I need the formatting to be more flexible. I don't want it to look like an excel file with rows and colums. Instead I want it to group everything together and print it all record by record like a database.

Ideally it would take a clients record row by row and take all the information and re-arrange it into something that resembles a big business card.

This is hard to show but I'll give it a shot.

Name: John Doe Address: blah blah blah
Number: blah blah blah email: blah blah blah
Borrowers Name: Blah blah blah.

Here is a screenshot that kinda shows what I'm looking for:
http://www.primasoft.com/upgrades/im...tification.jpg

My big question is do you know of another program that can take an excel workbook and parse it, so you can print it out in the format I want. Can excel do this somehow with the print options?

Thanks!

[dsm]

omosys,
A few options.

1. Try a mail merge in MS Word using your Excel data as the source

2. Design a report using MS Access linking to your Excel data

3. Use the transpose function in Excel to layout a copy of your data differently
a. add a blank worksheet to your workbook
b. copy a block of data (all your columns and 3 or 4 rows - just to test)
c. go to a blank worksheet
d. edit, paste special, transpose

your data will now look something like
name / bob / bill / frank / ...
last / jones / smith / brown / ...
address / main st / cross rd / ...
...


hope this helps

dsm

[osmosys]

omosys,
A few options.

1. Try a mail merge in MS Word using your Excel data as the source

2. Design a report using MS Access linking to your Excel data

3. Use the transpose function in Excel to layout a copy of your data differently
a. add a blank worksheet to your workbook
b. copy a block of data (all your columns and 3 or 4 rows - just to test)
c. go to a blank worksheet
d. edit, paste special, transpose

your data will now look something like
name / bob / bill / frank / ...
last / jones / smith / brown / ...
address / main st / cross rd / ...
...


hope this helps

dsm

So far I tried the mail merge, but when I define the fields it keeps repeating them.

For example if I have ((Address)) it will only take the adress from the first row in the excel file.

I don't know how to get it to batch process the entire worksheet.

Thanks

[osmosys]

Ok I figured it out... I have a ton of records now. Each one is now unique.

The only problem is they are being listed one per page. I need four per page.

Will a page break fix this?

I just want all the white space between the records to go away without copying and pasting 150 records.

Thanks!

[osmosys]

Ok I figured it out!

Gotta use the NEXT RECORD tag, and then you gotta paste in everything again.

heh I wish the wizard mentioned that function...

would have made my life a lot easier


lol

Thanks