Insert Text via Macro in Outlook 2007

[dd]

I have written the below vb macro (modified here for privacy and it works in
Word) and would like to use it to insert a signature within the Outlook New
Appointment area. It have added the developer stuff and macro button to the
New Appt Toolbar but I get an error every time (runtime error 424). Can you
help?

Sub CalendarSignature()
'
' CalendarSignature Macro
' Inserts signature, title and phone number.
'

Application.ActiveExplorer.Activate
Selection.TypeText Text:="Ms. Name"
Selection.TypeParagraph
Selection.TypeText Text:="title"
Selection.TypeParagraph
Selection.TypeText Text:="phone number"
End Sub

 

[Sue Mosher [MVP]]

Outlook has no idea what Selection refers to. Follow the instructions in the
article at
http://turtleflock-ol2007.spaces.live.com/blog/cns!C1013F1F9A99E3D8!579.entry
on getting a Word.Selection object from the body of an Outlook item.

 

[dd]

My work computer does not allow me to browse to turtleflock...I will attempt
this at home. Thank you.