Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Built a macro in word it works fine. When I copied it to Excel it runs until
the point of merge then stops. If you click on merge it will continue. Would like to have it go thru the merge and stop when it hits printer. Others can input ok for printer. Following is code that stops when hitting merge. Any one with an idea I an frustrated. Thanks Selection.TypeParagraph Selection.TypeParagraph ActiveDocument.MailMerge.DataSource.QueryString = _ "SELECT * FROM C:\Parade\mailEcopy.xls WHERE ((Contact_Person IS NOT NULL ))" _ & "" With ActiveDocument.MailMerge ---------------------- .Destination = wdSendToPrinter .MailAsAttachment = False .MailAddressFieldName = "" .MailSubject = "" .SuppressBlankLines = False With .DataSource .FirstRecord = wdDefaultFirstRecord .LastRecord = wdDefaultLastRecord End With .Execute Pause:=True |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need Excel count of 1 word if found in multi-word cells of column | Excel Worksheet Functions | |||
Macro to find a word and copy all rows with this word to diff ws | Excel Programming | |||
Import cells from excel into word and create multiple word docs | Excel Programming | |||
search for a specific word and copy the word and the preceeding words until a comma | Excel Programming | |||
Network activities while runnung macros | Excel Programming |