SpreadsheetWEB applications can generate and send emails. Email automation is a critical feature in data collections applications to notify users instantly that a record has been entered and/or edited.
Email feature can be accomplished by enabling email option of the Custom button of the Wizard.
To demonstrate, take a look at the sample Excel File; that will be converted to a web application with Email Integration.
Wizard in SpreadsheetWEB Add-in would be started as always. After selecting the Display Range, and the Input Cells; Worksheet Controls window will be displayed.
Custom checkbox at Worksheet Controls window should be checked and then Options should be clicked to assign the email functionality.
First, select Save button to activate Email Integration feature. The reason behind that, is first the data entered should be saved to be sent in an email. After doing so, the Auto Response Email and Notification Email options would be activated for selection. Note that Auto Response Email and Notification Email options do not differ in terms of action, but rather they are distinct names for assigning 2 different emailing options through the Wizard.
When you click on for this field, you will be prompted to select a range for the email body. The content found within this range is what will be emailed to the user when they click on the Save button in the application. To select the range, follow the same steps you use when selecting the Display Area Definition.
When you click on for this field, you will be prompted to select a cell for the email subject. The content found within this cell is what will show up as the subject of the email.
When you click on for this field, you will select the recipient's email, which can be taken directly from a cell or alternatively by using a VLOOKUP formula to select email addresses.
SpreadsheetWEB can also attach a portion of your workbook as a PDF document.
If you have defined and selected fields or pages to be exported as PDF, Attachment Field would allow user to attach PDF files to be attached to the email.
After all selections, the window will look like as follows having the first email formatted exactly the same of the Workbook whereas the second email just sent as uniform text and both attached with the PDF.