Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lotus Notes Automation Problem

Status
Not open for further replies.

MikeC14081972

Programmer
May 31, 2006
137
GB
I have a module in Access (2000) that is building an email in Lotus Notes (ver 6.5) but I'm having a couple of problems.

1. The email is being produced in the draft folder of the user who is logged into to Notes on the PC. The requirement is for the email to be produced in the draft folder of a group mailbox which they have open.

2. I'm appending data to the body of the email using
Code:
objNotesRTF.AppendText "Required Text"
Is there anyway of formatting the text that appears in the mail body i.e. underline, bold, font size etc from within the VBA code.

Many Thanks

Mike.

If you make something idiot proof - They'll Only make a better idiot!!!
 
wiglaer's contibution to thread222-766157 may help you but I fear you need more. It is written in VB6 but should not take much conversion.
 
Right got the text formatting sorted now

Code:
Set bodytext = objSession.CreateRichTextStyle

With bodytext
     .NotesFont = FONT_COURIER
     .FontSize = 10
     .Bold = 0
     .Underline = 0
     .NotesColor = COLOR_BLACK
End With

With objNotesRTF
     .AppendStyle (bodytext)
     .AppendText "Required Text"
     .Addnewline2
End With

etc  etc  etc

Just need help telling the procedure which dratf folder to send the email to.

Any help appreciated

Thanks

Mike

If you make something idiot proof - They'll Only make a better idiot!!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top