CODEWITHSUNDEEP
excelms-wordword-fieldvba
user295099
user295099

Reputation:

Excel VBA - Send MailMerge to the Printer

I want to expand on the functionality related to this question. Is there anyway to set it up to send the MailMerge to the printer rather than create a new file?

Upvotes: 1

Views: 1405

Answers (1)

guitarthrower
guitarthrower

Reputation: 5834

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

Upvotes: 1

Related Questions