LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default Lotus Notes email from Excel - formatting body text.

How can I format the body of an email message in a Lotus Notes e-mail?

I have instructions for the recipients and would like to boldface a
few items, underline one key phrase, and ensure that the hyperlinks
(static, not the variable part of the mail merge) work automatically
from the receiver's end.

I create the message string in the code without problems. However, it
comes through as plain text and I would either like to convert/paste
it as rich text or manipulate the formatting in some other way. I am
thinking about creating the string and applying it to a worksheet
cell, then formatting it, ccopy then paste into the body, but have not
been successful as of yet.

Any thoughts and/or guidance? The e-mail code is shown. Msg is the
string variable that I need to format.

'''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''
Sub SendMail(sendlist, Msg As String, SubjLine As String)

Dim arrList

Dim objNotesSession As Object, _
objNotesDatabase As Object, _
objNotesDocument As Object, _
objAttachment As Object, _
objRichText As Object

Const EMBED_ATTACHMENT = 1454

Set objNotesSession = CreateObject("Notes.Notessession")
Set objNotesDatabase = objNotesSession.GetDatabase("", "")
Call objNotesDatabase.OpenMail 'default mail database
If objNotesDatabase.IsOpen = False Then
MsgBox "Cannot connect to Lotus Notes."
Exit Sub
End If
Set objNotesDocument = objNotesDatabase.CreateDocument
Call objNotesDocument.ReplaceItemValue("Form", "Memo")


arrList = Split(sendlist & "," & objNotesSession.CommonUserName,
Chr(44))
ReDim Preserve arrList(LBound(arrList) To UBound(arrList) - 1)

With objNotesDocument
.Subject = SubjLine
.Body = Msg
.SendTo = arrList
.CopyTo = objNotesSession.CommonUserName
.BlindCopyTo = vbNullString
.SaveMessageOnSend = True ' save in Sent folder
.Send (False)
End With
End Sub
'''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I send an Excel workbook through Lotus Notes Email? Valerie Excel Discussion (Misc queries) 1 May 3rd 08 04:51 PM
?? Email Excel sheet thru Lotus Notes Jaylin Excel Discussion (Misc queries) 1 October 16th 07 05:12 PM
??email excel sheet w Lotus notes Jaylin Excel Discussion (Misc queries) 3 October 12th 07 03:40 PM
Email a chart from excel via Lotus Notes [email protected] Excel Programming 1 February 8th 07 10:32 PM
Excel VBA to send email using Lotus Notes Nirmal Singh Excel Programming 3 April 28th 05 11:15 PM


All times are GMT +1. The time now is 02:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"