I don't know about using MailMerge from VBA, but
Mail Merge uses the first sheet in the Excel workbook,
not the activesheet, so you will certainly encounter
difficulty there.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"joelx " wrote in message ...
I need help or guide on how to make excel do mailmerging.
I read a book but nothing on that.
I tried to make Word to do mailmerge using data on excel. I called
Word (Object) via Excel but whenever Word tried to read data on the
activesheet it just stopped. sometimes it hung. tried to the same on
diff pc, same result.

I have about 1000 lines with about 14 fields/columns. Some fields will
be taken to mailmerge; meaning there'll be 1000 prints/report.

Really appreciate any help on this.

Hope the problem is clear enough.

Thanks for the help.


---
Message posted from http://www.ExcelForum.com/