Has anyone in the Forum used this function in an application?

I am studying this now.

Just curious on how it has worked for users in any applications?

I appreciate any of your comments.

Regards,

Dave Costanzo

Quote:


Dave,

I have experimented with using the @sendmail command with a command button. In my first attempt I was sending the information to static (pre-set) e-mail address but the data sent was specific to elements in the record. My goal was to quickly notify a remote satellite office that was not directly attached to the network that a patient would be walking in shortly.

The basic flow was that a patient would call a central call center from there home or Drs Office. The rep on the phone would collect the necessary information and schedule the patient at a specific location. The rep would press the command button and based on the facility location element an e-mail was generated to that location with the patient data and all necessary information. By the time the patient could hang up the phone and drive to the location the office was already aware of there arrival with all the needed patient data.

My second attempt was to create a method of quickly notifying numerous people of a particular situation. Basically when a clinician has a serious problem they would call a central help desk. The information is taken and the call center person would enter data into a notes element. When the call center rep pressed the command button it would generate an e-mail for many different people notifying them to an immediate problem. In the time it takes to call one person and bring them up to speed many many people could be notified and speed the response time. I was even able to notify some people by fax by setting up an account with EFAX.com and adding the efax account to my @sendmail code. When the efax received the email it converted it to a fax and sent it instantaneously.

I was pretty much successful at getting all this to work. It still needs lots of clean up and I am sure numerous improvements. I was just trying to prove the concept before I got to deep into the specifics or mentioned this to anyone else.

At the moment this on the sideline because I keep breaking things in my application and I am not sure if it is my programming skills or the form subform bug. I am just working on learning and building separate features and will draw upon pieces from each when updated versions of Sesame become available.

Like I have said before, It seems there are plenty of neat features for me to learn in Sesame to keep me busy while I am waiting for the bug fixes to become available.

I Hope this was not to long of an answer to  your question. 

Bob

No.. not long of an answer at all..Thank you  for taking time to write this up and listing some usage examples.  What you have done is very impressive and helps me understand this function and capabilities further.  

It gives me some ideas on how I could apply this function within the confines my existing databases for the company I work for.

I particularly think I could apply this function on some similar tasks with regards to
notifications or confirmations. A very useful communication tool for this world of emails we live in. It seems to be very versatile.

I will attempt  to build a very basic @SendMail() and give it a  test run. I am really starting to like the ability to work in Designer while everyone else is banging away in Sesame.

Regards,   Dave Costanzo

GLK   Thanks for the tip  with Hammer. He's listening and  a response.-ya!

Hammer   you are so kind.   It is very nice of you to share this code.  Thank you for this and your support.

I will see how I can apply this.  

Regards,

Dave Costanzo

You'd need to use @Shell to launch Outlook yourself with whatever parameters it will accept. The specific command line depends on which version of Outlook or Outlook Express you have. The startup switches should be listed in the Help for Outlook.

@SendMail sends mail directly. It does not launch or use any particular external mail program.

Hello Dnolan .......  You asked:
Quote:

There are a number of Outlook items that can be created with @Shell.
The basic syntax for Outlook with command switches is:
"FullPath\Outlook.exe /c ipm.class"

The acceptable ipm classes for Outlook objects are:
Mail: ipm.note /m recipient(;s)
Calendar: ipm.appointment
Tasks: ipm.task
Contacts: ipm.contact
Journal: ipm.activity
Discussion: ipm.post
Sticky Notes: ipm.stickynote

Note that there is a space between /m and the recipient(;s)

An example of an Outlook email with two recipients:
Quote:
or
Quote:


An example of an Outlook email  using a field value as a variable for the recipient:
Quote:


An example of an Calendar Appointment:
Quote:


This command string will open up an instance of the Outlook object which you can fill in, and Save and Close. These commands can be used from any program (including versions of Q&A, and even in DOS batch files.

I believe that this will work with mulitple versions of Outlook.  Also, note that Outlook is not the same as Outlook Express which has a totally different syntax
================================
(Note - edited on 3/7/04, RMH: The examples above replace the original entries which had incorrect syntax).  See additional information on 3/7/04 posting.

Thanks for the replys!

Bob, do you know how to automatically attach a file to an outgoing email?

I want Sesame to automatically email an exported text file at the end of each day, with little, to no, entry from the user.

Thanks again!

Steve in texas

Steve,

Instead of attachment, you may receive the whole exported file as a content of e-mail and I believe this will serve the same purpose. Since it is done automatically, there is no entry from the user. You may save the content in the text file and import into your application.

Steve,

This is already there in appendix 2 - Advanced Programming examples on page 198 of programming guide namely Importing records using programming only. I believe that is what you are looking for.

I believe, you are looking for code for the sending site and for receiving side. The receiving side is simple just import the text file. The sending site will have a command button that will export file the data to ascii file, insert that file to one of the elements using @insert function and @sendmail to send the email. I have not done this but it seems like do-able. You might want to ignore the previous programming reference as simple importing file manually will serve the purpose.

Can someon help me fix this line. I need the file to have quotes, but the quotes seem to be confusing Sesame. This is a command line to startup WS_FTP, then connect to Anti-Virus FTP SIte and autodownload a file. I'm placing this in "on element entry" of a command button.

@shell =("C:\PROGRAM FILES\WS_FTP\wsftppro.exe" -s "Predefined Sites!Anti-Virus!Symantec:/public/english_us_canada/antivirus_definitions/norton
_antivirus/20040303-009-i32-1.exe" -d "local:C:\Sesame\DL\")

Note the open and closed quoates withing the () which, it appears, is needed by windows XP to find the file WS_Ftp.exe but -s should not be in quotes.

This command line works fine from the Start>Run button, but cant get it to work in Sesame.

Thanks!
Steve

One can operate Sesame over the Internet and this would not involve any transferring files. The computer at work has to be connected to Internet preferably through broadband so as to accomodate speed and being connected all the time. Advantage to this is that you can monitor it anytime, anywhere and no special export or import involved. Just a thought.

The Cow, Your suggestion sounds like it would work, but I'm still having problems. (button doesnt seem to do anything and i havent learned how to use the writeln command to give an error message ......yet.

Heres what I'm trying as per your suggestion:

var Vupdate as string

if @askuser("check for updates?", "", "") then

Vupdate = @shell("@chr(34)C:\PROGRAM FILES\WS_FTP\wsftppro.exe@chr(34) -s
     @CHR(34)Predefined Sites!Anti-Virus!Symantec:/public/english_us_canada/antivirus_definitions/norton
_antivirus/20040303-009-i32-1.exe@CHR(34) -d
     @CHR(34)local:C:\Sesame\DL\@chr(34)")


It looks like a dos box pops up for a second, but its too fast to read what its trying to do.

Thanks for the help!

Steve in Texas

Mark,

I pasted your line into sesame (and removed some excess spaces) and it still doesnt do anything.)

I'll keep working on it.

Thanks

Steve in Texas

Carl, thanks for the help. It still didnt work 100%, so I deleted the whole command line except for loading the program itself and it did load, so you technique must be the one that works. I think the problem is the quotes around the -s and -d, etc.

I took a simpler approach and just put the command line in a .bat file and had sesame call the batch file and it worked great.

I appreciate everyones help! I'll learn up on this problem more when i am more experienced with programming.

Steve in Texas

Hi Steve.....the code that I pasted was not directly from Sesame.   I did it from the command line.  Sorry about that.

2.  Here is the correct syntax to handle the long file names.
Quote:

and here is the correct syntax to handle the short file names:
Quote:


These test out OK for me using ElementExitEvent.

In reviewing your comments I found the following:
1.  There was a space missing between /m and recipient.  I have modified the original posting to reflect that change and to insert the space.

2.  I also found that if I have three or more recipients, then it does not work at all!  Curious since all recipients are in one string.  I think that the semicolon delimiter might be causing a problem with @Shell.

3.  But the multiple recipients can be handled with a batch file.  I created a batch files with the following contents:
Quote:
which  executed OK, all three recipients are in there.  Using @Shell("batchfile.bat") works OK.

I will also change the syntax on my original posting to prevent any future confusion.  Thanks for pointing out my error.

Bob, I couldn't wait til next week. 

  I copied your code into Sesame and it worked GREAT!

THANK YOU!

Steve in Texas