开发者

Excel VBA - Send MailMerge to the Printer

开发者 https://www.devze.com 2022-12-22 22:48 出处:网络
I want to expand on the functionality related to this question. Is there anyway to se开发者_如何学Ct it up to send the MailMerge to the printer rather than create a new file?I suppose you could use th

I want to expand on the functionality related to this question. Is there anyway to se开发者_如何学Ct it up to send the MailMerge to the printer rather than create a new file?


I suppose you could use the same code as listed in your link, but then add a line to print the resulting word doc. I'm not familiar with the word syntax, but this should work (or at least get you started).

Replace:

wd.Visible = True
wdocSource.Close SaveChanges:=False

With:

wd.Visible = True
wdocSource.print
wdocSource.Close SaveChanges:=False
0

精彩评论

暂无评论...
验证码 换一张
取 消