View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
James D Smooth James D Smooth is offline
external usenet poster
 
Posts: 2
Default VBA Pause to allow Print to start. sending fax via Outlook

I've written a program that will create an Excel Form, save it, and
then send it via email. By starting the To String with [FAX: "Fax
Number"] I have been able to send the documents when it is only
sending one. So that the VBA could cycle every 5 minutes and check for
new conditions I placed an Application.Wait, not it will not send the
faxes (it actually appears to print / render the doucment). Any ideas
on how I can force the render to take place, or allow Excel to
hibernate for a period of time so that the print can take place?