VBA+Doing MailMerge with Excel (Off97)

joelx

New Member
Joined
Jan 15, 2004
Messages
9
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.
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Ken Puls

Active Member
Joined
Jun 9, 2003
Messages
482
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

New Member
Joined
Jan 15, 2004
Messages
9
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

Active Member
Joined
Jun 9, 2003
Messages
482
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,182
Messages
5,640,668
Members
417,160
Latest member
Timon82

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top