Elsevier S & T

Microsoft Outlook Programming: Jumpstart for Administrators, Developers, and Power Users

Mosher, Sue

In stock

No reviews

29.750 KD inc. VAT

License

perpetual

Table of contents

Cover
Copyright Pageiv
Contentsv
Forewordxi
Acknowledgmentsxv
Introductionxvii
Chapter 1. What You Can Do with Outlook1
1.1 Why program with Outlook?1
1.2 Outlook programming tools2
1.3 New programming features in Outlook 20028
1.4 How to start9
1.5 A word on Outlook versions and setup11
1.6 Summary12
Part I: Outlook VBA Design13
Chapter 2. The VBA Design Environment15
2.1 VBA security15
2.2 Starting VBA16
2.3 Saving your work and ending a VBA session17
2.4 VBA windows18
2.5 Working with VBA projects25
2.6 Getting help in VBA26
2.7 Summary28
Chapter 3. A VBA Birthday/Anniversary Reminder Form29
3.1 Understanding Outlook birthdays and anniversaries29
3.2 Step 1: What controls do you need?30
3.3 Step 2: Create the form31
3.4 Step 3: Add user input controls35
3.5 Step 4: Add command buttons37
3.6 Step 5: Plan the next development stage44
3.7 More on VBA form controls45
3.8 Summary55
Part II: Adding VBA Code57
Chapter 4. Code Basics59
4.1 Understanding when code runs59
4.2 Writing VBA code69
4.3 Summary75
Chapter 5. Code Grammar 10177
5.1 Option Explicit77
5.2 Declaring variables79
5.3 Understanding scope82
5.4 Declaring constants84
5.5 Coding style87
5.6 Summary92
Chapter 6. Working with Expressions and Functions93
6.1 Elements of an expression93
6.2 Using mathematical expressions95
6.3 Working with strings96
6.4 Working with dates100
6.5 Using user-created functions106
6.6 Using Split( ) and Join( ) functions, and arrays108
6.7 Summary111
Chapter 7. Controlling Program Flow113
7.1 if ... Then statements113
7.2 Select Case statements117
7.3 Do loops119
7.4 For ... Next loops121
7.5 GoTo statements125
7.6 Summary126
Chapter 8. Handling Errors and Debugging VBA Applications127
8.1 Understanding errors127
8.2 Debugging in VBA133
8.3 Creating clean applications138
8.4 Summary144
Chapter 9. Handling User Input and Feedback145
9.1 Getting user input145
9.2 Providing feedback156
9.3 Summary161
Part III: Special Outlook Techniques163
Chapter 10. Working with the Object Models165
10.1 Using the VBA Object Browser166
10.2 Object and collection code techniques171
10.3 Programming with Collaboration Data Objects177
10.4 Using the Scripting Runtime Library182
10.5 More useful object model techniques187
10.6 Summary190
Chapter 11. Responding to Outlook Events in VBA191
11.1 Application object events191
11.2 Writing handlers for other object events199
11.3 Explorer events200
11.4 Inspector events204
11.5 Folders and Items events206
11.6 Reminders events213
11.7 Other events216
11.8 Summary217
Chapter 12. Working with Stores and Folders219
12.1 Information store concepts219
12.2 Information store techniques220
12.3 Working with Explorers223
12.4 Accessing folders225
12.5 Folder techniques233
12.6 Summary239
Chapter 13. Understanding Outlook Security241
13.1 Attachment security242
13.2 Automation security243
13.3 Outlook form code security244
13.4 Customizing Outlook security244
13.5 Coping with the security features245
13.6 Using the Redemption Library248
13.7 Summary257
Chapter 14. Working with Items and Recipients259
14.1 Working with Inspectors259
14.2 Creating items261
14.3 Accessing items264
14.4 Using item methods280
14.5 Working with the item Body property283
14.6 Working with recipients286
14.7 Summary298
Part IV: Outlook Form Design301
Chapter 15. Outlook’s Six Basic Forms303
15.1 Starting the forms designer303
15.2 The basic Outlook forms304
15.3 When to use which form317
15.4 Working in the forms designer318
15.5 Getting help in Outlook forms design320
15.6 Saving forms and ending a design session321
15.7 Summary324
Chapter 16. Creating Your First Custom Contact Form325
16.1 The process in a nutshell325
16.2 Add and modify controls and pages326
16.3 Complete the form337
16.4 Summary341
Chapter 17. Extending Form Design with Fields and Controls343
17.1 Understanding fields versus controls343
17.2 Creating user-defined fields344
17.3 Adding fields to Outlook forms351
17.4 Laying out compose and read pages357
17.5 Summary359
Chapter 18. Writing Code to Respond to Outlook Form Events361
18.1 Outlook form code basics361
18.2 Converting VBA code to VBScript369
18.3 Understanding event order377
18.4 Reacting to control and property changes381
18.5 Debugging in VBScript388
18.6 Summary392
Chapter 19. More Controls for Outlook Forms393
19.1 Using the basic controls393
19.2 Using more controls from the Toolbox400
19.3 Adding more ActiveX controls404
19.4 Summary411
Chapter 20. Common Outlook Form and Item Techniques413
20.1 Working with form layouts413
20.2 Understanding Outlook forms architecture417
20.3 Linking Outlook items421
20.4 Working with custom actions432
20.5 Using forms over the Internet443
20.6 Summary450
Part V: Finishing Touches451
Chapter 21. Menus, Toolbars, and the Outlook Bar453
21.1 Programming Outlook menus and toolbars453
21.2 Programming the Outlook Bar474
21.3 Summary478
Chapter 22. Designing Outlook Reports481
22.1 Built-in report techniques482
22.2 Sending output to Microsoft Excel488
22.3 Sending output to Microsoft Word495
22.4 Summary515
Chapter 23. Exchange Server, Databases, and XML Web Services517
23.1 Managing Exchange public folders517
23.2 Working with databases534
23.3 Using XML Web services (Outlook 2002)546
23.4 Summary556
Chapter 24. Deploying Forms and Applications557
24.1 Deploying forms557
24.2 Managing forms569
24.3 Distributing VBA applications572
24.4 Summary576
Appendix A: Resources for Outlook Programming577
Appendix B: Files Blocked by Outlook Security585
Appendix C: Key Procedures You Can Reuse589
Index593

Book details

Vendor Elsevier S & T
SKU 9781555582869
ISBN-13 9780080491875
Author Mosher, Sue
Category Computers
Subject Algorithms

Do you have questions about this book?

Ask an expert!

Microsoft Outlook Programming unleashes the power of Microsoft Outlook, allowing administrators and end users to customize Outlook in the same way that they've used macros and templates to customize other programs like Excel and Word. Experienced developers will find the quick-start information they need to begin integrating Outlook into their applications. Microsoft Exchange administrators will get help automating common tasks such as announcing public folders and importing data to custom forms.

Microsoft Outlook is the most widely used email program, and it offers the most programmability. This book introduces key concepts for programming both Outlook forms for storing and exchanging data and Visual Basic for Applications modules that add new features to Outlook. Central to this new edition, which covers both Outlook 2000 and Outlook 2002, is awareness of tighter security in Outlook. Designed to prevent transmission of computer viruses, the security restrictions can also get in the way of legitimate programs, but this book offers workarounds within the reach of novice programmers. It also covers many of the new features of Outlook 2002, such as the integrated Outlook View Control and searching across multiple folders using SQL syntax and the Search object.

· Building block procedures for the most common Outlook programming tasks
· Jargon-free language and practical examples to make the material more accessible to new Outlook programmers
· Coverage of Outlook Email Security Update
· Coverage of the Office XP Web Services Toolkit

Instant delivery by email
Your access email arrives within minutes of checkout, with a sign-in link for each book — no shipping, no waiting.

Read on any device
Books open in VitalSource Bookshelf on your phone, tablet, or computer, online or offline. Your library is always available at aafaq.vitalsource.com — just log in with the email you used at checkout.

Lost the email?
Resend it to yourself in seconds from My eBook orders, or email cs@aafaqeducation.com and we'll help.