View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Curt Curt is offline
external usenet poster
 
Posts: 469
Default useing a macro copied

Someone tried to respond to this link will not open. I tried google stumped
HELP
copy a macro over to run from vba in Excel works fine in word. When try from
excel will not go to printer
following is code this is only part. Have noticed that .destination all ways
goes to small not caps
Thanks to all

With ActiveDocument.MailMerge
'.Application = ActivePrinter
.destination = wdSendToPrinter error 5852 required object not
available
' Application = ActivePrinter
'ActiveSheet.PrintOut
.MailAsAttachment = False
.MailAddressFieldName = ""