Notes - subject line

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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
 
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
 
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.
 
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 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


Rob F said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top