VBA outlook question

[Farback]

We use a shared mailbox, and I use the following code to insert text into the Subject line of received e-mails, so that colleagues know I am working on them:

On Error Resume Next
Dim strMessage As String
strMessage = "Joe is dealing with this request " & Now() & " - "
Set msg = Application.ActiveInspector.CurrentItem
msg.Subject = strMessage & msg.Subject
msg.Save

My problem is that the Now() formats as 'dd/mm/yy hh:mm:ss'
How do I control the way that Now() formats, i.e I might want to show it as 'dd mmm', or as 'dd/mm/yy hh:mm'

Any help appreciated

 

[SuperFerret]

Don't know how to translate this into VBA but:
TEXT(NOW(),"dd mmm")

or

TEXT(NOW(),"dd/mm/yy hh:mm")

would be the Formula if that helps [note I have never coded Outlook before]

 

[RoryA]

In VBA it's Format:

Format(Now(), "dd mmmm")

for example.

 

[SuperFerret]

In VBA it's Format:

Format(Now(), "dd mmmm")

for example.

Well that's definitely going into my notes

 

[Farback]

Thank You both for the swift response. rorya, your code did what I needed, thank you very much.