Save Mail Merge as .pdf

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robo - 28 Mar 2007 01:56 GMT

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

Signature

Robo

Reply to this Message

Doug Robbins - Word MVP - 28 Mar 2007 04:44 GMT

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

Signature

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

> In Word 2000 I have the attached macro to send a merged document to
> printer.
[quoted text clipped - 8 lines]
> .LastRecord = wdDefaultLastRecord
> End With

Reply to this Message

Robo - 28 Mar 2007 07:20 GMT

Thanks Doug, That's a big help

Signature

Robo

> See the article "How to do a mail merge to the printer using VBA, without
> displaying the Print dialog" at:
[quoted text clipped - 13 lines]
> > .LastRecord = wdDefaultLastRecord
> > End With

Reply to this Message

Graham Mayor - 28 Mar 2007 07:54 GMT

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 :(

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Thanks Doug, That's a big help
>
[quoted text clipped - 26 lines]
>>> --
>>> Robo

Reply to this Message

Doug Robbins - Word MVP - 28 Mar 2007 10:57 GMT

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.

Signature

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

> 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
[quoted text clipped - 30 lines]
>>>> --
>>>> Robo

Reply to this Message

Graham Mayor - 28 Mar 2007 11:39 GMT

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 ;)

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hi Graham,
>
[quoted text clipped - 44 lines]
>>>>> --
>>>>> Robo

Reply to this Message

Doug Robbins - Word MVP - 28 Mar 2007 14:54 GMT

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.

Signature

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

> 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 ;)
[quoted text clipped - 47 lines]
>>>>>> --
>>>>>> Robo

Reply to this Message

Graham Mayor - 28 Mar 2007 15:51 GMT

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

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> 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
[quoted text clipped - 61 lines]
>>>>>>> --
>>>>>>> Robo

Reply to this Message

Doug Robbins - Word MVP - 28 Mar 2007 18:34 GMT

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.

Signature

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

>I am not convinced PrimoPDF is that flexible. It doesn't appear designed to
>be automated.
[quoted text clipped - 64 lines]
>>>>>>>> --
>>>>>>>> Robo

Reply to this Message