Auto Fill individual excel forms for each name on spread sheet

cmholmes

New Member
Joined
May 13, 2013
Messages
30
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:

NameAddressCityStateZip CodeJob TitleEmployerHire DateSalary
Bond, Jacob1 Point PlaceDallasTX11111RepresentativeABC1/15/201530,000
Bean, Jane6 Crop CircleFort WorthTX11112SupervisorTBS1/14/201445,000

<tbody>
</tbody>


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?
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Watch MrExcel Video

Forum statistics

Threads
1,095,813
Messages
5,446,648
Members
405,413
Latest member
AlainCar

This Week's Hot Topics

Top