|VBOffice Reporter is an easy to use tool for data analysis and reporting in Outlook. A single click, for instance, allows you to see the number of hours planned for meetings the next month.|
Since the version 2007, Outlook always uses Microsoft Word as e-mail editor. That allows developers to use the powerful library of Word to edit the content of e-mails and other items. Even better, there is a macro recorder in Word, which you don't have in Outlook. That is you can record a macro in Word and use the same code in the Outlook VBA project, too.
You can record a macro via the Developer tab in Word. If you don't see it on the ribbon, right click on the ribbon, choose Customize the Ribbon. In the list right hand check Developer and OK out. On the Developer tab click Record Macro.
In this sample I've started the recording, then typed the word "Hello" into the document and marked it bold. The following shows the result of the macro recorder:
Sub Macro1() ' ' Macro1 Macro ' ' Selection.TypeText Text:="Hello" Selection.MoveLeft Unit:=wdWord, Count:=1, Extend:=wdExtend Selection.Font.Bold = wdToggle End Sub
|Access the master category list in the blink of an eye, share your color categories in a network, get a reminder service, and more.|
As you see Word uses the Selection object to edit the text of a document. In order to use such a macro in Outlook, just set a variable to the Selection object of the email.
(First click Tools/References, and set a reference to the "Microsoft Word x.0 Object Library" so Outlook can recognize the objects used by Word.)
Public Sub UseWord() Dim Ins As Outlook.Inspector Dim Document As Word.Document Dim Word As Word.Application Dim Selection As Word.Selection Set Ins = Application.ActiveInspector Set Document = Ins.WordEditor Set Word = Document.Application Set Selection = Word.Selection 'insert here your macro from word End Sub
|OLKeeper reliably prevents users from closing their Outlook window and thus possibly missing reminders or e-mails.|