VBA Pause to allow Print to start. sending fax via Outlook

J

James D Smooth

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting Radio Buttons to work, that are inserted via AutoText 0
FAX with Excel VBA 2
macro that automatically sends a fax from excel 3
Blank Fax from Excel 1
Sending Fax Using Fax Numbers in Excel Spreadsheet 0
Send a Fax via VBA 0
Sending a mail via outlook excel 2003 0
Help with MS Fax 1

Top