Auto Fill individual excel forms for each name on spread sheet

[cmholmes]

Hello,

I have a list of people that need to be sent letters. I have already created a form that will poplulate the letter based on the information input manually. I would like to take it to the next level but auto popluating the letter but pulling information from the data provided in a spread sheet and creating individual files for each Name.

Spread Sheet:

[TABLE="width: 800"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Address[/TD]
[TD]City[/TD]
[TD]State[/TD]
[TD]Zip Code[/TD]
[TD]Job Title[/TD]
[TD]Employer[/TD]
[TD]Hire Date[/TD]
[TD]Salary[/TD]
[/TR]
[TR]
[TD]Bond, Jacob[/TD]
[TD]1 Point Place[/TD]
[TD]Dallas[/TD]
[TD]TX[/TD]
[TD]11111[/TD]
[TD]Representative[/TD]
[TD]ABC[/TD]
[TD]1/15/2015[/TD]
[TD]30,000[/TD]
[/TR]
[TR]
[TD]Bean, Jane[/TD]
[TD]6 Crop Circle[/TD]
[TD]Fort Worth[/TD]
[TD]TX[/TD]
[TD]11112[/TD]
[TD]Supervisor[/TD]
[TD]TBS[/TD]
[TD]1/14/2014[/TD]
[TD]45,000[/TD]
[/TR]
</tbody>[/TABLE]


Form:

Name:
Address:
Employer:
Job Title:
Hire Date:
Salary:

So the result would be two forms completed from the information from the data source. Can this be done in Excel or is there a bettter program to use to do this?