LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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 = ""

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Return while useing CONCATENATE Pierre Excel Discussion (Misc queries) 3 April 9th 09 03:59 PM
Copied formula produces unexpected copied results Robert New Users to Excel 1 December 5th 08 04:11 PM
Useing If to Delete a Range ytayta555 Excel Programming 10 March 5th 08 11:45 PM
Macro copied from ng returns a #VALUE! BEEJAY Excel Programming 5 November 1st 07 01:46 PM
useing arrows to move carman Excel Discussion (Misc queries) 1 December 20th 04 04:38 AM


All times are GMT +1. The time now is 09:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"