[AccessD] A2003: Connecting with GMAIL

Darren darren at activebilling.com.au
Tue Aug 26 21:26:57 CDT 2014


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



More information about the AccessD mailing list