Alpha Video Training
Results 1 to 29 of 29

Thread: Sending Email from a Gmail account silently

  1. #1
    "Certified" Alphaholic Ted Giles's Avatar
    Real Name
    Ted Giles
    Join Date
    Aug 2000
    Location
    In the Wolds, Louth, Lincolnshire, UK
    Posts
    4,269

    Default Sending Email from a Gmail account silently

    Is this possible?
    Ted Giles
    Example Consulting - UK
    .

    http://ec12.example-software.com//
    See our site for Alpha Support, Conversion and Upgrade.

  2. #2
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,557

    Default Re: Sending Email from a Gmail account silently

    Yes
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  3. #3
    "Certified" Alphaholic Ted Giles's Avatar
    Real Name
    Ted Giles
    Join Date
    Aug 2000
    Location
    In the Wolds, Louth, Lincolnshire, UK
    Posts
    4,269

    Default Re: Sending Email from a Gmail account silently

    So, email email2 or email no account?
    Ted Giles
    Example Consulting - UK
    .

    http://ec12.example-software.com//
    See our site for Alpha Support, Conversion and Upgrade.

  4. #4
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,557

    Default Re: Sending Email from a Gmail account silently

    Quote Originally Posted by Ted Giles View Post
    So, email email2 or email no account?
    email_send2()
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  5. #5
    "Certified" Alphaholic Ted Giles's Avatar
    Real Name
    Ted Giles
    Join Date
    Aug 2000
    Location
    In the Wolds, Louth, Lincolnshire, UK
    Posts
    4,269

    Default Re: Sending Email from a Gmail account silently

    Gracias Amigo.
    Ted Giles
    Example Consulting - UK
    .

    http://ec12.example-software.com//
    See our site for Alpha Support, Conversion and Upgrade.

  6. #6
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,557

    Default Re: Sending Email from a Gmail account silently

    de nada
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  7. #7
    "Certified" Alphaholic Ted Giles's Avatar
    Real Name
    Ted Giles
    Join Date
    Aug 2000
    Location
    In the Wolds, Louth, Lincolnshire, UK
    Posts
    4,269

    Default Re: Sending Email from a Gmail account silently

    Dos Cerveza por favor!
    Una para mi, una para mi amigo!
    Ted Giles
    Example Consulting - UK
    .

    http://ec12.example-software.com//
    See our site for Alpha Support, Conversion and Upgrade.

  8. #8
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,557

    Default Re: Sending Email from a Gmail account silently

    Negra Modelo por favor!
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  9. #9
    "Certified" Alphaholic Ted Giles's Avatar
    Real Name
    Ted Giles
    Join Date
    Aug 2000
    Location
    In the Wolds, Louth, Lincolnshire, UK
    Posts
    4,269

    Default Re: Sending Email from a Gmail account silently

    非常欢迎你
    Fēich
    Ted Giles
    Example Consulting - UK
    .

    http://ec12.example-software.com//
    See our site for Alpha Support, Conversion and Upgrade.

  10. #10
    Member
    Real Name
    Gene FitzPatrick
    Join Date
    Mar 2011
    Posts
    239

    Default Re: Sending Email from a Gmail account silently

    Does A5 V11 support SSL? Looking over the past discussions regarding the ability to email from a gmail account still leaves me wondering.

    Gene

  11. #11
    Member
    Real Name
    Jon P Moody
    Join Date
    Nov 2016
    Posts
    138

    Default Re: Sending Email from a Gmail account silently

    We have A5V11 using SSL, TLS & STARTTLS (needs to be edited in the registry if using Alpha email settings)

  12. #12
    Member
    Real Name
    Gene FitzPatrick
    Join Date
    Mar 2011
    Posts
    239

    Default Re: Sending Email from a Gmail account silently

    Editing the registry is not something a user should be doing, even if they know what they are doing. My requirement is to let the user enter their email parameters for their cosen ISP at the time of installing my application. I intend to provide them the ability to choose those settings form an form that shows at the time of installation. If they do not see anything that matches their needs, I intend to let them add to the list, test their entries, and click a button to send me their added settings using the built in A5 email function.

    A lot, I know, but I wanted to give the reader my overall intention.

    One step at a time...

    It appears to me that the email_smtp_open function does not work.

    Gene

  13. #13
    Member
    Real Name
    Jon P Moody
    Join Date
    Nov 2016
    Posts
    138

    Default Re: Sending Email from a Gmail account silently

    If the account being set up requires STARTTLS, then we use this code snippet to update the default email profile. You could modify this to use another profile if needed.

    Code:
    DIM pEmail as P
    email_profile_load("default", pEmail)
    pEmail.SMTPSecureConnectionType = "STARTTLS"
    email_profile_save("default",pEmail)
    On V11 we use email_send2, but I'm pretty sure we've used email_smtp_open etc. previously

  14. #14
    Member
    Real Name
    Gene FitzPatrick
    Join Date
    Mar 2011
    Posts
    239

    Default Re: Sending Email from a Gmail account silently

    Thanks Jon.

    I wanted to try and remove the burden of setting up the email from the user as much as possible. This was my reason for going with the email_smtp_open. To bypass the need to create a profile. I think I am barking up the wrong tree there.

    This snippet looks good. Perhaps it will even allow me to address the gmail issue? I am looking forward to working with it.

    Later gators!

  15. #15
    Member
    Real Name
    Gene FitzPatrick
    Join Date
    Mar 2011
    Posts
    239

    Default Re: Sending Email from a Gmail account silently

    Does anyone know how to create an email profile using xbasic?

    Thanks,

    Gene

  16. #16
    Member
    Real Name
    Jon P Moody
    Join Date
    Nov 2016
    Posts
    138

    Default Re: Sending Email from a Gmail account silently

    Gene,https://documentation.alphasoftware....20Function.xml lists the contents of the dot variable.

    Once it contains what you require you can
    Code:
    email_profile_save("profile name", dot variable)
    Last edited by armasoft; 12-03-2018 at 04:02 AM. Reason: missed closing bracket (I'm English)

  17. #17
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,557

    Default Re: Sending Email from a Gmail account silently

    Quote Originally Posted by armasoft View Post
    Gene,https://documentation.alphasoftware....20Function.xml lists the contents of the dot variable.

    Once it contains what you require you can
    Code:
    email_profile_save("profile name", dot variable)
    Jon

    That function updates an existing email profile.

    I think Gene is looking for adding a new profile.

    email_profile_add()
    Last edited by Al Buchholz; 12-03-2018 at 10:19 AM.
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  18. #18
    "Certified" Alphaholic Ted Giles's Avatar
    Real Name
    Ted Giles
    Join Date
    Aug 2000
    Location
    In the Wolds, Louth, Lincolnshire, UK
    Posts
    4,269

    Default Re: Sending Email from a Gmail account silently

    Look for this in the Help for V11 Gene.

    [email_profile_add() Function] type in all of this including "Function"

    Shows a few tricks.
    Ted Giles
    Example Consulting - UK
    .

    http://ec12.example-software.com//
    See our site for Alpha Support, Conversion and Upgrade.

  19. #19
    Member
    Real Name
    Gene FitzPatrick
    Join Date
    Mar 2011
    Posts
    239

    Default Re: Sending Email from a Gmail account silently

    Thanks Alan. I WAS looking for a way to CREATE a new profile with Xbasic. Email_Profile_Add() looks more appropriate.

    Ted. Thanks too. I do know that there is a lot of information in the help but I find that it is often hard to eek out.

    Regards,

    Gene

  20. #20
    Member
    Real Name
    Gene FitzPatrick
    Join Date
    Mar 2011
    Posts
    239

    Default Re: Sending Email from a Gmail account silently

    Hello again.

    This adds a profile OK but it's name is "default". Why is it's name not "System_Backup"??

    newPname = "System_Backup"
    Dim pEmail2 as P

    email_profile_add(pEmail2,newPname)
    pEmail2.sendusing = S1
    pEmail2.attach_path = S2
    pEmail2.check_interval = S3
    pEmail2.client_alias = S4
    pEmail2.client_hostname = S5
    pEmail2.client_identity = S6
    pEmail2.client_password = S7
    pEmail2.client_username = S8
    pEmail2.formatted_send_option = S9
    pEmail2.inbox = S10
    pEmail2.mail_hostname = S11
    pEmail2.mark_read = S12
    pEmail2.name = S13
    pEmail2.nSMTPAuthSelection = S14
    pEmail2.outbox = S15
    pEmail2.pop_first = S16
    pEmail2.pop_port = S17
    pEmail2.POPSecureConnectionType = S18
    pEmail2.receive_autodelete = S19
    pEmail2.receive_limit = S20
    pEmail2.smtp_password = S21
    pEmail2.smtp_port = S22
    pEmail2.smtp_username = S23
    pEmail2.SMTPSecureConnectionType = S24
    pEmail2.TimeoutSeconds = S25
    pEmail2.xmailer = S26

    email_profile_save(newPname,pEmail2)

  21. #21
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,557

    Default Re: Sending Email from a Gmail account silently

    Quote Originally Posted by Gene FitzPatrick View Post
    Hello again.

    This adds a profile OK but it's name is "default". Why is it's name not "System_Backup"??

    newPname = "System_Backup"
    Dim pEmail2 as P

    email_profile_add(pEmail2,newPname)
    pEmail2.sendusing = S1
    pEmail2.attach_path = S2
    pEmail2.check_interval = S3
    pEmail2.client_alias = S4
    pEmail2.client_hostname = S5
    pEmail2.client_identity = S6
    pEmail2.client_password = S7
    pEmail2.client_username = S8
    pEmail2.formatted_send_option = S9
    pEmail2.inbox = S10
    pEmail2.mail_hostname = S11
    pEmail2.mark_read = S12
    pEmail2.name = S13
    pEmail2.nSMTPAuthSelection = S14
    pEmail2.outbox = S15
    pEmail2.pop_first = S16
    pEmail2.pop_port = S17
    pEmail2.POPSecureConnectionType = S18
    pEmail2.receive_autodelete = S19
    pEmail2.receive_limit = S20
    pEmail2.smtp_password = S21
    pEmail2.smtp_port = S22
    pEmail2.smtp_username = S23
    pEmail2.SMTPSecureConnectionType = S24
    pEmail2.TimeoutSeconds = S25
    pEmail2.xmailer = S26

    email_profile_save(newPname,pEmail2)
    You need to include more code since I copied this and it can't resolve some variables. ie S##
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  22. #22
    Member
    Real Name
    Jon P Moody
    Join Date
    Nov 2016
    Posts
    138

    Default Re: Sending Email from a Gmail account silently

    I'd have thought you build the pointer variable first then run email_profile_add

  23. #23
    Member
    Real Name
    Gene FitzPatrick
    Join Date
    Mar 2011
    Posts
    239

    Default Re: Sending Email from a Gmail account silently

    Hi Jon and Al.

    I guess I am void in my understanding of what building a pointer variable means. I thought that dimming it before using it was all that was needed. Based on your comment, I question my understanding. Please clarify that for me.

    Al, the Sx variables just contain the data, character, numeric, or logical, as the case may be, that populate the respective fields. I define those by copying the data that exists in the default profile. In this case, the default profile is based on Comcast and runs just fine. My approach is to present each field to the user, on one form, and allow them to change ONLY the ones that may need to be changed to fit their profile requirements. The next step would be to test their changes and when all goes well, save the data in a DBF under the name of their choice then provide them the choice of making the new profile their default.

    Typing these thoughts out makes me question if A5 always saves a profile to 'default' and what I am missing is that I need to first delete the existing default before saving a new one. Is my thinking stinking?

    Thanks for your help guys.

    Gene

  24. #24
    Moderator
    Real Name
    Alan Buchholz
    Join Date
    Oct 2000
    Location
    Delavan, Wisconsin
    Posts
    9,557

    Default Re: Sending Email from a Gmail account silently

    Gene

    I ran your code in v10.5 and v11 and it built the email profile named System_Backup.

    Not sure what happened with your system.

    What is the flow?
    build a profile
    ask the user
    save new data

    Wouldn't you ask the user, then add the profile with the user data unless the user cancels?
    Al Buchholz
    Bookwood Systems, LTD
    Weekly QReportBuilder Webinars Thursday 1 pm CST

    Occam's Razor - KISS
    Normalize till it hurts - De-normalize till it works.
    Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
    When we triage a problem it is much easier to read sample systems than to read a mind.

  25. #25
    Member
    Real Name
    Gene FitzPatrick
    Join Date
    Mar 2011
    Posts
    239

    Default Re: Sending Email from a Gmail account silently

    Thanks Al.

    I am not sure what happened either. I guess I'll have to play with it a bit.

    My reason for building before asking is to address the possibility that there may be some email providers that need more information than others. If you know that would not be the case and the list of possible changes can be finitely defined, I would be glad to shift gears and just ask the user for a limited set of data. My goal is to make this whole thing painless for the users and a part of my installation procedure.

    Do you believe that is doable? To date, I have had many potential users give up at the start because they could not get the email to work without great pains. Most people are not interested in the details so I want to remove the hassle.

    Thanks for your help in this endeavor. I am sure that the many people following our conversation would also find it helpful.

    So, the question at this point is which fields represent the complete list of possible changes?

    Gene

  26. #26
    "Certified" Alphaholic Ted Giles's Avatar
    Real Name
    Ted Giles
    Join Date
    Aug 2000
    Location
    In the Wolds, Louth, Lincolnshire, UK
    Posts
    4,269

    Default Re: Sending Email from a Gmail account silently

    Question.
    Gene, please describe what you would like to hapoen.
    Forget email profiles, what needs to be done.
    If it is dependent on email fine, if not, there may be other possibilities.
    Ted Giles
    Example Consulting - UK
    .

    http://ec12.example-software.com//
    See our site for Alpha Support, Conversion and Upgrade.

  27. #27
    Member
    Real Name
    Gene FitzPatrick
    Join Date
    Mar 2011
    Posts
    239

    Default Re: Sending Email from a Gmail account silently

    Hi Ted.

    I have developed a point-of-sale and client record system over the past 7 years that handles everything a natural health facilitator does in our day-to-day business. I say our because I too am a natural health care facilitator. Been so for over 30 years. Anyway, several of the tools I have in this toolkit include mass emailing and providing the clients a copy of specific records at their request via email. Also the sending of receipts is required in some circumstances. So, yes, I need emailing functionality.

    Many people are computer-illiterate and I respect their need to use today's technology but find it unfair to expect them to learn how to set it up. When I was the product manager for the US for a product that was developed in the UK, I learned that generally speaking, the folks on your side of the pond like to tinker and make things their own. However, the US market place does not like to take the time to do so. They want everything to function out-of-the-box. This is what I am addressing by doing everything I can for them in a way that is transparent to the user.

    I hope this sums it up and provides some insight for the readers.

    Regards,

    Gene

  28. #28
    Member
    Real Name
    Gene FitzPatrick
    Join Date
    Mar 2011
    Posts
    239

    Default Re: Sending Email from a Gmail account silently

    Thanks Ted.

  29. #29
    "Certified" Alphaholic Ted Giles's Avatar
    Real Name
    Ted Giles
    Join Date
    Aug 2000
    Location
    In the Wolds, Louth, Lincolnshire, UK
    Posts
    4,269

    Default Re: Sending Email from a Gmail account silently

    Don't know if you resolved this Gene, but one way would be to insist on a Gmail account so you only have one type of account to mess with.
    Ted Giles
    Example Consulting - UK
    .

    http://ec12.example-software.com//
    See our site for Alpha Support, Conversion and Upgrade.

Similar Threads

  1. Sending mail using a gmail acc under Alpha email gives error of un or pw incorrect
    By MikeData in forum Alpha Five Version 11 - Desktop Applications
    Replies: 4
    Last Post: 01-11-2016, 12:01 PM
  2. Sending emails through Gmail
    By boba in forum Application Server Version 10 - Web/Browser Applications
    Replies: 1
    Last Post: 03-04-2011, 12:55 PM
  3. Cheking email account befor sending email
    By mmaisterrena in forum Alpha Five Version 8
    Replies: 2
    Last Post: 04-03-2008, 01:51 AM
  4. Using WAS v8 to send email via Gmail account
    By Rick Gerlach in forum Application Server Version 8
    Replies: 19
    Last Post: 03-24-2008, 06:02 AM
  5. Email send error with Gmail account
    By David Brown in forum Application Server Version 8
    Replies: 4
    Last Post: 12-16-2007, 03:09 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •