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.