Microsoft Outlook is the most widely used e-mail program and offers the most programmability. Sue Mosher introduces key concepts for programming Outlook using Visual Basic for Applications, custom Outlook forms, and external scripts, without the need for additional development tools.

For those who manage Outlook installations, it demonstrates how to use new features in the Outlook 2007 programming model such as building scripts that can create rules and views and manage categories. Power users will discover how to enhance Outlook with custom features, such as the ability to process incoming mail and extract key information. Aimed at the non-professional programmer, it also provides a quick guide to Outlook programming basics for pro developers who want to dive into Outlook integration.

Because the analysis of copious amounts of data and the preparation of custom reports often take away time from true research, the automation of these processes is paramount to ensure productivity. Exploring the core areas of automation, report generation, data acquisition, and data analysis, Automated Data Analysis Using Excel illustrates how to minimize user intervention, automate parameter setup, obtain consistency in both analysis and reporting, and save time through automation. Focusing on the built-in Visual Basic® for Applications (VBA) scripting language of Excel®, the book shows step-by-step how to construct useful automated data analysis applications for both industrial and academic settings. It begins by discussing fundamental elements, the methods for importing and accessing data, and the creation of reports. The author then describes how to use Excel to obtain data from non-native sources, such as databases and third-party calculation tools. After providing the means to access any required information, the book explains how to automate manipulations and calculations on the acquired data sources. Collecting all of the concepts previously discussed in the book, the final chapter demonstrates from beginning to end how to create a cohesive, robust application. With an understanding of this book, readers should be able to construct applications that can import data from a variety of sources, apply algorithms to data that has been imported, and create meaningful reports based on the results.

This book packs hundreds of time-saving solutions, troubleshooting tips, and workarounds for using Office Visio 2007. Whether you are upgrading from Office 97 or Office 2003, youll be able to dig in to the work-ready resources that help you take your Visio 2007 experience to the next level. This information-packed complete reference shows you how to get the most out of Visio 2007 and find out whats new. You will learn how to create diagrams and use them in other Office programs, how to create timelines and PERT charts to track projects and scheduling tasks, and how to use CAD drawings in Visio. You will explore how to use Visio to create technical diagrams for mechanical, electrical, and process engineering, and more. Plus, youll get an easy-to-use companion CD packed with custom resources and a fully searchable eBook.