roland.leurs@trippler.nl

[roland.leurs@trippler.nl]

Well, I’m sorry but your Personalized Emailer applet is not very usable in my environment. Although the specs look good, it could probably solve some other problems too, but unfortunaly it crashes when I start it:

Error message #1:
Formativ Applet runtime error
C:Documents and SettingsadminMy DocumentsAdvansysFormativAppletsPersonalized Emailer_Flexalock.vbf
File name or class name not found during Automation operation: ‘RegExp’ at line 4434, column 5

Error message #2:
Formativ Applet runtime error
C:Documents and SettingsadminMy DocumentsAdvansysFormativAppletsPersonalized Emailer_Flexalock.vbf
Object required: ‘oRegExp’ at line 4527, column 5

Error message #3:
Formativ Applet runtime error
C:Documents and SettingsadminMy DocumentsAdvansysFormativAppletsPersonalized Emailer_Flexalock.vbf
Object required: ‘oRegExp’ at line 356, column 3

I’m running this applet on a Groupwise 6.5.5 client, Dutch language.

[roland.leurs@trippler.nl]

You add the Utilities.doevents lines in order to prevent Groupwise from crashing, don’t you? Unfortunally this does not solve my problem as Groupwise still crashes after sending 140 – 160 messages.

Here is what I do:
The first step is select 1 address book to which the message will be send.
The second step is enter a subject line and the messagebody in a Formativ form
Optionally, an attachment can be selected

After these steps, my applet enters its main loop, i.e. sending the message to each contact in the selected address book. In the body a greeting will be inserted on the first line. This greeting is stored in the contacts comment field. This is how I create and send the message:

for Each AdressBookItem in AddressBook
if AdressBookItem.emailaddress <> “” Then
‘ Create new mail message
Call GroupWise.NewMail
‘ Enter the recipient
Call GroupWise.FocusSet(fcsTo, “”)
Call GroupWise.TypeText(AdressBookItem.emailaddress)
‘ Enter the subject
Call GroupWise.FocusSet(fcsSubject, “”)
Call GroupWise.TypeText(mailbericht.mailberichtEdit1.text)
‘ Enter the message body, first insert the greeting from contact comment field
‘ after that enter the text as type in the previous window
Call GroupWise.FocusSet(fcsMessage, “”)
call GroupWise.TypeText(AdressBookItem.Comments)
call GroupWise.TypeText(chr(10) & chr(13))
Call GroupWise.TypeText(mailbericht.mailberichtMemo1.text)
‘ Add attachment if any
If bijlage <> “” Then
call GroupWise.ItemAttachmentAdd(“X00”, itcAttachClassFile, bijlage, “”)
end if
‘ Send the message
Call GroupWise.ItemSend(False)
Utilities.doevents
end if
next

But this is quite tricky, as user intervention might disrupt the creation and sending the message. And if the user doesn’t touch the computer, it always crashed after sending about 150 messages.

So I tried to change the main loop to:

for Each AdressBookItem in AddressBook
if AdressBookItem.emailaddress <> “” Then
‘ Create new mail message
Call GroupWise.NewMail
‘ Add the recipient and subject
GroupWise.CurrentItem.To_=”roland.leurs@trippler.nl”
GroupWise.CurrentItem.Subject=mailbericht.mailberichtEdit1.text
‘ Add the message body, first add the greeting from contact comment field
‘ after that add the text as type in the previous window
GroupWise.CurrentItem.Body=AdressBookItem.Comments & chr(10) & chr(13) & mailbericht.mailberichtMemo1.text
‘ Add attachment if any
If bijlage <> “” Then
call GroupWise.ItemAttachmentAdd(“X00”, itcAttachClassFile, bijlage, “”)
end if
‘ Send the message
Call GroupWise.ItemSend(False)
Utilities.doevents
end if
next

… trying to avoid the focus and typetext methods. But the subjects, to and body fields are left blank. Is this basically wrong, as I do not get any run-time or compilation error messages. After the “Call GroupWise.ItemSend(False)” command Groupwise displays a message box and says I have to enter a recipient in the To field. I’m using GW7, dutch version.

How can I send hundreds of mail with a personal greeting if this doesn’t work?

Thanks for your support,
Kind regards,
Roland Leurs

[roland.leurs@trippler.nl]

Hello,

I’m having the same problem with an applet I wrote myself. It works fine but when sending the 148th message, the Groupwise client crashes.

I have downloaded the quick_recipient_solution.exe file, but the Formativ applet is quite unreadable for normal human beings 😉 Can you please post the trick to “force Windows to process any pending messages in the Windows application message queue”?

I need this applet to send about 500-1000 mails with a personal greeting in the first line of the message body. To achieve this, the user picks an address book, and the applet processes every entry in this book. For the personal greeting it picks some information stored in each contact. This works fine for small address books but unfortunally not for larger books.

Posting your solutions is very appreciated.

Kind regards,
Roland Leurs

[roland.leurs@trippler.nl]

OK. I posted a message in that group. Let’s hope Novell works on it, as they have address book performance problems since the early groupwise days (according to Google).

I tried to run the applet on another user’s account on the same postoffice, the performance was a little bit better: 13 hours instead of 18 ….

[roland.leurs@trippler.nl]

We’re using Groupwise 7. The problem also existed on 6.5 and earlier versions.

[roland.leurs@trippler.nl]

I’m glad to find someone with the same problem. I wrote a simular solution a few years ago, and I learned to live with it. We have to import about 20.000 entries each day. On a fresh Groupwise system, it takes about 2-3 hours, but as time goes by it increased up to 10 hours.
A month ago, the total time suddenly increased up to 18 (!) hours.

At first I thought the internal database is corrupt, or at least for removed contacts, the disk space was not released. The userxxx.db file for that user was about 3 GB. After running gwcheck.exe the problem still exists.

For now I’m trying to figure out a solution to do once in a week a full import (friday), and on the other working days, just import records that have been changed.

For Advansys Support, if Novell knows about this problem, please keep asking them to work on a solution as these imports are very important for us.

[roland.leurs@trippler.nl]

I implemented the version of L.P. Irovetz as it writes directly to the logfile. So if the applet crashes I even have some logging. This is a major difference compared to the solution of MA.

Just had to change fso.CreateTextFile(Path) to fso.CreateTextFile(Fic_Path).

Thanks for your response!
Roland Leurs

[Author]

Replies