Stored form setting in Lotus Notes email processing

S

stickandrock

I have a button that executes some vb code that will send an email through my
Lotus Notes email account.

The email gets sent without a problem, but when the users try and open the
email they recieve an error stating that "A Stored form can not contain
computed subforms". Is there an addition setting I should be turning off
before I send the email?

Thanks,
Don
 
S

stickandrock

I'm soing this out of an access database just not sure how to code the
parameter.

Here is a copy of my code. Everything is in test mode so disregard the lack
of documentation
Function SendFacyDbMail()
'
' On Error GoTo SendFacyDbMail_Err

Dim iStartPos As Integer
Dim iEndPos As Integer
Dim icntrecp As Integer
Dim icnt As Integer
Dim intErrnum As Integer
Dim recipients() As String
Dim Msg

' Set Warnings Off
DoCmd.SetWarnings False

bErrorFound = False
strLineFeed = Chr(10)
strEmptyMsg = ""
strDate = Format(Date, "mm/dd/yyyy")
strTime = Format(Time, "hh:mm AMPM")

Set objsession = CreateObject("Notes.NotesSession")
Set objlotusdb = objsession.GETDATABASE("", "C:\Program
Files\Lotus\Notes\Data\bz90yc.nsf")
Set objdoc = objlotusdb.CREATEDOCUMENT()
objdoc.Form = "Memo"
objdoc.DeliveryReport = "C"

objdoc.Subject = "Consignment Database Updated as of " & strDate & " - "
& strTime
objdoc.body = "Consignment Database Attached" & Chr(13)
objdoc.SAVEMESSAGEONSEND = True

ReDim Preserve recipients(1)
recipients(1) = "test"

Call objdoc.Send(True, recipients)

Set objattchitem = Nothing
Set objdoc = Nothing
Set objlotusdb = Nothing
Set objsession = Nothing

DoCmd.SetWarnings True

' DoCmd.Quit acSave

Exit Function
 
E

egerds

Sorry still using OLD version of lotus notes here, same for access,
using 97
I do not use any stored forms that have calculated sub forms, but I
believe this is intentional to tighten security.
I have code similar to yours but, I embed content inline the email
instead of linking or direct contact with *.nsf files

these links may help

http://www.ibm.com/developerworks/s...&query=lotus+notes+object+model&Search=Search

http://www.ibm.com/developerworks/lotus/library/notes-ole/index.html

http://www.microsoft.com/Downloads/...49-ca83-4207-86d9-13642cfe9d8d&displayLang=en
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top