ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to make code waiting until Outlook finishes its job (https://www.excelbanter.com/excel-programming/395165-how-make-code-waiting-until-outlook-finishes-its-job.html)

clara

How to make code waiting until Outlook finishes its job
 
Hi all,

I activate Outlook in code and like to make the code wait until Outlook is
done.How can I do it?

Clara
--
thank you so much for your help

Jim Jackson

How to make code waiting until Outlook finishes its job
 
This causes a 10 second pause. You can set it for whatever amount of time
seems appropriate.

newHour = Hour(Now())
newMinute = Minute(Now())
newSecond = Second(Now()) + 10
waitTime = TimeSerial(newHour, newMinute, newSecond)
Application.Wait waitTime

--
Best wishes,

Jim


"clara" wrote:

Hi all,

I activate Outlook in code and like to make the code wait until Outlook is
done.How can I do it?

Clara
--
thank you so much for your help



All times are GMT +1. The time now is 11:38 PM.

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