ProFox

profox@leafe.com

2704 discussions

Email with CDO error
by Rafael Copquin 26 Sep '17

26 Sep '17

I am trying to send emails from VFP using CDO. This is a system that needs to send pdf images of invoices to 400+ customers. I opened accounts in gmail, yahoo and hotmail and always get the same error message: error 1429 Ole dispatch exception code 0 from CDO.Messsage.1:Transport error connecting to server This is my code: loCfg=CREATEOBJECT("CDO.Configuration") WITH loCfg.Fields ..Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "smtp.gmail.com" ..Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 465 ..Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 ..Item("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") = 10 ..Item("http://schemas.microsoft.com/cdo/configuration/sendusername") = "myaccount(a)gmail.com" ..Item("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "mypassword" ..Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = .t. ..Item("http://schemas.microsoft.com/cdo/configuration/smtpusessl") = .t. .Update ENDWITH loMsg = CREATEOBJECT ("CDO.Message") WITH loMsg ..Configuration = loCfg ..From = "myaccount(a)gmail.com" ..To = 'myotheraccount(a)hotmail.com' ..Subject = 'Enviamos factura electrónica' ..TextBody = 'Please find attached your invoice for the month of October 2017' ..AddAttachment('c:\invoices\fe_261_092017_1.pdf') ..Send() endwith loCfg = NULL loMsg = NULL Either with an attachment or without one, I get the same error. I configured gmail to accept sending from "unsafe" apps (is VFP an unsafe app?). Did the same in yahoo and in hotmail. But I always get the same error What I am doing wrong? What is the workaround? NOTE: this happens even if I try to send just one message, let alone 400+ TIA Rafael Copquin --- Este correo electrónico ha sido comprobado en busca de virus por AVG. http://www.avg.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

6 7

Re: email with CDO error
by Rafael Copquin 26 Sep '17

26 Sep '17

I used a similar code. Actually what I had to do was put the original code (the one quoted in my first email on this) in a prg, called from the form I had this code within a loop (that iterated some 400 times) in my send_email form. But it would not work. When I took the code out of the form and placed it into a prg, it worked! A pseudocode of my form calling the prg is: select curInvoices scan all cTo = alltrim(curInvoices.email) && get the email from each customer cAttach = alltrim(curInvoices.invoice) && contains path to the pdf and its individual name do sendemail with cTo,cAttach endscan I also put a counter to iterate 10 times, then wait 15 seconds and then pick another ten emails and so on. This is to avoid gmail rejecting a big load of emails sent at once. Of course I had to turn on the 'less secure apps' setting on the Gmail account first, and then it worked perfectly. I wonder why it would not work with the cdo code directly on the form. BTW, my client runs this app from a Windows 7 prof computer, for what its worth. Thank you all for your suggestions Rafael Copquin El 26/09/2017 a las 7:54, Alan Bourke escribió: > I've just tested this code and it sent successfully, but not until I > turned on the 'less secure apps' setting on the Gmail account. > > https://gist.github.com/anonymous/ddb479e315bcc45efb0d4703fc05b836 > <https://gist.github.com/anonymous/ddb479e315bcc45efb0d4703fc05b836> > --- Este correo electrónico ha sido comprobado en busca de virus por AVG. http://www.avg.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

RE: [NF] Excel Text formatted cells converting to scientific notation when saving as csv
by Gene Wirchenko 24 Sep '17

24 Sep '17

At 07:55 2017-09-20, Richard Kaye <rkaye(a)invaluable.com> wrote: >Pretty sure. Unless you use a source file type that might contain >formatting info, Excel is trying to be helpful by making educated >guesses about the contents of a cell. Which can be disastrous: http://catless.ncl.ac.uk/Risks/24/19#subj6.1 Excel garbles microarray experiment data Another example of mishelpfulness: I was using Word on a uni system. I was in a hurry to apply to a co-op job so I did not do my usual option setting. That would have included turning off AutoCorrect (a horrid name). I saw a flash at the top of the page and looked. Word had "corrected" the E-mail address on my resume. [snipped previous] Sincerely, Gene Wirchenko

1 0

[NF] Excel Text formatted cells converting to scientific notation when saving as csv
by Michael Madigan 22 Sep '17

22 Sep '17

I thought I'd pass this tip along. If you have large text fields with numeric values, like insurance policy numbers or UPC Codes, you have to format the cell with custom type ############### or similar, otherwise the CSV file gets scientific notation values, even if the cell is of type text. Hope this saves someone some time. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 7

Dynamic DNS, was (preferably free) unattended remote access
by Ted Roche 21 Sep '17

21 Sep '17

I haven't tried the GoDaddy API for ddns. Let us know how that works. I've got a (FREE!) account at DuckDNS https://www.duckdns.org/install.jsp and I've been using that, with the clients where I have an embedded server, to run a ddclient that keeps the duckdns DNS entries up to date. I added a second level of abstraction, so I've added CNAMEs of client1.tedroche.com, client2.tedroche.com to my own DNS, as I've got a DNS with unlimited entries, and that way I can depend on these CNAMEs in scripts and configuration files, even if I switch to FredsFreeDNS or whatever. On Thu, Sep 21, 2017 at 11:07 AM, AndyHC <andy(a)hawthorncottage.com> wrote: > On 20-Sep-17 11:41 AM, Ted Roche wrote: >> >> /.......an SSH tunnel is not that difficult to set up/ >> <snip> >> Certainly my preferred solution, In several small biz I work with (3-6 >> people), the data and my app end up on a Linux box in their office >> that provides them with Samba and Apache intranet and other useful >> functions, as well as proving a robust ssh server inside their network >> that can send log files and let me know when their external IP address >> changes. A small workgroup server is a fairly inexpensive capital >> outlay for most businesses. >> >> > Yes, I've done most of the above using WD NAS boxen and some of it just on > the router , RasPi should also be pretty simple (trying that next, with the > GoDaddy API for ddns - I think it needs nodejs which might be fun!). > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server]

2 1

Focus not returning to command window after CreateObject
by Paul Newton 21 Sep '17

21 Sep '17

Hi all In the command window if I run the command o = CreateObject("Excel.Application"), an instance of Excel is created and focus returns to the command window. If I run the command o = CreateObject("Stopwatch.Stopwatch"), an instance of my stopwatch (in Stopwatch.EXE) is created but focus does NOT return to the command window. Any ideas? TIA Paul Newton

4 12

Send (hot) keys to a Windows application
by Paul Newton 21 Sep '17

21 Sep '17

Hi all I have an external application that responds to hot keys (e.g. CTRL+ALT+S) even when its window is not active/on top. Any ideas as to how I could send that key combination from VFP? Many thanks Paul Newton

2 4

[NF] Suggestions: job boards, listings, contacts? for Senior Technical Writer
by Ted Roche 20 Sep '17

20 Sep '17

Slightly off-topic, your indulgence please. A friend of a friend finds themselves at the end of 30+ year career in a need of a new position. Highly skilled technical writer, worked in several of the well known high-tech firms. Needs a new placement, full-time, part- or contractual. I don't know where I should suggest she look, besides the usual platitudes of "call all your contacts and exercise your networks," which she's already working. Any suggestions for online services worth the effort, or does anyone know anyone looking for a great writer? -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com

2 1

Re: [OT] Hallo
by Gene Wirchenko 20 Sep '17

20 Sep '17

At 11:01 2017-09-18, Laurie Alvey <trukker41(a)gmail.com> wrote: >Good. Thought I;d been ostracised. You were, but then we realised that we should probably tell you about it. No, not really. I had a gap of nothing for the 15th to 17th, too. [snip] Sincerely, Gene Wirchenko

1 0

Re: [NF] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home
by Brant E Layton 19 Sep '17

19 Sep '17

Hi All, ShowMyPC (showmypc.com) used to be $5 per month for an unattended connection... *Brant Layton* 480.964.1316 On 9/19/2017 7:22 AM, profoxtech-request(a)leafe.com wrote: > Re: [NF] Customer asking for (preferably free) unattended > remote access software so she can access her work machine from > home --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox