Cannot use SendObject!!!

[cybergar]

I need to send a simple email message whenever a new record is added to my database (using Access 2000). I've read a TON of information about how to send email from Access, but they all reference things we don't have! We can't use Outlook (can't even install it) on our network because our mail system is Groupwise. This means we don't have the required Reference objects for VBA.
Can anyone out there give me any help with this problem? I've thought of simply putting the CDO library on our workstations, but that would mean copying it to nearly 200 machines covering 2 states in the US and another country! Not an easy task, so I'd like to avoid that if possible...

 

[Chris RR]

Hi,
I use Access2k & Groupwise 5.5. It took us weeks to get to what we felt was the best method. There actually are several ways to do it.

Here's some ideas.
1. You should be able to do use SendObject in a macro or from code. This always gets us a prompt for the GW "profile", so we don't use it much.

2. You can write code using MAPI. GroupWise is MAPI complient. You should have the reference objects for VBA. Look for GWCMBI.DLL or GWCMA1.DLL. The idea is to create a MAPI session, do various MAPI .add commands to get in the subject, to, cc, etc., fields, then a .send.

3. You can use DDE in code. If GW isn't open, do a Shell command to open it, then use DDEExecute to send. This is what we use when we want a process to run completely unattended, as it doesn't need to prompt for anything. You do not need the GW references for this to work. However, it's not the slickest way to go technically.

 

[Macy]

Chris RR,
Can I send an RTF doc using MAPI? How did you do the DDE?