![]() |
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