If you've used data validation in Excel before, you probably selected the relevant cells, clicked "Data Validation" in the ...
You can do a mail merge in Microsoft Word and Excel to create personalized documents for many recipients at once.