Running Macros In Notes - Using O2003

[srm]

I've created a few simple macros to enter repetitive text in Notes in
Outlook 2003. Here is some sample code:

Public Sub EvaluationSoftwareRequest()

Set objItem = Application.ActiveInspector.CurrentItem
objItem.Body = objItem.Body & Format(Date, "mm/dd/yy") & "
- " & "Requested software." & vbCrLf

End Sub

I'm very new to Macros and at this point only plan to create these
items. I need some help on a few questions and was wondering if
someone can help me.

1. Is it possible to have the text enter (e.g. Requested Software)
have font attributes?

2. When I run the macro, it always enters the text at the end of the
notes, not where I have the cursor location. Can it be configured to
enter the text (e.g. Requested Software) at the cursor location?

3. Similar to my second question, when the Marco completes, the cursor
always goes to the top left in Notes. Can it be configured to keep
the cursor after the text (e.g. Requested Software)?

Thank you very much.

Shawn

 

[Sue Mosher [MVP-Outlook]]

1) Depends on the type of item. See http://www.outlookcode.com/d/formatmsg.htm

2-3) In messages, using Word or HTML objects. In other types of items, using Redemption's SafeInspector. See above link.

FYI, there is a newsgroup specifically for general Outlook programming issues "down the hall" at microsoft.public.outlook.program_vba or, via web interface, at http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.outlook.program_vba

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

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