Stuart McLachlan
stuart at lexacorp.com.pg
Wed Aug 27 16:02:21 CDT 2014
Good call!. I haven't worked with CDO, but this looks like a good basic tutorial including the UseSSL flag: http://www.activecallcenter.com/manual/591.htm On 27 Aug 2014 at 9:23, Doug Murphy wrote: > You can send email from Access through the GMAIL SMTP server using > CDO. I assume CDO is still in Windows. Many years ago I had a system > set up for user group emails that used this approach. There is a > sample and presentation file on this subject on our Access User Group > of San Diego web site at > http://www.augsd.org/Portals/0/Articles/cdomail_v2.zip. You do have to > use the secure port with the Google server. For organizations the > Google services are great since folks can have common calendars, task > lists, etc. > > Doug > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren > Sent: Tuesday, August 26, 2014 7:27 PM To: 'Access Developers > discussion and problem solving' Subject: Re: [AccessD] A2003: > Connecting with GMAIL > > Thanks Stuart. > Probably explains the lack of examples on the googles. > > Anyone have thoughts on getting them to use something like outlook or > even Blat on their RemoteDesktops instead of Gmail? > > As for calendaring there are a gajillion calendaring options for > Access that I can explore. > > Concept question: > I figure the advantage to having GMAIL and Google calendars is you > only need a network connection and a browser to get at them. Is it not > the same concept with doing things via a RemDesktop? Just need a > network connection, mstsc.exe and an address (host)? Thanks > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart > McLachlan Sent: Wednesday, 27 August 2014 11:49 AM To: Access > Developers discussion and problem solving Subject: Re: [AccessD] > A2003: Connecting with GMAIL > > Sorry, just did a bit more checking. GMail requires SSL/TLS so you > can't use Blat with it directly. You would need to also set up > stunnel which would be a real PITA. > > -- > Stuart > > On 27 Aug 2014 at 11:05, Darren wrote: > > > Hey Stuart, > > Sounds good. I've heard you speak of Blat before. Now it's relevant > > to me... so now I'm now listening :-) - lol So what's involved? How > > does BLAT work with GMAIL? > > > > Also - I'll explain what I'm doing. As I'll have a lot of q's for > > the list in the coming months, I expect. I'm about to embark on a > > big pro-bono exercise for a Community based charity here. About to > > write (have a started actually) a tool to manage their clients and > > their associated programs. And will do it in Access - all accessed > > by (Terminal Server)Remote Desktop logons. At the moment they are > > using GMAIL and Google as their email and calendaring tools. So > > rather than force them 'into anything', I thought I'd see if I could > > 'interact' with whatever they have already in place. They have no > > money it's largely volunteers and non-techies running the show. So > > whatever I give them has to be simple with not a lot of upheaval if > > possible. Make sense? I know a lot of you have been in exactly this > > position before. Thanks heaps Darren > > > > -----Original Message----- > > From: accessd-bounces at databaseadvisors.com > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart > > McLachlan Sent: Wednesday, 27 August 2014 10:38 AM To: Access > > Developers discussion and problem solving Subject: Re: [AccessD] > > A2003: Connecting with GMAIL > > > > I would build the email in code from the various text boxes and use > > Blat.DLL to send it to GMail. > > > > -- > > Stuart > > > > On 27 Aug 2014 at 10:14, Darren wrote: > > > > > Hi Y'all > > > Do any of you have experience connecting to GMAIL from Access? IE > > > - Sending emails via the GMAIL account using Access Screens etc. I > > > found some 'dead' links on the googles, not much else for VBA. > > > Many thanks in advance Darren > > > > > > -- > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > > > > > > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >