Excel & Word VBA Macro RRS feed

  • Question

  • I have several questions.

    1.  I have written a macro in Excel using VBA for the registration of seniors taking various workshops. I want to do a mail merge in Word that is started from Excel. Since the mailmerge macro will be in Word I will have to start a specific document. How do I do this?
    2.  I have written the mail merge macro using "record new macro". When I run the macro I get an error when it gets to "WordBasic.MailMergePropagateLabel" command. I looked in the help and there are conversion from WordBasic commands but not for this one.
    3. How can I pass a parm from the Excel Macro to the Word macro that is running the mail merge. This parm would tell the Word macro in which file to find the name and address information.

    Thank you in advance for your help

    Monday, May 26, 2008 6:01 PM


  • Quetion 1 has been answered via another query.


    Monday, May 26, 2008 8:02 PM

All replies