Microsoft Outlook Code?
Microsoft Outlook Code?
(OP)
I just learned it is possible to use VBA code in Outlook. Looking at it, I see how to insert a module, but I am not sure if that is how I would go about it or not. I suck with VBA and am not much better with Outlook.
Everyone uses Outlook at my work. Right now when we get an email, I get a small message box that pops up dont next to the clock. Unfortunately when I am focused on minute things on the screen, I will never see that pop-up way down int he corner and sometimes when I get an email asking me to come help someone, I wont see the email four a couple hours.
What I want to do....
1) Create code that will attach to my Outlook so that every day when I open outlook it will automatically open as well. In excel the modules we place code in seem to be attached to files and not excel itself. For outlook I want to make sure it opens with the program.
2) When I get new email, I want a message to pop up in the middle of my monitor telling me to check my mail and I want it to stay there until I click OK. That way if I am away from my computer it will still be there when I get back.
Is this possible with Outlook?
Everyone uses Outlook at my work. Right now when we get an email, I get a small message box that pops up dont next to the clock. Unfortunately when I am focused on minute things on the screen, I will never see that pop-up way down int he corner and sometimes when I get an email asking me to come help someone, I wont see the email four a couple hours.
What I want to do....
1) Create code that will attach to my Outlook so that every day when I open outlook it will automatically open as well. In excel the modules we place code in seem to be attached to files and not excel itself. For outlook I want to make sure it opens with the program.
2) When I get new email, I want a message to pop up in the middle of my monitor telling me to check my mail and I want it to stay there until I click OK. That way if I am away from my computer it will still be there when I get back.
Is this possible with Outlook?





RE: Microsoft Outlook Code?
Be careful what you wish for...
[edited for clarity]
RE: Microsoft Outlook Code?
I dont get a lot of emails at work. The ones I do get, 99% of them are from people I work with. Either Leaders sending me a job request or someone needing help on one program or another.
To be honest though, I am unsure how to email you. I see the button for Email Thread but not sure if that goes to you or what. I clicked on your name and I dont see anything there on how to email you. Sorry for my ignorance in this area.
RE: Microsoft Outlook Code?
Every Microsoft application has VBA capabilities “built in.” Excel, Word, Outlook, PowerPoint, Access all can be automated. BTW, in each application, including Excel, the code modules are saved WITH the Workbook, Document, Presentation.
Outlook is an outlier in many respects. I’d suggest posting your question in Tek-Tips VBA Visual Basic for Applications (Microsoft)
http://www.tek-tips.com/threadminder.cfm?pid=707
I am not conversant with the Outlook Object Model, although I’ve done some coding in Outlook VBA. There may be some here at Eng-Tips and there are a few at Tek-Tips.
Whatever you decide to do, you’ll need to do a lot of “heavy lifting” on your own. You’ll be building your VBA toolbox and “I just learned...” will become a more regular utterance.
Here’s a valuable tool that I use regularly...
How to use the Watch Window as a Power Programming Tool http://www.tek-tips.com/faqs.cfm?fid=4594
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: Microsoft Outlook Code?
RE: Microsoft Outlook Code?
I will probably do that. I just looked at the Powerful programming Tool you gave a link to. Kind of scary reading that post. Afraid it may be stepping into something way above my head. lol Though I seem to make it a habit of getting myself into these messes anyway, so I will be stepping in. lol
Im already saying "I just learned...” quite often when it comes to the basic stuff of VBA. lol
RE: Microsoft Outlook Code?
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: Microsoft Outlook Code?
RE: Microsoft Outlook Code?
Its likely possible to use VBA to generate a message window whenever a new email is received, but I'd agree wholeheartedly with cowski, it'll be so annoying and counterproductive that you'd turn it off again. You're better off changing your workflow or habits than attempt to get Outlook to alert you to new emails. There's probably a setting somewhere to make the new email notification persistent, which would remove all need for VBA.
There's plenty that VBA can do for you, I'd suggest that this case isn't one of them.
EDMS Australia
RE: Microsoft Outlook Code?
I have messed with the pop-up in the past. However I change it, it still stays a small mesage down in the corner that I dont see pop-up.
At this moment, I have three windows explorer folders, Outlook, the internet, two files of excel, WESS (GM Program), and NX open and spread out across two monitors. When I am at my desk, I am focusing on other areas of the monitor and dont see the pop-up. (My eyes getting worse and worse dont help) and I might be focusing on the job I am doing for hours at a time. I try to remember to check my email, but too often I am too focused on other things and it doesnt even come to mind.
Believe me, I have given it thought and I know this isnt something most people would want. Not everyones situation is like yours though. I would rather it force my attention to the fact I have an email once every couple hours, rather than leave a boss waiting for an hour and a half to get something done that should have taken me ten minutes.
RE: Microsoft Outlook Code?
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: Microsoft Outlook Code?
Version: 14.0.7116.5000 (32-bit)
RE: Microsoft Outlook Code?
RE: Microsoft Outlook Code?
RE: Microsoft Outlook Code?
https://superuser.com/questions/844739/how-to-auto...
Your shortcut will be something like:
"C:\Program Files\Microsoft Office\root\Office16\OUTLOOK.EXE" /autorun mainMailWatcher
Don't change the "mainMailWatcher" part.
Here's some info on how Outlook stores and saves code (basically it sucks):
http://www.outlookcode.com/article.aspx?id=28
Follow the instructions for importing.
You will have to enable macros for this to work. Your default macro security settings probably block all macros without even telling you. The macro will let you know if it starts with a message box that says "Watching for mail..."
Here are the code Module, Class Module, and UserForm you need to import. It doesn't lock up your whole PC until you dismiss the message, but it is big and stays on top.