Stuart McLachlan
stuart at lexacorp.com.pg
Wed Aug 27 02:05:04 CDT 2014
Another possibility is Sockettools: http://www.catalyst.com/products/sockettools/ It's not cheap, but has very good reputation in the PowerBASIC community. "The SocketTools Library Edition has integrated support for secure, encrypted connections using the industry standard Secure Sockets Layer (SSL), Transport Layer Security (TLS) and Secure Shell (SSH) protocols. The Library Edition provides an interface for all of the major Internet protocols such as HTTP, FTPS, SFTP, SMTPS, POP3S, IMAPS and more." You can download a 30 day free evaluation. -- Stuart On 27 Aug 2014 at 6:33, Gustav Brock wrote: > Hi Darren > > Stuart is right. Gmail only accepts secure mail on port 567. > > Many years ago we used a DLL similar to Blat (not an ActiveX) with > great success. It actually never failed. > > It has, of course, evolved and now has lots of features including > handling of Gmail, Yahoo and probably outlook.com as well: > > http://www.marshallsoft.com/see4vb.htm > > It is buyware but that includes excellent support (at that time), and > a free evaluation version is for download -as I recall it, it just > appended a promotion line to sent e-mails. > > But do you really need to send directly via Gmail? Most ISPs offer a > free SMTP service (often called a smart-host) which your client could > use with standard SMTP on port 25. > > /gustav > > -----Oprindelig meddelelse----- > Fra: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] På vegne af Darren > Sendt: 27. august 2014 04:27 Til: 'Access Developers discussion and > problem solving' Emne: 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 >