create a letter with the data fron work sheet

[hilary]

i have a data sheet for the order.like people order staff lik
tea,coffee...etc,i ve data including date,name,department,.....etc.
when i put the data i want a letter format which picks up the data fro
the sheet then i can send it to the person who made the order as
confirmatino letter.

like it the letter starts dear "......"(it could pick the name fro
c1)

also how can i create this letter? does it have to be in excel ??

help pleaseeeeeeeeeeeeeeeeeeee!!!!!!!!!! :

 

[Debra Dalgleish]

As answered in microsoft.public.excel and microsoft.public.excel.misc:

You can create the letter with a mail merge in Microsoft Word. David
McRitchie has instructions for mail merge on his web site:

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

Also, there's information on the Word MVP site:

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

 

[Don Guillett]

PLEASE do not multipost