Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / November 2003

Tip: Looking for answers? Try searching our database.

Printing a Word Document Automatically

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steve - 20 Nov 2003 20:12 GMT
Good Afternoon,
    I have a Word document which uses a mail merge from a
query in Access. I am trying to schedule Word to print the
data automatically at some time overnight. Is there anyway
to do this? The file can be large at times and it takes
some time to print so I would rather be able to walk in to
all the printouts on my printer first thing in the morning.

Thanks,
Steve
Peter Jamieson - 25 Nov 2003 14:57 GMT
As long as you can safely leave your PC on with Word open, you could
a. open your Mail Merge Main document
b. use a very simple timer macro to wait until the time you want to print,
then execute the print, e.g. at its very simplest

Sub MergeLater()
' Let's start at 2 A.M.
Do While Left(TIME, 4) <> "2:00"
 DoEvents
Loop
Activedocument.Mailmerge.Execute
End Sub

However, older versions of Word will show the print dialog when you do that
so in that case you would need to mere to an output document, then print
that. And if merge to an output document does not cause the process to fail,
you could merge while you're in the office and simply print the result
overnight (using a similar technique if you want).

Alternatively, more recent versions of WIndows have a Task Scheduler that
you might be able to use to start Word at a certain time. I don't know much
about it (but e.g. in Windows 2000 look for Scheduled Tasks in Control
Panel, and notice that as far as I know you can specify a document as the
task. In that case Windows should run the associated application (Word) and
open the document. SO if you put a macro called AutoOpen in the document,
that macro should be run when the document is opened via the scheduler, and
can just do ActiveDocument.Execute. However, you would still need to
avoiding having dialogs popping up, and in this case you would have to avoid
anything popping up when Word opens or when the document opens.)

--
Peter Jamieson - Word MVP

> Good Afternoon,
>      I have a Word document which uses a mail merge from a
[quoted text clipped - 6 lines]
> Thanks,
> Steve
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.