VBA+Doing MailMerge with Excel (Off97)

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

 

[Ken Puls]

Hi Joel,

Welcome to the board!

I'm not sure I can help with your specific problem, but have you searched the board for similar issues? (I know I had some help on this subject recently -- but using office 2003.) There's quite a few topics that come back when you search for "mailmerge"

One of the matches that I returned was this one http://www.mrexcel.com/board2/viewtopic.php?t=39569&highlight=mailmerge. Iridium has a link to John Walkenbach's site there which may help...

HTH,

 

[joelx]

Thanks for the info Ken.

How about changing how I should do it.
Lets make excel macro call Word after it has finished running it functions.
I can make Word macro and make it start together when word load the saved documents.
I tried to use object but the word macro just don't run that way.
Maybe perhaps and external command in VBA that I don't know of.

Really appreciate your help.

Thanks.

 

[Ken Puls]

Hi Joel,

I'll try and help you, but I've tried this kind of thing a couple of times and only been successful once. It also took a bit of helps from NateO here as well.

The method that I used to do this was as follows:

1) I set up my Excel info the way I wanted, then saved the file.
2) I made a Word Document with all the merge fields set up
3) I made the macro to open the Word Document & Template, then ran the merge from Excel

The only thing that my code did to the data in Excel was filter it and copy it to a different sheet (so that the data could be merged from there). So basically the only thing that changed in my excel file was the names within the list. The headers always stayed the same, which was necessary to create the template.

If you are doing anything more to your info, I don't know how much I'll be able to help you, but again, I'll try....

Here's the link to the thread that Nate helped me with:
http://www.mrexcel.com/board2/viewtopic.php?t=70684&highlight=
My final version of the code is posted on the second page of the thread (again, remember that this code is all Office 2003, so may have some compatability issues with 97)

If you're still running into issues, post your code, and I'll take a look.