VBA+Doing MailMerge with Excel (Off97)

  • Thread starter Thread starter joelx
  • Start date Start date
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
 
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.
 
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
 
Back
Top