Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   Monitor Macro Running (http://www.outlookbanter.com/outlook-vba/34056-monitor-macro-running.html)

Vadhimoo November 29th 06 03:35 AM

Monitor Macro Running
 
Hi ,

I am running the macro from Outlook and it extract the new mails details to
Excel.
I dont know when the macro complete the job. Is there any possible to
display a message like "Your Job Done" after completing the job.

Thanks in advance for your reply.

Vadhimoo November 29th 06 03:50 AM

Monitor Macro Running
 
When the macro running, In Outlook Application status bar shows like " Macro
Running"...
For Example In excel: Application.StatusBar = "Macro Running..."

"Vadhimoo" wrote:

Hi ,

I am running the macro from Outlook and it extract the new mails details to
Excel.
I dont know when the macro complete the job. Is there any possible to
display a message like "Your Job Done" after completing the job.

Thanks in advance for your reply.


Michael Bauer [MVP - Outlook] November 29th 06 07:13 AM

Monitor Macro Running
 


Simply add a MsgBox "Done" to the end.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.VBOffice.net --


Am Tue, 28 Nov 2006 18:35:00 -0800 schrieb Vadhimoo:

Hi ,

I am running the macro from Outlook and it extract the new mails details

to
Excel.
I dont know when the macro complete the job. Is there any possible to
display a message like "Your Job Done" after completing the job.

Thanks in advance for your reply.



All times are GMT +1. The time now is 10:17 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com