runnung word

C

Curt

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Subject Line Email Merge 0
earlier thread posted 5
macro stops 0
Problems with VBA mailmerge 1
macro 2 issues 0
print cancel 1
Problem sending mail in office 2007 and windows7 0
double merge 2

Top