[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

--
Robo

[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/MailMe...PrintrWVBA.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" wrote in message
...
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

--
Robo

[Robo]

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


"Doug Robbins - Word MVP" wrote:

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/MailMe...PrintrWVBA.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" wrote in message
...
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

--
Robo

[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

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


Robo wrote:
Thanks Doug, That's a big help

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/MailMe...PrintrWVBA.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" wrote in message
...
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

--
Robo

[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" wrote in message
...
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

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


Robo wrote:
Thanks Doug, That's a big help

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/MailMe...PrintrWVBA.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" wrote in message
...
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

--
Robo

[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

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


Doug Robbins - Word MVP wrote:
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.


"Graham Mayor" wrote in message
...
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

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


Robo wrote:
Thanks Doug, That's a big help

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/MailMe...PrintrWVBA.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" wrote in message
...
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

--
Robo

[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" wrote in message
...
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

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


Doug Robbins - Word MVP wrote:
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.


"Graham Mayor" wrote in message
...
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

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


Robo wrote:
Thanks Doug, That's a big help

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/MailMe...PrintrWVBA.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" wrote in message
...
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

--
Robo

[Graham Mayor]

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

--

Graham Mayor - Word MVP

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



Doug Robbins - Word MVP wrote:
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.

"Graham Mayor" wrote in message
...
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

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


Doug Robbins - Word MVP wrote:
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.


"Graham Mayor" wrote in message
...
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

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


Robo wrote:
Thanks Doug, That's a big help

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/MailMe...PrintrWVBA.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" wrote in message
...
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

--
Robo

[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

"Graham Mayor" wrote in message
...
I am not convinced PrimoPDF is that flexible. It doesn't appear designed to
be automated.

--

Graham Mayor - Word MVP

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



Doug Robbins - Word MVP wrote:
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.

"Graham Mayor" wrote in message
...
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

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


Doug Robbins - Word MVP wrote:
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.


"Graham Mayor" wrote in message
...
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

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


Robo wrote:
Thanks Doug, That's a big help

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/MailMe...PrintrWVBA.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" wrote in message
...
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

--
Robo