Code to print all word documents from a folder

Hi all,

I'm looking for a code which will print all word document from two folders.

Ex: I need all word documents being printed automatically from the below folders and if possible in the background (without it being open)

F:\New test\Test
F:\New test\Test1

Could someone help me pls.

Scal

This is an Excel forum, you have a Word question, and I'll give an MSDOS answer!
Do this with a command line: check out For with FOR /? in the command line (start | Run | cmd)

something like this will do it FOR %F in (F:\New Test\test1\*.doc) DO PRINT %F
if you want to do it often create a text file (notepad) with extension .BAT and put the ;line in it (double the %, ie. %%F etc)

It won't run enntirely in the background but it's relatively 'quiet'

Hi,

These documents are mail merged generated from excel and saved automatically in these folders.

I'm looking for a vba code which can be activated from an excel button which will print all documents (excel or word) in these folders.

Scal