Posts by AndyB

    Re: Macro to open Word and Start Mail Merge


    One more point re. Ezra's suggestion, I think you could set the ".Destination = wdSendToPrinter" property on the MailMerge object and the ".Execute" it to send to the printer automatically, as in :

    Code
    appWd.MailMerge.Destination = wdSendToPrinter
    appWd.MailMerge.Execute


    I use code very similar to Ezra's suggestion and it works fine.


    Except (in my case) ...


    If the data source is the same excel workbook that runs the macro Word 2000 reports that it can't open the Datasource.


    In Excel/Word 2002 and Excel/Word 2003, this works fine. In Excel/Word 2000, Word reports that it cannot open the datasource. I am using ODBC to connect to the datasource, having tried DDE already without success in Excel 2000.


    Any suggestions gratefully received.


    Note: I have used 'Revert:=False', and the merge does work fine if the datasource is closed at the time of the mailmerge.