printing a receipt for eack row

[Guest]

I have a list of students and their address with also what they want to buy,
like a shirt or a duffel bag, and the end of each row or student, how can i
make excel print a receipt or some type of acknowledgment of what they
bought. I was thinking that the recipt can have their name, address, and what
they bought, foe each student or row?

Help!

 

[Anne Troy]

If you only need to do it per row, you could easily do a mail merge.
http://www.officearticles.com/word/mail_merge_labels_in_microsoft_word.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Guest]

I will give it a try, but i would like to stay in excel if possible, the
receipt would need to look like:

student name
address
C,S,Z

Items bought:
Shirt: 1 XL
BookBag: 1

Paid: $0.00


I do appreciate the help, i will try your idea.

Daryl

 

[Tushar Mehta]

Going with Word and mail merge is a way to do what you want with the
minumum fuss -- and no programming. {grin}

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions