[aaron]

I have an interesting dilemma:

I work for a hospital and, as a courtsey, we provide "custom lab test
profiles" for the doctor's office in the area. Every year we have to send out
'authorization' forms that bascially say which tests are in the profile, what
the patient cost will be if they aren't covered by insurance, as well as a
few other things. Each test is assigned a number.

Here is what I want to do:

I want to create a mail merge document that contains each test number, as
well as the profile name, but I'm running into trouble. I was curious if
there is a way to make an if...then statement that will automatically fill in
information based on what test number is ordered.

Example:

Entering test number '1234' automatically places the text "Test Name",
"Cost", and "Billing Code" next to the test number (ideally in the table
cells on the same row, so everything lines up neatly).

Is this possible or is there another way for this to work? There are over 75
profiles, some of them have at least 8 tests and this would take a very long
time to crank out. It would be easier if I could just input which tests are
in which profiles and let the computer do the rest. I don't even mind
building the database (which would be quite a bit of typing), I just don't
want to have someone have to write ALL the letters once EVERY year.

If you need clarification, let me know.

-Aaron



Edit: Actually, is there a way to use a Microsoft Excel database and use the
input from the first column to force a print of the rest of the row?

I don't know if I'm making anysense, but thank you!