Microsoft Office Developement
Get flash to fully experience Pearltrees
You are too kind.
UtterAccess Wiki Featured Content, 2012-08-28 UtterAccess would like to present a new announcement series for UA Wiki content. Having watched the Wiki grow over a period of time, we will be periodically announcing some articles and code that we've found to be particularly insightful and helpful to our community.
In the blank code window on the right, type sub OpenExcel and press Enter.
ThE macro BELOW opens the correct email with a zipped attachment, copies the zipped file to a directory and runs the GREENSHT.BAT. It does what it is supposed to do but the strange (unknown) issue is when the BAT file is run using this macro it does not function correctly (winzip opens with a blank file named GREENSHT.ZIP). When I run the batch file (by double clicking it) it works perfectly:
Like most of the Office programs, Microsoft Outlook 2000 and later versions includes Visual Basic Applications, where you can write your own code to automate Outlook. And, like most of the Office programs, there is no macro recorder. Fortunately, there are plenty of VBA samples here and elsewhere.