View Single Post
  #4  
Old July 20th 09, 09:13 PM posted to microsoft.public.office.developer.outlook.vba,microsoft.public.outlook,microsoft.public.outlook.program_vba
Sue Mosher [MVP][_3_]
external usenet poster
 
Posts: 465
Default Insert date at cursor location

A statement like this

Dim myOlApp As New Outlook.Application

should never appear in an Outlook VBA macro. Instead, to avoid security
prompts, you need to use the intrinsic Application object:

Set myOlApp = Application

The Outlook object model itself has no techniques for inserting data at the
insertion point. For mail/post items, your options depend on whether you're
using the Outlook editor or the Word editor. For other items, you can try
automating the toolbar commands using code like that at
http://www.outlookcode.com/threads.a...messageid=6872, but I
haven't had good results with that myself. Or, use the methods of the
SafeInspector object from the third-party Outlook Redemtion library.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

ms,
"F.H. van Zelm" wrote in message
...
Hi Sue,

Outlook 2003, 'stand alone', not server * client

My former code worked on any type of item: contact, appointment, mail.
It would insert the current date at the cursor.

Annoyance with my 'new' code is also that it gives the security warning
whereas my former code worked without.

Kind regards, Frans


"Sue Mosher [MVP]" schreef in bericht
...
In what kind of item? In what version of Outlook?


"F.H. van Zelm" wrote in message
...
Hi,

Once, I had a macro to inert the current date anywhere in the notes
field of an open item.
That macro has ... gone with the wind.

I recreated:
=====================================
Sub DateInsert()
Dim myOlApp As New Outlook.Application
Dim myItem As Object
Set myItem = myOlApp.ActiveInspector.CurrentItem
myItem.Body = Date & vbCr & myItem.Body
Set myItem = Nothing
Set myOlApp = Nothing
End Sub

=====================================
It works but, of course, inserts the date on top of any text.

What to write to make the time stamp appear at the cursor?

Many thanks, Frans
www.fhvzelm.com







Ads