Open Groupwise email from MSAccess

My MSAccess database contains contact information along with email addresses.  I would like groupwise to open with the email address filled in when my client clicks on the email address.  They will then type whatever emessage they want.  How do I do this?

Thanks in advance!
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

You can do it using VBA, by using the GroupWise APIs.  See for more information on using the GroupWise APIs.

If Joanne's feeling better, she does a lot of GroupWise VBA stuff with Word, maybe she can help you understand what I'm saying.

Alternatively, if the "mail to" link is configured right, to open a GroupWise new message dialog, you could use the default M$ "mail to" functions.
KimberleyYAuthor Commented:
"Alternatively, if the "mail to" link is configured right," - what would it look like if it was configured right - right now it reads

when the client clicks on it nothing happens - except a web browser tool bar appears
I mean the application link for the default email client.  Like, if you're in Word, and select "mail to" or "Send to ... mail recipient" depending on your version, or click on the "email" toolbar button, does GroupWise open?  If not, then your default mail client isn't set to GroupWise.

I'm not sure how many places that has to be set, but a start would be in Internet Explorer properties, Programs tab.  The setting for "E-mail:" should be GroupWise (I think it defaults to Outlook Express or Hotmail or whatever...).  Same goes for Calendar, Contact list, and if you want to use the GW client for it (and it can be...), Newsgroups.

The next place is in the Mapi provider settings (I think that'd be "mail" in Control Panel.)  Make sure GroupWise is set as the defaults there, too.

Some programs may have their own spots, and a lot of this stuff lands in the user profile, so it may have to be set more than once on the same PC.

There may be Local Group Policy settings for this, too - I haven't checked.  If so, it could be centrally distributed and enforced through ZENworks or AD GPO's.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
KimberleyYAuthor Commented:
Thanks - I will check those items and if that does it I will award your points.
KimberleyYAuthor Commented:
Thats doesn't seem to do it - I am going to use the send object method in access - we have used that successfully before at this client.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.