Excel Mail Merge in VBA

[nir020]

Hi

I have drafted the below code in Excel 2003. My intent is that will open a word document with an existing mail merge, however when I run it I am presented with the error message, "Run Time Error '438: Object doesn't support this proporty or method"

Can anyone advise of the code I should use

Thanks

Nick

Sub automateword()


'Set wordapp = Documents.Add
Set appwd = CreateObject("Word.Application")
appwd.Visible = True
appwd.Documents.Open Filename:="G:\Corpdata\STRAT_Information\Open\2. Custody\Certification DB\Test_Letter.doc"


With appwd.MailMerge
.MainDocumentType = wdFormLetter
.OpenDataSource _
Name:="G:\Corpdata\STRAT_Information\Open\2. Custody\Certification DB\Input Sheet.xls", _
LinkToSource:=True, AddToRecentFiles:=False, _
Connection:="Details"
End With 

end sub

[StephenR]

Cross post http://www.ozgrid.com/forum/showthread.php?t=191248