Save Mail Merge as .pdf

[Robo]

In Word 2000 I have the attached macro to send a merged document to printer.
How can I send it directly to PrimoPDF without opening the print dialog box?

With ActiveDocument.MailMerge
.Destination = wdSendToPrinter
.SuppressBlankLines = True
With .DataSource
.FirstRecord = wdDefaultFirstRecord
.LastRecord = wdDefaultLastRecord
End With

 

[Doug Robbins - Word MVP]

See the article "How to do a mail merge to the printer using VBA, without
displaying the Print dialog" at:

http://www.word.mvps.org/FAQs/MailMerge/MergeStraightToPrintrWVBA.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Robo]

Thanks Doug, That's a big help
--
Robo

See the article "How to do a mail merge to the printer using VBA, without
displaying the Print dialog" at:

http://www.word.mvps.org/FAQs/MailMerge/MergeStraightToPrintrWVBA.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Graham Mayor]

It is not going to overcome the fact that primoPDF appears to require a user
acknowledgement for each record, which can get very wearing with a large
merge

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Doug Robbins - Word MVP]

Hi Graham,

But if the merge is executed to a new document and then that new document is
printed (as the macro is doing), then there is only one print job that may
require user acknowledgement.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Graham Mayor]

True - but would the OP want all the merged records in one PDF? I would have
thought this more of a task for the add-in

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Doug Robbins - Word MVP]

True - except that he is using 2000. I guess you could use a catalog merge
to create a table with the required field names and then iterate through
that table to get the name to pass to PrimoPDF as your macro prints each
Section of the document created by executing the merge to a new document.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Graham Mayor]

I am not convinced PrimoPDF is that flexible. It doesn't appear designed to
be automated.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Doug Robbins - Word MVP]

Hi Graham,

You're right, that is the one where you have to pay to get the Developer
Extensions that would be necessary to allow you to do this. I remember it
now from when I was developing the add-in.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP