MartyConnelly
martyconnelly at shaw.ca
Tue Jul 18 15:56:38 CDT 2006
If you want to turn on SSL with the CDO code you got. in the configuration section With objCDOMail.Fields .Item(strschema & "sendusing") = 2 ' cdoSendUsingPort .Item(strschema & "smtpserver") = "shawmail.cg.shawcable.net" ' "Your SMTP server address here" .Item(strschema & "smtpserverport") = 25 'specify port number .Update End With just add this line .Item(strschema & "smtpusessl") = True 'Use SSL for the connection ( True or False) More examples here. http://www.paulsadowski.com/WSH/cdo.htm#LoadFromFile Max Home wrote: >Marty, I am so sorry. I meant to say SMTP not Pop3. I hope this hasn't >caused you (and others) any problems. >It sends email via SMTP and I would like to send it via IMAP so that it >appears to come as if from the webmailer without having to go through >Outlook (I can do it via Outlook with no problem) but not from within your >program. > > >Regards >Max >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly >Sent: 17 July 2006 21:25 >To: Access Developers discussion and problem solving >Subject: Re: [AccessD] CDOSYS > >I don't remember using any POP3 in code, >it is a different protocol than SMTP. >Perhaps you could repost the code. > >One big problem is recent ISP security restrictions. > Some cable ISP's will not allow an IP from outside their >domain to access a POP3 server, >POP3 access wont work at all with DSL or dial-up connections. >Some ISP's don't allow any connection at all. > >To check yours, you can try to access POP3 via Telnet >Try it on rarely used Email account. > >You could try this to get into POP3 port 110 > but it may take 10 minutes to activate. > >telnet shawmail.vc.shawcable.net 110 > >Then use valid commands eg. 'user', >'pass', 'list', 'top', & 'quit and maybe "RETR" > >Here are some old samples of VB code >to get at POP3. Pretty basic and they might not >handle file attachments etc. They generally all >use Win Sockets. > >Microsoft Access Email FAQ >http://www.granite.ab.ca/access/email.htm > >Programmer's Toolkit (VB/Winsock) for Internet Mail VB 5 code from book >Programmer's Guide to Internet Mail by John Rhoton, Digital Press 1999. >ISBN: 1-55558-212-5 > >http://www.winsite.com/bin/Info?500000022279 > >or Access email via winsock.dll in German >This only sends email via SMTP or POP3 server >http://www.freeaccess.de/downloaddetails.asp?id=19 > >processing mail from a pop3 mailbox a semi freebie dll > http://www.interlog.com/~tcharron/getmail.html > > >Articles on using WinSockets in VB >http://www.vbip.com/winsock-api/ >http://www.vbip.com/winsock-api/connect/connect-01.asp > > > > >Max Home wrote: > > > >>Hi Marty, >>Don't know if this is possible, but within your program you have it set up >>to use Pop3. Can it also handle Imap? Currently there is nowhere to enter >>the question that is in the Outlook Advanced Tab = "This Server Requires an >>Encrypted Connection (SSL)" that is present in Outlook from where it works >>fine. >> >>It would be nice if I could use it to send emails via the domain as it were >>webmail. I can do it using Outlook, but would prefer to miss out Outlook >> >> >if > > >>possible. >> >>Can you advise please? >> >>Regards >>Max >>-----Original Message----- >>From: accessd-bounces at databaseadvisors.com >>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Home >>Sent: 13 July 2006 19:31 >>To: 'Access Developers discussion and problem solving' >>Subject: Re: [AccessD] CDOSYS >> >>Great reply. Thanks for all the pointers, Marty >> >> >>Regards >>Max >>-----Original Message----- >>From: accessd-bounces at databaseadvisors.com >>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly >>Sent: 13 July 2006 19:10 >>To: Access Developers discussion and problem solving >>Subject: Re: [AccessD] CDOSYS >> >>CDOSYS does not allow to read e-mail, only to send them. >>While CDOSYS doesn't allow you to pull mail via POP3 or >>IMAP4, it can load a raw MIME message as stream >>for example from an .EML file saved to your hard disc. >>This can get complicated really quickly . So it is possible >>but I can think of better ways of spending the summer. >> >>Or you could use a dotNet DLL to call POP3 via tcpconnection class >>See 8.13 >>http://www.microsoft.com/mspress/books/sampchap/6436a.asp >> >>Pop3 controls callable from Access; a lot out there generally work >>through sockets >> >>Freebies >> >>ZaksPop3 Java based. >>http://www.zaks.demon.co.uk/code/cpts/pop/index.html >> >>Commercial >>http://www.quiksoft.com/newsletter/issue003/ >> >>GETMAIL for Windows free for personal use >> >>http://www.interlog.com/~tcharron/getmail.html >> >>Max Home wrote: >> >> >> >> >> >>>Hi, Marty Connelly, >>> >>>You kindly posted some code for using CDOSYS to send Emails. On the >>> >>> >example > > >>>form, you had some fields for receiving emails via Pop3. I was wondering >>>Marty if you (or anybody) had any code for these options and also if it >>>could handle IMapi accounts from a web mail account? >>> >>>Any help would be appreciated. >>> >>>Regards >>>Max >>> >>> >>> >>> >>> >>> >>> >>> >> >> >> >> > > > -- Marty Connelly Victoria, B.C. Canada