How to auto-generate receipt from list of names

Hi,

My wife handles the ordering of yearbooks for my daughter's school. In the past when an order for a year book is received she would add this to a list of "to be ordered" names. The problem is nothing ever went back to the parents indicating that they had placed an order for a year book so my wife wants to print out a receipt for each person that orders a year book.

She would like to do this in excel but she does not want to use a "macro".

Any thoughts on how to do this?

The inputs for this would be a text file of names.......names=people names who have ordered a year book.

Use Word and mail merge. This is what it is designed for.

i will look into that using word but she really prefers excel........is there a way to do this in excel?

Certainly with VBA, but...

It probably could be done with formulas - however, formulas are not my thing. Regardless if it can be done with formulas or not, it would be a lot simpler to use Word.

Re: How to auto-generate receipt from list of names
i will look into that using word but she really prefers excel........is there a way to do this in excel?

Do a search online using

excel sample invoice project

as the search term. Hundreds of websites.

welchs101

Are you good with setting up a mail merge in Word?

I have a small project you can probably use for the school books.

j.Green,

Can you share what project you mentioned? Is your proeject a mail merge? or something else?