473,699 Members | 2,715 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Groupwise Email from MS Access 2000

I'm trying to create an email message in Novell Groupwise (from
Access) which the user can edit before sending. Using the code below,
I can create a message just fine, but the problem is that it gets sent
out automatically, which is not what I want. If I comment out the
Call Message.Send part of the code, it stores the message in the Work
in Progress Folder, which is great - but it deletes all the
recipients' addresses in the "TO:" field.
Does anyone know of a way that I can fix the code so it doesn't send
the email out automatically, but allows the user to edit it before
sending.

Thank is advance for your help.
*************** *************** *************** *************** *************** ***
Private Sub Send_External_M ail()

Dim asloginname As String
Dim asloginoptions As String
' GroupWise Object API variabls
Dim GWApplication As Object
Dim GWRootAccount As Object
Dim GWAddressBooks As Object
Dim GWFolders As Object
Dim GWMailBoxFolder As Object
Dim gMessage As Object
Dim gRecipients As Object
Dim gAttachments As Object
Dim i As Integer
'On Error GoTo eSend_External_ Mail

asloginname = ""
asloginoptions = ""
' Get the application object, login, and initialize the base object
Set GWApplication = CreateObject("N ovellGroupWareS ession")
Set GWRootAccount = GWApplication.L ogin(asloginnam e, asloginoptions)
Set GWAddressBooks = GWRootAccount.A ddressBooks
Set GWFolders = GWRootAccount.A llFolders
Set GWMailBoxFolder = GWRootAccount.M ailbox
Dim lWorkFolder As Object
Dim lWorkMessages As Object
Dim lMessage As Object
Dim lGWMessage As Object

' In order to send a message, it must be created from the 'WorkFolder'
list
Set lWorkFolder = GWRootAccount.W orkFolder
Set lWorkMessages = lWorkFolder.Mes sages

' Add a blank message to the list
Set lMessage = lWorkMessages.A dd("", "")

lMessage.bodyte xt.plaintext = strMessage 'RTrim(txtMessa ge.Text) +
vbLf
lMessage.Subjec t.plaintext = strSubject 'txtSubject.Tex t
'For i = 0 To GWncc1.Count - 1
Call lMessage.Recipi ents.Add(strTo) 'GWncc1.EmailAd dress(i))
'Next

Call lMessage.Attach ments.Add(strFi le, "", MailTo & " Report.rtf")
'gsAttachmentDi splayName) 'txtAttachment. Text, "",
gsAttachmentDis playName)
Call lMessage.Send

Set lGWMessage = Nothing
Set lWorkMessages = Nothing
Set lWorkFolder = Nothing
'Set CreateBlankMess age = Nothing
'MsgBox "Email sent successfully", vbInformation

' gMailForwarded = True

End Sub
Nov 12 '05 #1
1 4353
On Feb 10 2004, 10:02 am, at*******@hotma il.com (Atim) wrote in
news:5d******** *************** ***@posting.goo gle.com:
I'm trying to create an email message in Novell Groupwise (from
Access) which the user can edit before sending. Using the code below,
I can create a message just fine, but the problem is that it gets sent
out automatically, which is not what I want. If I comment out the
Call Message.Send part of the code, it stores the message in the Work
in Progress Folder, which is great - but it deletes all the
recipients' addresses in the "TO:" field.
Does anyone know of a way that I can fix the code so it doesn't send
the email out automatically, but allows the user to edit it before
sending.


In the code that you posted, you are using something called GroupWise
Object API to interact with the Groupwise engine. Object API does not
provide any user interface features - for example, the regular New Message
window that you see when you send a new email in Groupwise is provided by
the Groupwise client, which in turn uses Object API to interact with the
engine (more or less).

You have two options:

1. Create your own New Message window using an Access form. Then, from
code, create a new message based on user input on that form and send it.
In this case, the Groupwise class at
http://www.users.cloud9.net/~dfurman/code.htm may be useful to wrap the
Object API functionality in an easily accessible way.

2. Use Groupwise tokens. This is a method that allows you to automate
Groupwise client itself, so that you can start the client, open the regular
New Message window, prepopulate some of the fields, then have the user do
the rest. The code to do that is significantly different compared to what
you posted. Samples and documentation are available at
http://developer.novell.com/ndk/gwtoken.htm

--
remove a 9 to reply by email
Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2944
by: Dennis Hartmann | last post by:
Has anyone found a "display" method for the GroupwareTypeLibrary.Message object, comparable to the Display method of the Outlook.MailItem object? I simply want end user or have the option of displaying the message to edit instead of firing it straight off. Use the AddExistingMessage method versus Add? I can't find anything in the GroupWise SDK; Novell or Groupwise NG's
2
2010
by: Norman Fritag | last post by:
Hi there are there any issues with sending multiple emails via GroupWise ver. 6??? please comment. Regards Norman
1
1961
by: Molly J. Fagan | last post by:
Hello everyone-- I'm trying to develop a help desk system to replace Trak-It. We have a help desk e-mail address and want all messages sent to that e-mail address to go into an Access database (or it could be SQL Server if there is something that allows Novell Groupwise to interface with SQL Server). We have Novell Groupwise 6 and Access 2000. Any help would be appreciated.
5
2341
by: Laertes | last post by:
Hi, I know there is already a plethora of emails regarding Groupwise/Access problems but mine is slightly different to the ones I've read about. I'm trying to use the sendobject command to email reports to a list of people. Each person though should get a different report (each doctor should receive the info of their own patients), so I've set a script that
2
4206
by: acewood1 | last post by:
I've done some searching in the archives but can't seem to find an easy answer as to how to send a Groupwise email through Access 2003. I just need to open a new email and populate the "To:" line with the email address on a form. In Access 97 this simple line on a command button got the job done. DoCmd.SendObject , "", "", Me.txtEmail, "", "", "", "", True, "" I've been to Dev Ashish's site and saw the code written by Dimitri...
46
3511
by: pixie | last post by:
Hi. I have an Access DB that is for contracts. I have used the code found on Tony's site for emailing a report per person containing only their information using GroupWise. It works great but I have a problem. Right now, the code before the GroupWise code, generates reports based on time criteria. If the query has no records for a person then a report isn't created. Trouble is, the code for GroupWise email sends the auto email message even...
13
4408
by: mcsheepie | last post by:
Hi I've been happily using Dimitri Furman's email code to send messages but since upgrading to Groupwise 7 i've hit a slight problem. The code works great and sends the email as expected, however if you specify a proxy account to send the message from it does this, sends the email and then Access crashes (generic, Access has encountered and error message). I can't seem to find out where its crashing, no error messages etc, debugging doesn't...
5
2345
cori25
by: cori25 | last post by:
Hi, I have been trying to come up with a module in access using VB to allow email messages to be sent using GroupWise. I am having a hard time and was wondering if anyone has any experience with this? I knoe how to automate for Microsoft Outlook but not Groupwise. HELP!!! Thanks
1
3418
by: ncsthbell | last post by:
I saw a thread from last October with 'Tara99' where she apparently was trying to do exactly what I need to do, send enails from access using Groupwise. However, I did not see in the end where or if she finally came up with the resolution. Can anyone help me with this? I tried to send her email but says she is not accepting email. Thanks!
0
8685
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9172
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9032
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8880
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7745
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6532
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4626
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3054
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2344
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.