Print all Documents in folder

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way that I can print all documents within a folder? I have a
folder of about 20 word documents, and I want to print them all. Can I do
this without opening each one?

Thanks,
 
hornless said:
Is there any way that I can print all documents within a folder? I
have a folder of about 20 word documents, and I want to print them
all. Can I do this without opening each one?

Thanks,

Use an adaptation of the macro in
http://www.word.mvps.org/FAQs/MacrosVBA/PrintAllDocsInFldr.htm:

Sub PrintAllDocsInFolder()
Dim MyPath As String, MyName As String

MyPath = "c:\my documents\"
MyName = Dir$(MyPath & "*.doc")

Application.PrintOut _
Background:=False, _
FileName:=MyPath & MyName

MyName = Dir
Do While MyName <> ""

Application.PrintOut _
Background:=False, _
FileName:=MyPath & MyName

MyName = Dir
Loop
End Sub

See http://www.gmayor.com/installing_macro.htm if you need instructions.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
Jay said:
Use an adaptation of the macro in
http://www.word.mvps.org/FAQs/MacrosVBA/PrintAllDocsInFldr.htm:

Sub PrintAllDocsInFolder()
Dim MyPath As String, MyName As String

MyPath = "c:\my documents\"
MyName = Dir$(MyPath & "*.doc")

Application.PrintOut _
Background:=False, _
FileName:=MyPath & MyName

MyName = Dir
Do While MyName <> ""

Application.PrintOut _
Background:=False, _
FileName:=MyPath & MyName

MyName = Dir
Loop
End Sub

See http://www.gmayor.com/installing_macro.htm if you need
instructions.

I should have mentioned that you need to edit the line

MyPath = "c:\my documents\"

to contain the path of the folder that contains the documents. There are
ways to get the macro to prompt you for a folder each time you run it, but
that's a later development.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
Another way: In Explorer, select all the docs you wnat to print, then from
File menu choose Print. Usually, each doc will flash open in Word, print,
and close.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top