Mail merge problems with Vista

[Mark H.E.]

Hi! Wonder if anyone can help:

I have just upgraded to Vista, from Windows 2000. Mail merges (a Word file drawing data from an Excel file) created in 2000 no longer work in Vista. The part of the code that is causing the problem is given below, it resides in the Word file. It is concerned with auto-opening the Word doc, activating the mail merge and sending the data to a new Word doc. It fails at the highlighted line.


Sub AutoOpen()

Const wdSendToNewDocument = 0

With ActiveDocument.MailMerge
.Destination = wdSendToNewDocument
.Execute
End With
End Sub


Any ideas?

Many thanks,

Mark.