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 th
activesheet it just stopped. sometimes it hung. tried to the same o
diff pc, same result.

I have about 1000 lines with about 14 fields/columns. Some fields wil
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

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/

OK... thanks for the info.

Let's change the way i'm going to do it.

How about... after my excel macro done its thing, it calls Word, not b
object though, and I will set it to call a saved word document togethe
with execution of Word.
This was I can make Word macro automatically run and find data on th
excel xls and do mail merge from there.

I tried to do this by using object but macro just doesn't run tha
way.

Perhaps there is a function to call external command that I don't kno
of...?

Again I appreciate any help.

Thanks

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