Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help required to debug mailmerge procedure
I am attempting to run a mailmerge from Excel (Office 97) using the
following procedu It doesn't work .... and I am tearing my hair out - please help before I am completely bald TIA .............. Sub PrintLabels() Dim WD As Object Set WD = CreateObject("Word.Application") WD.Application.DisplayAlerts = wdAlertsNone WD.Documents.Open (ThisWorkbook.Path & "\BDayList Labels.doc") WD.ActiveDocument.Mailmerge.Destination = wdSendToPrinter WD.ActiveDocument.Mailmerge.Execute WD.ActiveDocument.Close SaveChanges:=wdDoNotSaveChanges WD.Application.DisplayAlerts = wdAlertsAll WD.Quit SaveChanges:=wdDoNotSaveChanges Set WD = Nothing End Sub .............. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Easy entries short procedure required | Excel Worksheet Functions | |||
Calling a procedure in a procedure | Excel Programming | |||
Calling a procedure in a procedure | Excel Programming | |||
Calling a procedure in a procedure | Excel Programming |