VBA: Lotus Notes section border

[saavedra]

Friends,

I'm using VBA to create Lotus emails populated from an Excel spreadsheet, and I'm stuck on a really silly point. (This is really a Lotus Notes question but I figured out much of what I wanted about dealing with Notes through VBA from these forums so I'm hoping some expert can help.)

When I create a new section in the note, business rules require me to give it a border. They've been doing this manually for years and are used to doing this from the Notes UI. They create a new section, then go to its properties and then change it to have a border (please see the border and style part in the properties window in this screenshot).

I can't figure out how to add this border through VBA. Any ideas? I've tried changing the TitleStyle, but that only affects things like fonts and color. I have everything else done, just stuck on the border!

Thanks!

Mike

 

[John_w]

Not done it myself, but maybe SetBarColor -

http://publib.boulder.ibm.com/infoc....main.doc/H_SETBARCOLOR_METHOD_RTSECTION.html

 

[saavedra]

Thanks, John_w, but SetBarColor refers only to the little triangle that changes orientation when you click on the section header. It doesn't affect the border.

 

[Norie]

Mike

What code do you have now?

Perhaps you need to drilldown past the section, perhaps to the TextRange where you can use the SetStyle method - I found those in John W's link

I've done stuff with Notes but not anything like this, but it does remind me how complicated the whole object/class model was.

 

[FrankOvrCs]

Saavedra, please post your code til now. I am a step behind you, and would like to know how to create Sections in an email from an Excel VBA. (I have a very, very short timeline for this, so if beggers can be choosey, please post it ASAP.)

Thank you very much.