Notes - subject line

[Guest]

Hi

Can I use VBA to change the "Subject" (yes, I mean subject not body!) of an
existing Note? I am using Outlook 2003.

Many thanks

Rob F

 

[Michael Bauer]

Am Tue, 25 Oct 2005 04:56:03 -0700 schrieb Rob F:

Yes, the subject is the Note´s first line. You can use the InStr function to
look for the first vbCRLF, all the text left from that is the subject.

 

[Guest]

I'm not sure that would work. The subject is only the first line at the time
the note is created.

In a note, if you save it then open it again then change the first line, the
subject (as seen using category view) remains as it was originally. What I
need to do is change the subject line too.

I know I could write some VBA to read the properties of the old note, delete
it, and create a new one with the subject line I want (using a Msgbox etc),
but that seems a lot of faffing about!

Rob F

 

[Michael]

Hi Rob
I use the activity (type note) to create notes, not the OL notes. Than you
will have a seperate subject field for VBA.

Michael
Germany

 

[Michael Bauer]

Am Wed, 26 Oct 2005 00:49:03 -0700 schrieb Rob F:

Do you suppose or did you test that? For me, the subject changes
accordingly.

 

[Guest]

Thanks, Michael

I'm not sure what you mean by activity (type note). I use the standard 'New'
method to create a note.

I have tried this. If I create a Note like this:
"Egg [vbcrlf]
Chips"
the subject line will be "Egg" and the body is as shown. But if I change the
body to
"Sausage [vbcrlf]
Chips"
the subject does not change, i.e. it stays as "Egg" even though "Egg" is no
longer anywhere in the note. I know this is a function of notes that can't be
got around in standard Outlook functionality.
But I was hoping for some specific VBA code that could do what I want
programatically.

Thanks

Rob

 

[Michael]

Hi Rob

I mean use the journal (acitfities), not the note. In your journal you can
use the Journal type calling "Note" or Phone Call. Well, its not in yellow
like a "post it", but the advantage is, you can use "normal" forms, with any
fields.

cu here

Michael

Thanks, Michael

I'm not sure what you mean by activity (type note). I use the standard
'New'
method to create a note.

I have tried this. If I create a Note like this:
"Egg [vbcrlf]
Chips"
the subject line will be "Egg" and the body is as shown. But if I change
the
body to
"Sausage [vbcrlf]
Chips"
the subject does not change, i.e. it stays as "Egg" even though "Egg" is
no
longer anywhere in the note. I know this is a function of notes that can't
be
got around in standard Outlook functionality.
But I was hoping for some specific VBA code that could do what I want
programatically.

Thanks

Rob

Hi Rob
I use the activity (type note) to create notes, not the OL notes. Than
you
will have a seperate subject field for VBA.

Michael
Germany