For help on Word mail merge using Excel as the data source have a look here

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

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...ateADataSource.

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"duxu" wrote in message
...
Hi,

I am using office 2000 and vba to write a function in excel to merge mail
of
word document.

My requirements are as following:

I have a doc document, I have made merge fields from excel already.
Now I am using one sheet in excel, I want to write a function in VBA to
abstract data in worksheet to merge into above doc documents. Anybody
knows
how to set up datasource in class mailmerge for my mailmerge processing.