[AccessD] Lotus Notes

max.wanadoo at gmail.com max.wanadoo at gmail.com
Wed Oct 24 04:22:24 CDT 2007


 
Hi Andy,

Nothing to do with  Lotus Notes per se, but I have just written a CDO email
system for bulk emails (Access 2003).
Your welcome to a copy if it  would help.  It is  not super-duper stuff and
I  have only used it in test mode.  I will be using it for real next week.

I was tempted to offer some help but as I am in Derby it is a bit far to
cover Peterborough.
Regards
Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
Sent: Tuesday, October 23, 2007 3:58 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Lotus Notes

I'll look into it. Thanks Gustav.
--
Andy Lacey
http://www.minstersystems.co.uk



--------- 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 13:00


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



--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

________________________________________________
Message sent using UebiMiau 2.7.2

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list