Steve -
I don't think I will have a problem with my ISP but that is not my concern.
My conern is how do you set up e-mail to be used with mass update so that the user doesn't have to know programming.
The only way I could figure it out is to put it in the programming statement for a mass update. The following code may NOT be correct. I had it working right but wanted to make some modification to it and created some flaws which I just haven't had time to correct (although the last few times I ran it, it worked just fine). In any event, I'm showing it here anyhow just to give you the idea.
var ii as Int
If
@askuser("Is this the message you want to send?","","")
then
{
ii = @SendMail("SMTP-SERVER.TAMPABAY.RR.COM",
"Testing SendMail", Email Address,
"swulwick@tampabay.rr.com","SpencerWulwick@myfamily.com",
"swulwick@tampabay.rr.com", "Hi " + First Name + ", " + @newline()
+ @newline() + LastEMail+@newline() +@newline() + "Spencer Wulwick" +@newline() +
"Silver sOlutionS of Tampa, Inc." + @newline() + "www.SilversOlutionS.org")
If ii = "0"
then
@Msg("Your e-mail is being processed")
LastEMail = ("The following e-mail was sent to " + First Name + " " + Last Name + " on "
+ @month$(@date) + " " + @dom(@date) + ", " + @year(@date) + " at " + @time + @newline() + @newline()
+ "Hi " + First Name + ", " + @newline () + @newline() + LastEMail+@newline() +@newline() + "Spencer Wulwick" +@newline() + "Silver sOlutionS of Tampa, Inc." +@newline() + "www.SilversOlutionS.org")}
else
@msg("Type your new message and press the Send button again again")
(The code currently resides in the on-element-entry event of a command button named Send - which is right at the foot of the element where they type the body).
This is very simple - when used on a record-by-record basis, because all the user has to do is enter the body of the e-mail in the LastEMail element. The "greeting" and closing is automatically entered by the programming. A copy of the email is kept in the database; however, ONLY the MOST RECENT e-mail. The bcc that comes back to me goes in a special folder within my e-mail program for "historical" purposes as long as needed.
Now, individual e-mails are no problem because the user simply has to change the message in the field. BUT, suppose I wanted to send the message to 50 recipients. The only approach I could think of is to put the programming - including the "body" portion of the e-mail in the mass update program spec. That is no problem for me, but I don't want the casual user to have to do that.
So, I guess what I'm asking is how can I have the user type the message in one record but have it sent to that person and 49 others?
The only thing I could think of is to retrieve the 50 records, type it in once and then mass update the other 49 records to contain the same e-mail "body" and then run mass update again, with a saved mass update spec. But somehow, I feel like I am missing something and that there should be a "smoother" way to do this.
So, that's what I'm looking for ideas about. I have got to get this worked out because I am sending MYSELF HUNDREDS of e-mails and I AM TIRED OF HEARING FROM ME. I even sent a few cc's to Ray to see whether he was getting them; however, I never heard from him. (I guess he didn't want to encourage me to keep doing it). lol
Anyhow, I just want to "master" this issue and move on to other things. After all, I don't want to look like a "complete" dummy when Erika gets here to train me. Speaking of which:
JUST 13 MORE DAYS TO GO!!!
Thanks!