Suggestions on taking Excel data into Word form

[mjhaston]

Here's what I'd like to do, I'm looking for suggestions on the best wa
to accomplish it.

I want to do online registrations for our football league next season.
I've created the online form which populates a MySQL data base. I ca
easily dump that down to Excel and from Excel to Access if that turn
out to be best. I'm fine with the database side of it.

What I need to do at some point is print out the forms for parents t
sign. I can create the Word or even Adobe for to print out and I gues
create fields to be populated. What is the best solution to print ou
individual rows of data into individual forms?

I was able to use the special paste function and get data from Excel t
Word quite easily, but I wasn't sure how to get it by row int
different forms. Hopefully I'm asking the question clearly!

I'd like to somehow highlight a row in Excel and get it out t
Word/Adobe for printing. Highlight the next row, print that form. O
something to that effect.

Thanks in advance

 

[Jay]

Here's what I'd like to do, I'm looking for suggestions on the best way
to accomplish it.

I want to do online registrations for our football league next season.
I've created the online form which populates a MySQL data base. I can
easily dump that down to Excel and from Excel to Access if that turns
out to be best. I'm fine with the database side of it.

What I need to do at some point is print out the forms for parents to
sign. I can create the Word or even Adobe for to print out and I guess
create fields to be populated. What is the best solution to print out
individual rows of data into individual forms? ...

Word's "Mail Merge" feature sounds like your best bet. You compose a form
in Word, and use a different file for the data fields that vary from
instance to instance. The different file can be an Excel worksheet or a
Word table.

To get started, use
Tools >> Mail merge

Word's "Help" describes how to use the feature.

 

[mjhaston]

Thanks Jay. I just came back to post that I had found a small tutoria
on Mail Merge. I just went through it and the Mail Merge Wizard i
plent for me. I appreciate the tip, I think it will work out great.

Goes to show how little I know about Word that I'd never used Mai
Merge. This will work out great