ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA Pause to allow Print to start. sending fax via Outlook (https://www.excelbanter.com/excel-programming/407815-vba-pause-allow-print-start-sending-fax-via-outlook.html)

James D Smooth

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?


All times are GMT +1. The time now is 08:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com