Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Sep 2004
    Location
    Sacramento, California, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Groupwise Email (XP Professional SP2)

    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

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Groupwise Email (XP Professional SP2)

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

  3. #3
    4 Star Lounger
    Join Date
    Sep 2004
    Location
    Sacramento, California, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Groupwise Email (XP Professional SP2)

    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

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Groupwise Email (XP Professional SP2)

    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.
    Wendell

  5. #5
    4 Star Lounger
    Join Date
    Sep 2004
    Location
    Sacramento, California, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Groupwise Email (XP Professional SP2)

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •