[AccessD] A2003: Connecting with GMAIL

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
> 




More information about the AccessD mailing list