Home > Articles

📄 Contents

  1. Office Reference Guide
  2. Table of Contents
  3. Surrealty: An Organic Case Study
  4. Working with Microsoft Word
  5. Branding Yourself with Microsoft Word
  6. Revising Your Document
  7. Saving and Using Document Templates
  8. Formatting with Styles
  9. Secrets of AutoText and AutoCorrect
  10. Trying To Remain Normal
  11. Customing Word with Macros, Menus, and Toolbars
  12. Document Management: Scanning into Word
  13. Using the Clip Organizer
  14. Backing Up Your Office System
  15. A Testimonial To Tables
  16. Navigating with Bookmarks
  17. Using a Document Map
  18. Creating a User Form
  19. Introduction to Word 2007
  20. Blogging with Word 2007
  21. Using Word 2007 Quick Parts and Building Blocks
  22. Mail Merge in Word 2007
  23. Word 2007: Open and Repair
  24. Styling: Using the New QuickStyles in Word 2007
  25. Compare and Combine Document Versions in Word 2007
  26. Accelerating Your Knowledge of Excel
  27. Getting Started with Excel Worksheets
  28. Creating and Autofitting Cell Content
  29. Populating the Worksheet with Data
  30. Using AutoSum To Create Automatic Calculations
  31. Using Formulas
  32. Making Your Worksheet Look Nicer
  33. Charting the Data
  34. Completing the Financial Picture
  35. Getting Fancy With Xcelsius
  36. Say It With Charts!
  37. The Effect of Text Entries and Blank Cells on Calculations
  38. Filtering Your Outlook Contacts
  39. New Charting and Productivity Tools
  40. Cataloging Your Backups in Excel
  41. Using Excel as a Simple Database
  42. Painless Pivot Tables
  43. Creating Interactive Spreadsheets Online
  44. Moving an Excel Macro
  45. Working with Scenarios and Goals
  46. Using Excel's Solver
  47. Emphasizing Sales Data in Excel
  48. XspandXL for Spreadsheet Analysis
  49. New Crystal Xcelsius Light (Free)
  50. Excel Business Analysis Books
  51. Excel 2007 Sorting, Filtering and Table Enhancements
  52. Creating an Entrepreneurial Marketing Plan in Excel 2007
  53. Named Ranges in Excel 2007
  54. Maintaining a Positive Outlook
  55. Using Word for Email
  56. Creating an Email Signature
  57. Handling Email Efficiently
  58. Creating an Anti-Spam Filter
  59. Working with Contacts
  60. Adding a Contact from Email
  61. Saving a Contact as a vCard
  62. Using the Calendar
  63. Appointments, Events, and Meetings
  64. Setting Tasks and Making Notes
  65. Protecting and Exporting Outlook Information
  66. Creating a Distribution List, and Other Outlook Tips
  67. Mail-Merge E-mail
  68. Creating an Outlook Form
  69. Completing the Outlook Form Solution
  70. Using Search Folders and Anti-Spam Tips
  71. Creating an E-Mail Template
  72. Using Outlook with a Cell Phone
  73. Stupid Outlook Tricks
  74. Using Multiple Outlook Calendars
  75. Using NewsGator for RSS in Outlook
  76. Review: <em>Conquer Email Overload with Better Habits, Etiquette, and Outlook 2003</em>
  77. Using Anagram's Artificial Intelligence
  78. MeetingSense for Enhanced Outlook Productivity
  79. Introduction to Outlook 2007 and Predictions
  80. Trying Business Contact Manager
  81. Outlook 2007 Organization Features
  82. Taking Your Outlook 2007 Calendar Online
  83. Going Mobile with My New SmartPhone
  84. Synching Outlook with Facebook
  85. Workaround: Create a Private Distribution List in Outlook
  86. Microsoft Office Outlook Connector
  87. "Where Are My Socks?" Accessing Your Important Information
  88. Exploring the Northwind Application
  89. Access Basics
  90. Creating Tables
  91. Using Forms for Data Entry
  92. Creating a Report
  93. Querying Your Database
  94. Creating Relationships
  95. Using Access for Business Documents
  96. Customizing an Access Template
  97. Using Macros and Switchboards in Access
  98. Creating an Online Data Access Page
  99. What's New in Access 2007
  100. Making Your Access 2007 Forms and Reports Look Professional
  101. Use the Access Label Wizard
  102. Presenting Professionally with PowerPoint
  103. Introduction to PowerPoint
  104. Creating Cool Diagrams
  105. Using the Diagram Object
  106. Beginning the Org Chart
  107. Using the Org Chart Toolbar
  108. Changing the Org Chart Layout
  109. Selecting Portions of the Org Chart
  110. Moving and Formatting the Selection
  111. Applying Styles to the Org Chart
  112. Using the Other Conceptual Diagrams
  113. Adding Our Concepts
  114. Moving Shapes with the Diagram Toolbar
  115. Moving or Resizing the Diagram
  116. Using the Diagram Styles
  117. Changing Your Concept Diagram
  118. Turning Off AutoFormat
  119. Adding a Caption or Title
  120. Summary
  121. Q&A
  122. Customizing Your Presentation
  123. The Concept of Customization
  124. Accessing the Master Views
  125. Understanding the Master Views
  126. The Power of the Master Views
  127. Adding Our Logo
  128. Changing Other Elements
  129. Slide Master Rules
  130. Using the Title Master
  131. Using the New Slide Master Template
  132. Adding Date and Time to a Footer
  133. Using Headers and Footers
  134. The Master View Toolbar
  135. Using the Handout Master
  136. Using the Notes Master
  137. Using Page Setup to Change the Presentation Type
  138. Summary
  139. Q&A
  140. Accessorizing for Presentations
  141. The Potential Of Photo Album
  142. Using Broadcast Quality Effects
  143. The Latest Presentation Gear
  144. Using PowerPoint, Video and DVD
  145. Microsoft Producer for PowerPoint
  146. Expanding PowerPoint with Plug-Ins
  147. Using Presenter View with a Projector
  148. Getting Into Your Presentation -- Literally
  149. The View from PowerPoint LIVE
  150. Making a PowerPoint Movie (not just for the Mac anymore)
  151. Making a Self-Running Animated Holiday Card
  152. Reporting on Databases in PowerPoint
  153. HD or Not HD, That Is The Question
  154. Taking On Tufte
  155. What the Heck Do I Say?
  156. Broadcasting PowerPoint Video with Serious Magic
  157. Video Blogging as a Presentation Value-Add
  158. This Just In: PowerPoint Secedes from MS Office!
  159. Two New PowerPoint Add-Ins
  160. Podcasting our PowerPoint
  161. What We Can Learn from InfoComm 2005
  162. Putting Yourself in the Show
  163. What You Can Learn from SIGGRAPH
  164. Using DVD Video in PowerPoint
  165. Animating Individual Chart Elements
  166. The Magic of PowerPoint LIVE 2005
  167. Making Sure Your Video Plays
  168. Creating a Timeline Template in PowerPoint
  169. Creating Transparent Animation and Backgrounds
  170. Using Advanced Animation Techniques
  171. Advanced Animation Part 2: Reusing Motion Paths
  172. Advanced Animation Part 3: Masked Backgrounds and Triggers
  173. Getting an Ovation with PowerPoint
  174. Video that Plays For Certain
  175. Using an Animated PowerPoint Chart on DVD
  176. Packaging Music Files with PowerPoint
  177. Say It With Presentations
  178. Keep Saying It With RSS
  179. PowerPoint LIVE 2006
  180. Total Solution: Using Propaganda for a PowerPoint Podcast for iTunes
  181. Wildform Wild Presenter for Interactive PowerPoint Online
  182. PowerFrameworks to Stimulate Your Creative PowerPoint Juices
  183. Distributing Video for iPods and Other Devices
  184. Converting Bullets to SmartArt Graphics in PowerPoint 2007
  185. Editing Video in PowerPoint (And a Lot More)
  186. Enhancing PowerPoint with Stock Photos
  187. Creating Sticky Documents and Presentations
  188. Review: Why Most PowerPoint Presentations Suck
  189. Using PowerPoint 2003 and 2007 Together: Preparing for InfoComm 2007
  190. Converting Flash to PowerPoint Video
  191. Animated Artwork for PowerPoint: PointClips and Vox Proxy
  192. Cutting Edge Graphics at SIGGRAPH 2007
  193. The Insert Object Animation Trick in PowerPoint
  194. Using YouTube Video in PowerPoint
  195. Using PowerPoint 2007 with Video Online
  196. PowerPoint LIVE 2007: Presentation Paradise in the Big Easy
  197. Camatasia 5.0: An Upgrade Worth the Effort
  198. Solving Video Playback in PowerPoint for Vista
  199. Review: Microsoft Office PowerPoint 2007 Complete Makeover Kit
  200. Graphic Novels in PowerPoint
  201. The Ultimate Presentation
  202. Opazity: PowerPoint for Lazy People
  203. Using SlideShare for Online PowerPoint with Narration
  204. Mastering Themes in Office 2007 (and Specifically PowerPoint 2007)
  205. VIDITalk's New Online Presenter Program
  206. Using and Converting YouTube Video for PowerPoint
  207. SlideRocket: Documents in the "Cloud"
  208. PFC Pro: Use YouTube Directly in PowerPoint and Maybe Get Your Web Cam into a Web Conference
  209. AuthorSTREAM: PowerPoint with Narration Made Easier Online
  210. Slide:ology: Nancy Duarte’s Design Secrets and Her New PowerPoint Book
  211. Mastering the New Slide Masters (and Layouts) in PowerPoint 2007
  212. Using PowerPoint 2007 to Create Slides That Don't Look Like PowerPoint (Video Update)
  213. A Treasure Trove of PowerPoint Templates
  214. Posting a Web Site with FrontPage
  215. Getting a Web Site
  216. Creating a FrontPage Web
  217. Where's My Web?
  218. Adding Navigation
  219. Applying a Theme
  220. Publishing Your Site
  221. The Old MHT Trick
  222. Taking Over A FrontPage Web
  223. Expression Studio 2.0: A Worthy Successor to FrontPage
  224. Publish or Perish
  225. Creating Publications for Print
  226. Publisher Web Sites
  227. Creating an E-Mail Newsletter
  228. E-mailing Holiday Cards
  229. Publisher 2007
  230. Get Visual with Visio
  231. Creating a Visio Flowchart
  232. Connecting Shapes
  233. Examining the Shapesheet
  234. Creating a Report
  235. Moving In With Visio
  236. Expanding Visio with Third-Party Stencils
  237. Playing Well with Others Using Visio
  238. Creating Interactive Diagrams with Visio's Layers
  239. Creating a "Virtual Database"
  240. Creating a Visio Dynamic Solution Template
  241. Visio 2007
  242. Visio 2007 Professional IT Toolbox
  243. Project Management with Visio 2007 Gantt and Pert Charts
  244. Review: Using Microsoft Office Visio 2007
  245. Tools That Integrate Your Office Applications
  246. Creating Video E-Mail with MovieMaker
  247. Managing Pictures with Microsoft Office Picture Manager
  248. New Year's Predictions: 2005
  249. Office Predictions for 2006
  250. Favorite Books List
  251. Using Excel as a Database Conversion Tool for Outlook
  252. Oh, Brother, I Love Labels (and other Office Tips)
  253. Planning for Disaster
  254. Using OneNote with Outlook
  255. Web Resources for Microsoft Office
  256. Simple 3D in Microsoft Office
  257. Creating Dynamic Database Links
  258. Using an Access Query for Mail Merge
  259. Displaying Database Links with Xcelsius Enterprise
  260. An Office 12 Sneak Preview from PDC
  261. My Big Fat Office Vacation
  262. What CES 2006 Means to Office Users
  263. Using &quot;Send To&quot; Between Office Applications: Word and
  264. Running (and Surviving) a Web-based Conference
  265. Running an Online Office with HyperOffice and Writely
  266. Preparing with Index Cards
  267. Creating Meeting Agendas
  268. Collecting Data with New Technologies: ARS, SMS and RFID
  269. Using Application Sharing in a Web Conference
  270. Running an Online Notes or Windows Media Session
  271. Trying Out Live Meeting
  272. Creating a SharePoint Team Website
  273. Using and Customizing a SharePoint Team Website
  274. Creating a Trip Planner in Excel and Outlook
  275. Crystal Graphics’ Excel and Solutions and Chart
  276. GoToMeeting Instant Webinar Tool
  277. Checking Out Office Live
  278. Using Quindi Meeting Capture
  279. Using Excel to Link to Other Databases
  280. Trying Out Mind Manager Pro to Brainstorm with Office Programs
  281. The 13th Thing I Hate About Office
  282. Introduction to Office 2007
  283. What's New in Excel and PowerPoint 2007
  284. Take a Look at InfoPath 2007
  285. Office's Groovy New Collaboration Program
  286. Using Office Accounting Express
  287. Printing to PDF or XPS in Office 2007
  288. Getting Adjusted to Office 2007 Changes
  289. Using SnagIt for IT Training
  290. Providing Help with Go To My PC
  291. Vista Meeting Space and People Near Me from Microsoft
  292. Trying Expression Web
  293. Migration Issues to Word and Outlook 2007
  294. Vista – Are You Kidding Me?
  295. Making Office 2007 (and Vista) Work Properly
  296. Office and the Enterprise
  297. Survey Says – Use Web Surveys with Excel and Access
  298. Uninstalling Office 2007 in Windows XP Pro
  299. Using Excel for Tables in Office 2007
  300. VIDITalk – Video in SharePoint and Beyond
  301. Career Advancement for Office Professionals
  302. Online Database that Rivals Access?
  303. Web 2.0 2008 in San Francisco
  304. Going Virtual for MS Office
  305. Going Virtual Using Mobile Apps
  306. Managing Your Contacts Across the Office Suite
  307. Charts in PowerPoint and Excel 2007 (Video Update)
  308. Outline View: The Document Planning Bridge between Word and PowerPoint
  309. Using Document Inspector in Office 2007
  310. SmartDraw: A Powerful Communications Tool to Supplement MS Office
  311. Visio 2007's New Pivot Diagram
  312. Using the Macro Recorder in Visio 2007 (Video Update)
  313. Compatibility Pack: Challenges of Using Office 2007 Documents in Previous Versions
  314. Microsoft Office Live Small Business Beta
  315. No One Asked Me But... What I Want (and Don’t Want) in the Next Office and Windows
  316. Late New Year's Resolution: Keys to Effective IT Communication
  317. SmartDraw Extras: Healthcare and Legal Templates
  318. Interesting Upgrades: Camtasia 6 and SnagIt 9
  319. Addressing the Office 2007 Read-Only Runaround
  320. Getting Organized with OneNote
  321. Flagging OneNote Information
  322. Recording and Organizing with OneNote
  323. Recording and Organizing Video in OneNote
  324. OneNote 2007
  325. Using OneNote 2007 Efficiently with Other Office 2007 Apps
  326. Using OneNote as a Voice Recorder
  327. Video Tutorials
  328. Charts in PowerPoint and Excel 2007
  329. Using PowerPoint 2007 to Create Slides That Don't Look Like PowerPoint
  330. Using the Macro Recorder in Visio 2007
  331. Playing a CD Audio in a Self Running Presentation
  332. Textboxes, QuickParts and Building Blocks in Word 2007
  333. Working Between PowerPoint and PDF
  334. Additional Resources
  335. Exploring Twine and the New Semantic Web
  336. A Tale of Two Tech Supports &#8212; OfficeLive and Zoho
  337. Digital Hollywood 2008
  338. Infocomm 2006
  339. InfoComm 2007
  340. Judging a Disc By Its Cover
  341. Surviving the Office 2007 Beta
  342. The Latest Word from CES 2007

The last time we updated the Outlook section, we created a customized E-mail message using Word's merge file feature.

This week we'll take customization a step further, by exploring the Forms Library inside of Outlook, and creating our own E-mail message form – which can make your Outlook message look like no other.

TIP

A lot of what we're going to do will require the use of Outlook or Exchange Server as the mail system, in order to work just as expected. A bit of it may translate into Internet E-mail as a whole.

The first step in the process is selecting the usual Outlook form from the Standard Forms Library that we will revise to create our own work product. This involves clicking Tools > Forms > Design Form.

Figure 236Figure 236

You'll be confronted with a dialog box with a drop down list. Keep the default Standard Forms Library, and pick an element of Outlook that you want to customize, such as Message. Click Open.

Figure 237Figure 237

The version of your message that opens is unlike what you're used to seeing. It is the "master" message – or standard form – that you can redesign and eventually publish to your personal forms.

TIP

Be careful with these forms. If you save them to the Standard Forms Library before you know what you're doing, you can make all your subsequent messages be based on what you've foolishly done.

As you look at this master form, noticed that the Edit Compose Page button is highlighted. Eventually we'll also edit the Read page, which is version of the message seen by the recipient. Note the Field Chooser window that is hovering; we may use that later on, or we can close it.

The large blank window is the message object. To confirm that, right-click on it and choose Properties. It's actually just the big field into which the user types her message.

This screenshot has some of the elements I used for my Outlook signature (a feature we covered earlier). To use these elements in the version of the message I publish to the Forms Library, I may need to re-establish the signature for the form.

Figure 238Figure 238

For now, we want to reduce the size of the Message field so we can populate our form with other cool stuff.

Click directly on it. You'll see selection handles, which let you resize the message field to reveal more of the basic background of the main form.

NOTE

If you have dabbled in VBA or Visual Basic, this is now beginning to look familiar, particularly after you click the Hammer and Wrench button on the main toolbar to open the Control Toolbox.

Figure 239Figure 239

First we'll put a label on the form to let the recipient know what's expected. Click on the "A" and drag out a label control on the form. Right-click it and select Properties, and set the properties as follows:

Name

lblExpenseRequest

Caption

Expense Request

Font

Arial 12 pt


Then check Resize with Form.

Figure 240xFigure 240

Click Apply. You have labeled your form to be an "Expense Request" – or, more literally, a special type of E-mail message.

We can add another label to be a caption to our first input field ("Venue"), and then create a textbox (the ab/ icon on the Toolbar) to represent the first field.

Right-click on the textbox, select Properties, and click the New button under the Value Tab to get the New Field dialog box.

Figure 241Figure 241

We'll name the Field Venue and keep it as a text type of field.

Now by copying and pasting these two elements onto our form again, we can quickly duplicate them and change their Properties.

What we'll get is a populated message form that has three fields into which the user will input text: Venue, Date and Expense Type. These constitute the field names for the textboxes as well, but the name for the third textbox should have no spaces; it is named ExpenseType.

Figure 242Figure 242

Let's take a look at what we've done so far. Click Form > Run this Form, and take a look at how your customized E-mail message will appear.

Figure 243Figure 243

Notice that it looks like a "regular" Outlook message, except that the message area itself is smaller, with customized areas for specific input by the user.

TIP

You can create the Read part of the form to include buttons for the recipient to use to Accept or Reject the expenses. You can further customize this form with other objects from the Toolbar, such as pictures or other types of controls.

But now let's publish the form so we can use it more readily.

Click Tools > Forms > Publish Form As.

Remember the "As" so you don't override your normal message form.

Give it a snappy name, like ExpenseRequest (no space) and click Publish. Make sure that it goes into the Personal Forms Library (not the Standard Library).

Figure 244Figure 244

When you click Publish you'll get an important reminder, to check the Send Form Definitions button in the Properties Tab. Accept this suggestion.

Figure 245Figure 245

This means that you can send this form message to a user who does not have the form already published, and it should work. To see that it's enabled, click the Properties tab after publishing the form; you should see it checked. If not, check it and republish the form.

To use the forms, all you need to do is click Tools > Forms > Choose Forms. By opening the Personal Forms Library from your drop down arrow, your newly published Expense Request form should be there for you to open as a new E-mail message.

Figure 246Figure 246

Fill in the information, including the To and Subject fields, and send it as you normally would. (Here I've reset the Picture properties for my signature GIF.)

Figure 247Figure 247

Obviously, in an Office environment the fields of such customized incoming messages could be captured and used to compile reports using VBA. In a future update we may add buttons to the form's Read Page so your recipient can Approve or Decline the expense report, taking advantage of other Outlook features.

You can (and should!) experiment with the field chooser and other forms (like the Tasks or Contact forms) to create your own version of Outlook elements. Just be sure to publish them to your Personal Folder and not the Standard Forms Library unless you always want to use them.

Finally, you can save Forms as works in progress by saving them with OFT extension using File > Save As in the Form Designer area.

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.