Re: re SMS with 4D

> I should have looked before sending the last email. The IF state  
> follows confirm
>
> CONFIRM("Send Coordination email for "+[Form05]Trustee Call)
> If (OK=1)
>
>
> J. Allen (Pete) Seabolt
> LCS Technology
> 51 Mountain View Drive
> Dahlonega, GA 30533
> Home 706-864-6613
> Work 706-864-2169 x1
>
> On Apr 28, 2008, at 8:03 AM, Gareth Home Openworld wrote:
>
>> There seems to be a missing IF.
>> Also, apologies if I'm being stupid but how would you call this  
>> procedure/Method ?
>> Thanks,
>> Gareth
>>
>> On 28 Apr 2008, at 12:29, Pete Seabolt wrote:
>>
>>> Why don't you just send them an email to their mobile phone  
>>> number. It will arrive as a simple text message. At least it does  
>>> on AT&T and nextel/sprint. Just put the 4d plugin in the folder  
>>> and a few lines of code. The following code uses the quick send  
>>> found in 4D Internetcommands.bundle plugins folder.
>>>
>>>
>>> $Host:=[Info]IP HOST
>>> $GACoor:=[Info]CoordSeraEmail
>>> $David:=[Info]OffSERAEmail
>>> $vAuthUserName:=[Info]AuthUserName
>>> $vAuthPassword:=[Info]AuthPassWord
>>> $vAuthMode:=[Info]AuthMode
>>>  `$vAuthUserName:="pseabolt"
>>>  `$vAuthPassword:="xxxxxxxx"
>>>  `$vAuthMode:=1
>>>  `$GACoor:="ga-coordination@..."
>>>  `$David:="w4wdw@..."
>>>  `$David:="aseabolt@..."
>>> $Owner:=[Form05]eMail
>>>  `$Owner:="pseabolt@..."
>>> $FromAddress:=[Info]email
>>> $Info:=[Info]Name+", "+[Info]Call+Char(13)+"Southeastern Repeater  
>>> Association, Inc."+Char(13)+[Info]Title+Char(13)+[Info]street
>>> +Char(13)+[Info]CityStZip+Char(13)+[Info]Phone+Char(13)+
>>> [Info]Phone 2+Char(13)+Char(13)
>>> $Subject:="Coordination  "+[Form05]QKey+" "+[Form05]City+" "+
>>> [Form05]State+" "+String([Form05]Output;"###0.0000")
>>> $N1:=[Form05]Email Notes+Char(13)
>>> $L1:="NOTICE OF  COORDINATION (FORM 05) Please find  
>>> attachment"+Char(13)+Char(13)
>>> $L2:="The attachment is an official notice of  
>>> coordination."+Char(13)+Char(13)
>>> $Message:=$N1+$L1+$L2+$Info
>>> C_INTEGER($vError)
>>> C_LONGINT($vSmtp_id)
>>> C_STRING(15;$vAuthUserName;$vAuthPassword)
>>> $vError:=SMTP_New ($vSmtp_id)
>>> $vError:=SMTP_Host ($vSmtp_id;$Host)
>>> $vError:=SMTP_From ($vSmtp_id;$FromAddress)
>>> $vError:=SMTP_Subject ($vSmtp_id;$Subject)
>>> $vError:=SMTP_To ($vSmtp_id;$David+","+$Owner+","+$GACoor)
>>> $vError:=SMTP_Body ($vSmtp_id;$Message))
>>> $vError:=SMTP_Attachment ($vSmtp_id;"";6)
>>> If ($vError#0)
>>> ALERT("Error: SMTP_QuickSend"+Char(13)+IT_ErrorText ($vError))
>>> End if
>>>
>>> $vError:=SMTP_Auth ($vSmtp_id;$vAuthUserName;$vAuthPassword;
>>> $vAuthMode)
>>> $vError:=SMTP_Send ($vSmtp_id)
>>> If ($vError#0)
>>> ALERT("Error: SMTP_QuickSend"+Char(13)+IT_ErrorText ($vError))
>>> End if
>>> $vError:=SMTP_Clear ($vSmtp_id)
>>> BEEP
>>> End if
>>>
>>>
>>> J. Allen (Pete) Seabolt
>>> LCS Technology
>>> 51 Mountain View Drive
>>> Dahlonega, GA 30533
>>> Home 706-864-6613
>>> Work 706-864-2169 x1
>>>
>>> On Apr 30, 2008, at 6:17 AM, john convey wrote:
>>>
>>>>
>>>>
>>>> There was a guy from Malaysia  did a session on this
>>>> at one of the summits - however, this involved plugging a mobile  
>>>> phone into the server...
>>>> It worked ok but there are obvious and not so obvious issues with  
>>>> this.
>>>>
>>>> let me know what you find out as i am interested in this as well
>>>> i have auto e-mails - you would think there could be similar  
>>>> calls to an sms gateway?
>>>>
>>>> then there is the issue of cost per sms
>>>>
>>>>
>>>> John
>>>> sci-do communications
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On 28 Apr 2008, at 11:05, Gareth Home Openworld wrote:
>>>>> Hello Everyone,
>>>>> I have written a reception database for a health clinic and I  
>>>>> want to incorporate SMS (text) reminders to patients from the  
>>>>> database.
>>>>> I'm sure this is possible, and I know other databases that do  
>>>>> this...can anyone tell me where I can get info on it...where to  
>>>>> get started ?
>>>>> Many Thanks,
>>>>> Gareth
>>>>>
>>>>>
>>>>> **********************************************************************
>>>>> 4D Basics hosted by 4D, Inc.                       http://www.4D.com/
>>>>>
>>>>> An all-new List box. More features, more power.
>>>>> Headers, footers, cell formatting and other goodies.
>>>>> See it here first! <http://www.4d.com/livedemos>
>>>>>
>>>>> To Unsubscribe:                        mailto:4DBasics-off@...
>>>>> **********************************************************************
>>>>>
>>>>>
>>>>
>>>>
>>>> **********************************************************************
>>>> 4D Basics hosted by 4D, Inc.                       http://www.4D.com/
>>>>
>>>> An all-new List box. More features, more power.
>>>> Headers, footers, cell formatting and other goodies.
>>>> See it here first! <http://www.4d.com/livedemos>
>>>>
>>>> To Unsubscribe:                        mailto:4DBasics-off@...
>>>> **********************************************************************
>>>>
>>>>
>>>
>>>
>>> **********************************************************************
>>> 4D Basics hosted by 4D, Inc.                       http://www.
>>> 4D.com/
>>>
>>> An all-new List box. More features, more power.
>>> Headers, footers, cell formatting and other goodies.
>>> See it here first! <http://www.4d.com/livedemos>
>>>
>>> To Unsubscribe:                        mailto:4DBasics-off@...
>>> **********************************************************************
>>>
>>>
>>
>>
>> **********************************************************************
>> 4D Basics hosted by 4D, Inc.                       http://www.4D.com/
>>
>> An all-new List box. More features, more power.
>> Headers, footers, cell formatting and other goodies.
>> See it here first! <http://www.4d.com/livedemos>
>>
>> To Unsubscribe:                        mailto:4DBasics-off@info.
>> 4D.com
>> **********************************************************************
>>
>>
>
>
> **********************************************************************
> 4D Basics hosted by 4D, Inc.                       http://www.4D.com/
>
> An all-new List box. More features, more power.
> Headers, footers, cell formatting and other goodies.
> See it here first! <http://www.4d.com/livedemos>
>
> To Unsubscribe:                        mailto:4DBasics-off@...
> **********************************************************************
>
>