[AccessD] Lotus Notes

Gustav Brock Gustav at cactus.dk
Tue Oct 23 07:56:50 CDT 2007


Hi Andy

Yes, that is doable. Marty and others have posted several code snippets how to handle the CDOSYS dll.
In the archives you can look up cdosys for these months:

2007-08
2006-07
2006-06
2006-02
2005-11

If you can accept to install external controls you may look for BLAT (which I haven't used) or those that I prefer and is much faster to work with than CDOSYS, the controls from Chilkat, though not free:

http://www.chilkatsoft.com/products.asp 

Note the IMAP component.
Also, the support is excellent.

/gustav


>>> andy at minstersystems.co.uk 23-10-2007 13:41 >>>
Interesting advice as always Gustav. The full list of what I need to do is
(I think):

- construct email, address it (to, CC and/or BCC) and add attachments
- optionally send the email or open it in email client for previewing,
editing and further addressing

Separately I also need to extract Access contact data nd write to address
books.

Does this sound feasible without talking to Notes itself? If so any
suggestions where I'd go to read more on this?

Andy


--------- Original Message --------
From: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
To: "accessd at databaseadvisors.com" <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Lotus Notes
Date: 23/10/07 11:13


Hi Andy

Your situation illustrates why we never user Outlook - in all its varieties.

If all you do is "construct, address and send emails" (no appointments,
calendar etc.), all you need is to have an SMTP server at your service, and
you can use a generic approach independent of Notes, Exhange or other
proprietary mail server. Windows offers the component CDO for this purpose.

If a copy of the outgoing mails are needed for the user, just add the user's
account as blind copy.

If you need to look up addresses in the client's mail system, most systems
offer an LDAP interface.

/gustav


>>> andy at minstersystems.co.uk 23-10-2007 11:55 >>>
Morning campers

Please no "watcha want to use Lotus Notes for" answers. Not my choice.

So the thing is my mega-app uses the Outlook object model a lot to
construct, address and send emails, with or without attachments. I also read
from incoming emails too, but that's a lesser concern. What I need to find
out is how I'd do the same if we go from Outlook/Exchange to Notes/Domino.
Do any of you heroes have any experience interfacing to Notes with VBA, or
have any good ideas where to look? I've found a couple of links and it looks
like it can be done but some help and guidance would be great.

--
Andy Lacey
http://www.minstersystems.co.uk 






More information about the AccessD mailing list