Groupwise Email (XP Professional SP2)

Topic

New Reply

I have an e-mail form that sends simple e-mail messages through Groupwise from Access. The form is pulling e-mail addresses from the database only. It is working fine on 2 PC’s, when the send messages command button is clicked it asks for the user profile and the default option is “Groupwise Default Settings” click OK to the dialog box and the message or messages are sent. Some PC’s will bring up a standard Groupwise mail to form, some do nothing. Database is a secured split database with the back end file on a Novell server. Novell Client is 4.90.0.0Sp1. Groupwise is version 6.5.1. I get the same results if I bring the tables off the network. I looked in the Control Panel Mail area and all PC’s say Delivery = Novell Transport : Profile = Novell Default Settings. Seems like some of the PC’s don’t understand to send through Groupwise directly even through the Access Send to in the menu bar. If I select File Send To Email Recipient(attachment) form the Menu bar on the PC’s that are working I get the Select Profile dialog box, on the ones that are not working I get either a Groupwise Mail To form or nothing at all. Any ideas on what the inconsistency could be caused by?

Carla Simmons

Reply | Quote

Replies

How are you initiating the e-mail message in Access? Are you doing it in code using VBA, or are you doing something else?

Reply | Quote

I used a VBA Function that I found in an Email database from Candace Tripp’s web site. This is the main Function:

If intObjectType = acSendNoObject Then
If strOutputFormat = “HTML (*.html)” Then
DoCmd.SendObject Val(Me!ObjectType), , Me!OutputFormat, strTo, strCC, strBCC, Me!Subject, Me!MessageText, Val(Me!EditMessage), Me!TemplateFile
Else
DoCmd.SendObject Val(Me!ObjectType), , Me!OutputFormat, strTo, strCC, strBCC, Me!Subject, Me!MessageText, Val(Me!EditMessage)
End If
Else
If strOutputFormat = “HTML (*.html)” Then
DoCmd.SendObject Val(Me!ObjectType), Me!ObjectName, Me!OutputFormat, strTo, strCC, strBCC, Me!Subject, Me!MessageText, Val(Me!EditMessage), Me!TemplateFile
Else
DoCmd.SendObject Val(Me!ObjectType), Me!ObjectName, Me!OutputFormat, strTo, strCC, strBCC, Me!Subject, Me!MessageText, Val(Me!EditMessage)
End If
End If

There is some additional code I did not send that would do some evaluating from selections in combo boxes and grouped controls, the object type would be evaluated to be acSendNoObject, Output Format would be evaluated to be .txt files in previous procedures. I also did not send the code that pulls in the email addresses from the listboxes. Both of those pieces are working correctly when I work through the code line at a time and examine the variable values. I am not currently using any of the other options as to other Output Formats, Templates, or Attachments.

Thank you for any suggestions,
Carla

Reply | Quote

I used a VBA Function that I found in an Email database from Candace Tripp’s web site. This is the main Function:

If intObjectType = acSendNoObject Then
If strOutputFormat = “HTML (*.html)” Then
DoCmd.SendObject Val(Me!ObjectType), , Me!OutputFormat, strTo, strCC, strBCC, Me!Subject, Me!MessageText, Val(Me!EditMessage), Me!TemplateFile
Else
DoCmd.SendObject Val(Me!ObjectType), , Me!OutputFormat, strTo, strCC, strBCC, Me!Subject, Me!MessageText, Val(Me!EditMessage)
End If
Else
If strOutputFormat = “HTML (*.html)” Then
DoCmd.SendObject Val(Me!ObjectType), Me!ObjectName, Me!OutputFormat, strTo, strCC, strBCC, Me!Subject, Me!MessageText, Val(Me!EditMessage), Me!TemplateFile
Else
DoCmd.SendObject Val(Me!ObjectType), Me!ObjectName, Me!OutputFormat, strTo, strCC, strBCC, Me!Subject, Me!MessageText, Val(Me!EditMessage)
End If
End If

There is some additional code I did not send that would do some evaluating from selections in combo boxes and grouped controls, the object type would be evaluated to be acSendNoObject, Output Format would be evaluated to be .txt files in previous procedures. I also did not send the code that pulls in the email addresses from the listboxes. Both of those pieces are working correctly when I work through the code line at a time and examine the variable values. I am not currently using any of the other options as to other Output Formats, Templates, or Attachments.

Thank you for any suggestions,
Carla

Reply | Quote

Since you are using the .SendObject method, it presumes that you want to use the default email client software. Is it possible that the PCs where things don’t work correctly either don’t have a default client set, or have a client other than GroupWise set as their default? Unfortunately, I know absolutely zip about GroupWise, but I believe it does conform to the simple MAPI email protocol.

Reply | Quote

Wendel,

Your suggestion helped me find my solution. In the Mail area of Control Panel where the available Profiles are listed there is a check box that says Always prompt for profile. The check box was checked on the PC’s that were working and not checked on the ones that were not. By making this change they are all working. Go figure?

Thank you for helping me find a solution for what has been about a weeks worth of investigaion.

Carla

Reply | Quote

Wendel,

Your suggestion helped me find my solution. In the Mail area of Control Panel where the available Profiles are listed there is a check box that says Always prompt for profile. The check box was checked on the PC’s that were working and not checked on the ones that were not. By making this change they are all working. Go figure?

Thank you for helping me find a solution for what has been about a weeks worth of investigaion.

Carla

Reply | Quote

Since you are using the .SendObject method, it presumes that you want to use the default email client software. Is it possible that the PCs where things don’t work correctly either don’t have a default client set, or have a client other than GroupWise set as their default? Unfortunately, I know absolutely zip about GroupWise, but I believe it does conform to the simple MAPI email protocol.

Reply | Quote