Hi,
Traditionally we have had the print dialog box come up to allow the users to select the printer they wish to send the document to.
We are now producing PDF’s from vba and need to specify the PDF printer via vba as the one for the vba code for the word mail merge to use.
The vba code so far looks:
Set objWord = New Word.Application
‘Letter document would be open
Set objletter = objWord.Documents.Open(strletterpath & strworddoc)
objletter.MailMerge.OpenDataSource (strletterpath & strletterfile)
objletter.MailMerge.Destination = wdSendToNewDocument ‘normally print
objletter.MailMerge.Execute
‘not normally here
objWord.Visible = True
objWord.ActiveDocument.PrintOut
How do I get it to come out on a particulr printer (i.e the pdf printer that is not the default printer)
Any ideas?