This article walks you through the process of setting up and triggering email alerts from your MS Excel spreadsheet using ipushpull. You trigger alerts by updating a special page in your folder called MyAlertsPage. It's a good idea to understand the basics of pushing data to ipushpull using the ipush(...) function before trying this - see this article for details.
...
Make sure that this name is entered in cell C5 (coloured orange).
5. Enter your email address
Next, enter your email address in cell I4 (colored green). This has to be the email address you used when you signed up with ipushpull, or the email address of someone you have invited to your folder. You cannot use any other email addresses here.
...
The value in cell F4 (coloured red) is used to trigger the email. If this value changes from FALSE to TRUE, an email will be sent containing the message in cell H4 (coloured blue) to the email address in cell I4 (coloured green).
Try it:
Change the value in F4 to FALSE. Wait a few seconds.
Change the value in F4 to TRUE.
...
| Filter by label (Content by label) | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
...