VBA+Doing MailMerge with Excel (Off97)

J

joelx

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
 
D

David McRitchie

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.
 
J

joelx

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
 
Top