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