Automating a msilmerge from Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JimPNicholls - 05 Dec 2003 15:16 GMT

Hi

I'm trying to automate a Word (97) Mailmerge from Excel. My data source is within Excel (97) and the letter is in Word. Can anyone help me with the code for this? (i.e. Click on a button in excel, then excel launches word and the data source merges with the letter)

**I've tried asking the excel newsgroup but they've pointed me in this direction**

Reply to this Message

Cindy M -WordMVP- - 06 Dec 2003 11:47 GMT

Hi =?Utf-8?B?SmltUE5pY2hvbGxz?=,

> I'm trying to automate a Word (97) Mailmerge from Excel. My data source is within Excel (97) and the letter is in Word. Can anyone help me with the

code for this? (i.e. Click on a button in excel, then excel launches word
and the data source merges with the letter)

>
> **I've tried asking the excel newsgroup but they've pointed me in this direction**

Exactly what your code needs to do depends to a certain extent on how the
merge should work. You're a little vague on that point...

Start at mvps.org/word. You'll find information there on how to automate
Word, generally, from the Excel interface. You should find everything you
need up through and including how to open the letter / create a new letter
from an existing template.

For the mail merge part, start in Word by recording in a macro everything
you want Word to do AFTER the letter has been opened / created.

Feel free to come back for help if you need it on integrating the recorded
macro into the code you get from the website. Be sure to copy/paste
everything you have into your reply.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

Reply to this Message