>>>>>>Hi Tamar
>>>>>>
>>>>>>I would appreciate if you can help me with some sample code to try out.
>>>>>>
>>>>>>Thanks & Best Regards
>>>>>
>>>>>There's a section on mail merge in my paper on automating Word: http://www.tomorrowssolutionsllc.com/Materials/AutomatingWord.html
>>>>>
>>>>>Tamar
>>>>
>>>>
>>>>Tamar ,
>>>>
>>>>Hi,
>>>>
>>>>How to avoid the (excel2007) prompt about the first line with headerdescription when I apply the alt2domerge procedure?
>>>>
>>>
>>>Generally, the way to avoid prompts is to set .DisplayAlerts = .F. for the automation server. Not sure if this is applicable in this particular case.
>>>
>>>Tamar
>>
>>Hi,
>>
>>DisplayAlerts property not found in oDocument.Mailmerge.OpenDataSource - will look around for other solution.
>>
>
>DisplayAlerts is a Word-level property. Try oWord.DisplayAlerts=.F.
>
>Tamar

Hi,

no luck. Actualy I was expecting you would advise me something like oExcel.DisplayAlerts=.F. - since it is an Excel prompt h/e in this coding I have no Excel object. So maybe something different to

oDocument.MailMerge.OpenDataSource( cTempfile, 0, .F.,,.t.,,,,,,,"Entire Spreadsheet" )

into somethng like oDocument.MailMerge.OpenDataSource( cTempfile, 0, .F.,,.t.,,,,,,,Range(FirstColumn,2ndRow :LastColumn,LastRow) )

h/e beats me how to do this.

Regards,

Koen