Office Developer : Outlook & VBA Programming # 1 – Le Café Central de DeVa
MS For general information on our other products and services please contact our Customer Care Department within the United States at , outside the United States at or fax All other trademarks are the property of their respective owners. Wiley Publishing, Inc. Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be avail- able in electronic books.
This book is dedicated, as always, to my beloved wife, Susie, for her patience in putting up with the long hours of writing and for just being there, and to my dog Casey for keeping me company while I was writing this book and for being my sales manager and the administrator of my Exchange server. He has been an Outlook MVP since He has coauthored Programming Microsoft Outlook , Professional Programming Outlook , Beginning Visual Basic 6 Application Development; contributed material to other Outlook books; and written numerous magazine articles about Outlook.
Maureen Spears has been a patient and painstaking development editor, guiding the book from beginning to end. Everyone else at Wrox has also been great to work with.
- VBA Script that gets list of Outlook Notes using the Property Accessor.
- Dead Girl Talking?
- Sex in China: Studies in Sexology in Chinese Culture.
There is no better group of MVPs and people, and I appreciate being included in their company. Ryan has always been completely helpful and responsive also, and has become a new friend. Introduction Welcome to Professional Programming Outlook This book covers Outlook programming, with the pri- mary emphasis on the many new Outlook programming features.
When I first was briefed on the programming features of Outlook early in , I felt like a kid at Christmas. Finally, the Outlook object model had almost all the features Outlook developers had been requesting for many years. Many properties that are important to Outlook developers were always unavailable in previous versions of the Outlook object model.
Some examples of properties that were unavailable are Internet headers in emails, the name of the last person to modify an item, the global object ID for calendar items that was introduced in Outlook SP2 and calendar labels. Now, with Outlook you rarely if ever have to leave the Outlook object model to do what you want with your code.
Who Is This Book For This book is for professional or advanced developers who want to take full advantage of the power of the unified Outlook object model in Outlook , and who want to learn the important new features in the unified object model. What Does This Book Cover? NET and C. The case study is presented using VB. Each chapter introduces important Outlook programming concepts, with plenty of sample code to help you make use of the new and old features of the Outlook object model.
Combine Outlook templates with macros to eliminate repetitive tasks
The chapter also covers new features that can dramatically improve the speed of Outlook code, the essentials of Outlook code security, Outlook syntax, and new features for Outlook forms. The VBA Project, macro security, class modules, UserForms, event handling, macro projects and macro distribution are among the topics covered here.
- Show the Developer tab!
- Why Greatness Cannot Be Planned: The Myth of the Objective.
- The Jains (2nd Edition) (The Library of Religious Beliefs and Practices).
- European Integration and Disintegration: East and West.
- Latin Verb Drills (Drills Series)!
- CodePlex Archive.
- Survey of Economic and Social Developments in the ESCWA Region 2005-2006.
The newly exposed form controls such as the calendar controls are discussed, as is prototyping Outlook forms code using VBA, Outlook form publishing and custom form distribution. Working with menus and toolbars as well as the new Office Ribbon interface are covered, as are custom views, custom task panes and form regions. Interfacing with Word, Excel, Access are all shown.
The rest of the material in the book gives you important learning and reference resources in the form of a chapter devoted to a COM addin case study as well as two appendixes. The study chapter shows how to use Outlook code in solving a real-world programming problem. Important new collections, events, methods, and properties are all covered, as are common property tags used with the new PropertyAccessor object.
It also shows you how to get help and support for Outlook development, cover- ing Microsoft and third-party Web sites, support newsgroups, and support mailing lists. The VB. The sample code and projects will run on any com- puter with those prerequisites. Boxes like this one hold important, not-to-be forgotten information that is directly relevant to the surrounding text.
Tips, hints, tricks, and asides to the current discussion are offset and placed in italics like this. Source Code As you work through the examples in this book, you may choose either to type in all the code manually or to use the source code files that accompany the book. All of the source code used in this book is avail- able for downloading at www. The code for the addin templates and the chapters is also available for downloading at www. Once you download the code, just decompress it with your favorite compression tool. Alternately, you can go to the main Wrox code download page at www.
You can copy the VBA examples in this book into a code module in the Outlook VBA project and run them to display the outputs for the email Internet message header and the Out of Office state. To enter and run the code in VBA by copying it from the book: 1. Select Insert, Module. Place your cursor in the Name property in the Properties Window, as shown in the following figure, and select the default name text, Module 1. Change the module name to Chapter 2, and press Enter to save the change.
Place your cursor in the new code module, and type the code into the project.
To run the code, place your cursor in one of the procedures, and use the keyboard shortcut F5 to start code execution. Errata We make every effort to ensure that there are no errors in the text or in the code. However, no one is per- fect, and mistakes do occur. If you find an error in one of our books, like a spelling mistake or faulty piece of code, we would be very grateful for your feedback.
By sending in errata you may save another reader hours of frustration, and at the same time you will be helping us provide even higher-quality information. Introduction To find the errata page for this book, go to www. Then, on the book details page, click the Book Errata link. On this page, you can view all errata that has been submitted for this book and posted by Wrox editors.
The forums are a Web-based system for you to post messages relating to Wrox books and related technologies and interact with other readers and technology users.
You can read messages in the forums without joining P2P, but in order to post your own messages, you must join. Once you join, you can post new messages and respond to messages other users post. You can read mes- sages at any time on the Web. If you would like to have new messages from a particular forum emailed to you, click the Subscribe to this Forum icon by the forum name in the forum listing. For more information about how to use the Wrox P2P, be sure to read the P2P FAQs for answers to ques- tions about how the forum software works as well as many common questions specific to P2P and Wrox books.
An Introduction to Outlook Programming Outlook stores items such as mail, appointment, task, and contact items in tables in a hierarchically structured database.
This article was published in:
This is unlike the underlying document object model that most other Office appli- cations use and requires a change of orientation for programmers experienced in programming applications, such as Word or Excel. In this chapter, you first open the Outlook VBA project and set it up for use in creating and running macros and prototype code. Using the Outlook VBA project is often the easiest way to quickly test and prototype your Outlook code.
Next, you discover the concept of a NameSpace and how to access Outlook data in folders and in individual Outlook items. This is the basis of all Outlook data access and is a building block for all Outlook programming.
- The Complete Guide to Investing in Property.
- Programming Outlook 2007: Two Good Books.
- Microsoft Outlook 2007 Programming;
You next see how Outlook stores its data and how to access that data. In Outlook , you can now access data either with the traditional Folders and Items collections or with the new Stores collection and Table object. The new members of the Outlook object model are explained in Chapter 2.