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: Name Address City State Zip Code Job Title Employer Hire Date Salary Bond, Jacob 1 Point Place Dallas TX 11111 Representative ABC 1/15/2015 30,000 Bean, Jane 6 Crop Circle Fort Worth TX 11112 Supervisor TBS 1/14/2014 45,000 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?

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Auto Fill individual excel forms for each name on spread sheet

Thread starter cmholmes
Start date Jul 15, 2015
Tags

auto fill data base spreadsheet

cmholmes

New Member

Jul 15, 2015

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:

Name	Address	City	State	Zip Code	Job Title	Employer	Hire Date	Salary
Bond, Jacob	1 Point Place	Dallas	TX	11111	Representative	ABC	1/15/2015	30,000
Bean, Jane	6 Crop Circle	Fort Worth	TX	11112	Supervisor	TBS	1/14/2014	45,000

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?