The following code works great to send an email.

vSubject = Coachmessage
vFromEmail = "myemail.net"
vToEmail = vCEmail
vCBody = coachmessage

iia = @SendMail("smtp.charter.net", vSubject, vFromEmail, vToEmail, "", "", vCBody, "", "", "")

I’d like to change vSubject to accept variables like shown below, so that it would become “automatic” if you will.  When I do change it, it works great, but then the body area of the email designated as vCBody here, does not work any longer (Does not get emailed) although the email does get sent.

vSubject = ("Dear coach" + " " + vCLast + " " + "please call these players")      
     
iia = @SendMail("smtp.charter.net", vSubject, vFromEmail, vToEmail, "", "", vCBody, "", "", "")

It almost seems as though there’s not enough time for Sesame to “grab” both the vSubject data and the vCBody data before the emailing takes place.

Also, when I address the email to more than one recipient dividing the addresses using a “;” it works sporadically.  In other words, sometimes the email goes through and other times it does not. Could this be a timing thing also?

Thanks for any help with this.

Thanks again for your help Mark.

As to the outside parentheses, I’m not sure why I used them, maybe because @SendEmail does?   I removed them to see if it would make a difference but it didn’t, just like you had indicated.

I used writeln commands as you suggested, all of the data shows correctly.  I can’t seem to find any errors in the code.  I have written and rewritten several times.  Again, when I use one variable or a "hard coded" message in the subject area the mail is sent without trouble.  When I use ("Dear coach" + " " + vCLast + " " + "please call these players") with or without the (), the subject data does not come through in the email although the writeln window reports the correct data.  I also have been using WriteLn(vFlag) to show any errors, it always responds with 0.

I’ll work on the code to get the addresses to use the CC or BCC areas to see if that helps.  In the meantime, when I address using several addresses they are separated by ";".  There is also a “;” following the last address.  I found that if I delete that last “;” the email is sent to all recipients without trouble.

Thanks,

Brandon

Thanks again for your help Mark, I’ll try to clarify.

When I use:

vSubject = “Test Subject Area”        //This is what I’m calling hard coded,  the email gets sent without error.

vSubject = Email Subject Area        //this gets whatever is typed into the “Email Subject Area” named text editor box on the form and the email is sent without error.

vSubject = ("Dear coach" + " " + vCLast + " " + "please call these players")  //When this assembled string is used for vSubject, the vSubject data gets placed into the subject area of the email correctly (In other words the assembled string works) and the email gets sent. But, what does not get sent with the email is the body portion of the email designated as vCBody here;

iia = @SendMail("smtp.charter.net", vSubject, vFromEmail, vToEmail, "", "", vCBody, "", "", "")

vCBody = coachmessage      //Gets whatever is typed into the “coachmessage” named text editor box on the form.

The short of it is, when I use the assembled string in the vSubject area, the body of the email does not get sent.


Is there code that I haven’t found yet that will remove that last “;” in the string?  This database is being built for the purpose of notifying players of changes in game schedules.  So, the database is searched for all player email addresses for the two schedule teams. Then a mass email is sent to notify all of them of the change.

Thanks,

Brandon

I have only one record in the coach’s database and it contains my last name in the vCLast LE.  As far as I can tell it does not contain ascii 13 or 10.

Thanks for the help on removing the “;”.  

Just an observation, I use MS Outlook for my email editor. When I send an email to several recipients, adding them to the “To” address field via My Contacts, the addresses are all followed by a “;” , even the last one, and the emails are sent without error.  Of course I have no Idea what Outlook does with the semicolons once Send is pressed.

I just tried this out using your code on our email server and all worked very well.

The only difference I could see was that our email server requires a login and password. It does not appear that your email server needs a login. Could you post your exact and complete code (use cut and paste), and the values of all relevant fields and variables (use writeln to print them and then cut and paste here)? I tried to piece together what you are doing from the snippets posted here, but it would help to have the actual code in its actual order with all the actual values.

No problem. Always happy to help.