Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: foxup
  • Order by date
  1. foxup

    Sending emails with VFP with CDO

    Hi Gerrit, I had SPF setup as DNS TXT records in the mail server. All required records (SPF, DKIM, DMARC) were setup as DNS TXT records on mail server. I hope that helps. Thanks, FOXUP
  2. foxup

    Sending emails with VFP with CDO

    Chriss and Mike, Thank you all for your help guys. I managed to send out all the emails since we were sending less than 2,500 per day, the requirement from Google is that SPF OR DKIM (one or the other) be functional. It all worked out since I had SPF working. I did note...
  3. foxup

    Sending emails with VFP with CDO

    OK, I just re-checked and the TLS is working. Let me check the other 2 (DMARC and SPF). I hope this works.
  4. foxup

    Sending emails with VFP with CDO

    Hi Chriss, OK, your code: oOutlook = CreateObject("Outlook.Application") oitem=oOutlook .createitem(0) oitem.subject="Email From VFP" oitem.to="someone@example.com" oitem.body="This mail was sent from vfp using Outlook" * for HTML mail there is simply oItem.HTMLBody to put in any HTML...
  5. foxup

    Sending emails with VFP with CDO

    What do the changes from CDO to Outlook look like exactly? Can you give me an example of what the code would look like in Outlook script? Also, which mailserver software automatically apply DKIM signing of mails?
  6. foxup

    Sending emails with VFP with CDO

    How do I get the "the hash of the mail computed with the private key" ?
  7. foxup

    Sending emails with VFP with CDO

    Mike, That's exactly what's going on. The message are not being delivered due to emails not being DKIM signed. As I mentioned, all emails are being sent properly when being sent thru Outlook, so it wouldn't be the outgoing mail server. It's only when using the CDO program that they...
  8. foxup

    Sending emails with VFP with CDO

    Hi, The 4 protocols that Google has implemented and enforced (as of Feb-2024) are actually TLS, SPF, DMARC and DKIM. I have setup our servers with all the necessary DNS records for all the 4 protocols in question, including the Public Key and Private Keys for the DKIM, and they all work fine...
  9. foxup

    Sending emails with VFP with CDO

    Hi, I'm sending emails out thru VFP9 using CDO's. Everything works perfectly except that as of Feb-2024, Google insists that every email sent to Gmail users must have a DKIM signature. How do I add the DKIM signature to this code please. accno='000-000000' has_txt=.F. has_pdf=.F...
  10. foxup

    CDO TLS or SSL

    Oh I fixed it. I added these 3 lines of code and it send to all my google clients (...@gmail.com) .Fields("http://schemas.microsoft.com/cdo/configuration/smtpserverport").Value = 587 .Fields("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate").Value = 1...
  11. foxup

    CDO TLS or SSL

    Hi, I have this script that works great except when I send to people who have there email at "anybody@google.ca". I've been reading that it's a TLS or SSL problem with my script. How do I fix it so that it uses TLS or SSL? Here is the script: LOCAL iMsg,iConf DECLARE SHORT...
  12. foxup

    an SQL UPDATE command to optimize ?

    Yes, many records have the same ID but there is only 1 where its db_desc='CUSTOMER - CUSTOMER' (for each ID). It is unique and that's where the val(calpathnm) can also be found. Is there any other way to optimize into an UPDATE or REPLACE with less than 4 commands? I hear what I you're...
  13. foxup

    an SQL UPDATE command to optimize ?

    I can simply run a GROUP BY afterwards so don't worry about that. My goal is; I would like to: REPLACE source._QTY with val(calpathnm) for db_desc='DIGITAL BUSINESS LINE' and VAL(callpathnm)>0 ....and the ID is the same ID. Note, the val(calpathnm) can only be found when...
  14. foxup

    an SQL UPDATE command to optimize ?

    Hi, The callpathnm is not in the same record as the "DIGITAL BUSINESS LINE", or else I would do a simple replace and it would solve my problem. The callpathnm is in the same ID but not the same record. Please help. Thanks, FOXUP
  15. foxup

    an SQL UPDATE command to optimize ?

    Hi, Here is the data: The _QTY field for "DIGITAL BUSINESS LINES" only needs to be the VAL(callpathnm) respectively as per their ID. I hope that somebody can help me. Thanks, FOXUP!
  16. foxup

    an SQL UPDATE command to optimize ?

    Hello, That command doesn't get the proper result. If you look carefully at the 4 lines of code, you'll see that I'm replacing source._qty with digibuzlines.cps FOR source.db_desc='DIGITAL BUSINESS LINE' AND source.id = digibuzlines.id That UPDATE command does not work properly...
  17. foxup

    an SQL UPDATE command to optimize ?

    Hi everybody, I need a simple optimization for these 4 lines of code. I would like to have it into 1 command instead (if possible). These are the 4 lines of code: USE C:\union\BOUNCE_SUP990\SOURCE sele id, VAL(callpathnm) as cps from C:\union\bounce_sup990\source WHERE val(callpathnm)>0...
  18. foxup

    equivalent of SPACE(2) in an SQL command needed

    Hi, It still puts a ".NULL." in the field, but I'll take it ! LOL [bigsmile] Thanks to Mike and Tamar. :) 2 stars ! Regards, FOXUP!
  19. foxup

    equivalent of SPACE(2) in an SQL command needed

    Hi Mike, You're very close though. I need a 2-digit field just containing nothing for now (not even a zero). In other words, the end result I need is exactly as if I were to "modify the structure" and add a numeric field (it's not filled with a zero). Your sample seems to fill in a zero...
  20. foxup

    equivalent of SPACE(2) in an SQL command needed

    Hello, I haven't used this in a while but what's the NUMERIC equivalent of SPACE(2) in an SQL command. I would need help with this example. Example: SELECT remark, min_users, SPACE(2) as temp FROM DBF() gives me a new Character Field of 2 characters long named "temp". I would...

Part and Inventory Search

Back
Top