MS Access

[a_krupke]

We have an older application that uses the SendObject inside Access XP to
generate emails from the workstations. The process works just fine
currently as long as GroupWise is logged in.

The new requirement they are looking at is trying to attach a Word
Document to the email being generated by Access XP. I have been unable to
find a way for the SendObject command to attach a document.

Is there another VB code object inside Access to have more integration
with GroupWise?

This is the code we currently use:

Dim stMessage As String
Dim stSubject As String
stSubject = "Help Desk Ticket for " & Me.Problem & " completed on " & Me.
[Date and Time Completed]

stMessage = "The ticket you placed on " & Me.[Date and Time] & " was
declared completed by " & Me.[Assigned to] & ". Please call the Help Desk
if you have any questions."

DoCmd.RunCommand acCmdSaveRecord
DoCmd.SendObject acSendNoObject, "", "", Me.[Placed by], Me.[Recorded by],
Me.[Assigned to], stSubject, stMessage, True, ""

It basically creates variables to create a custom subject and body. Then
saves the record and sends the mail using certain fields that contain
usernames.

I know in Tools - Reference inside the VB Editor has other optional
libraries for GroupWise. Is there a better command to use?

Any help would be appreciate.

-Thanks

[r***@samc.com]

Go to the following website and do a search on Groupwise email. There is
post on using a groupwise class that works well:



http://www.mvps.org/access/modules/mdl0059.htm

Good luck

Post by a_krupke
We have an older application that uses the SendObject inside Access XP to
generate emails from the workstations. The process works just fine
currently as long as GroupWise is logged in.
The new requirement they are looking at is trying to attach a Word
Document to the email being generated by Access XP. I have been unable to
find a way for the SendObject command to attach a document.
Is there another VB code object inside Access to have more integration
with GroupWise?
Dim stMessage As String
Dim stSubject As String
stSubject = "Help Desk Ticket for " & Me.Problem & " completed on " & Me.
[Date and Time Completed]
stMessage = "The ticket you placed on " & Me.[Date and Time] & " was
declared completed by " & Me.[Assigned to] & ". Please call the Help Desk
if you have any questions."
DoCmd.RunCommand acCmdSaveRecord
DoCmd.SendObject acSendNoObject, "", "", Me.[Placed by], Me.[Recorded by],
Me.[Assigned to], stSubject, stMessage, True, ""
It basically creates variables to create a custom subject and body.

Then

Post by a_krupke
saves the record and sends the mail using certain fields that contain
usernames.
I know in Tools - Reference inside the VB Editor has other optional
libraries for GroupWise. Is there a better command to use?
Any help would be appreciate.
-Thanks