VBA+Doing MailMerge with Excel (Off97)
 

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

VBA+Doing MailMerge with Excel (Off97)
 

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/

VBA+Doing MailMerge with Excel (Off97)
 

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