http://stackoverflow.com/questions/1357121/executing-word-mail-merge-from-excel-macro
Is there anyway to set it up to send the mailmerge to the printer rather than create a new file?
http://stackoverflow.com/questions/1357121/executing-word-mail-merge-from-excel-macro
Is there anyway to set 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