ipushpull lets you add links to your pages that launch your email, phone and SMS messaging apps with the email addresses or phone numbers you specify. You could use this feature to e.g. create an interactive client directory page for your staff or to let your customers contact you directly from the pages they are viewing.

Here's the syntax:

=ipushExternalLink(URL, displayText)

Examples:

It should look something like this (note that we've used some special symbols in the displayText to make the links more attractive):

When you push this range to ipushpull (using manual or automatic pushing or the ipush(...) function) the result will look like this:

Clicking or touching the email link will launch your email program and create an new email with the address pre-populated as support@ipushpull.com.

If your device supports telephone calls, clicking or touching the phone link will ask you if you want to call the specified number.

If your device supports SMS messaging, clicking or touching the SMS link will ask you if you want to send an SMS to the specified number.

You can add as many links to your pages as you like.

Instead of explicitly defining the URL and displayText parameters in the function call you can use cell references:

=ipushExternalLink(A1, B1)

or Excel formulas:

=ipushExternalLink("tel:+123456789", SUM(E2:E10))

Other link types

The ipushPull Excel add-in lets you add a variety of other kinds of links to enrich your pages:

• ipushpull Page links

  • add links to other ipushpull pages to create live web sites. For example: create a summary page with links from each row to a suitable detail page

• Web Page Links

  • add links to external websites

In 'Content by label' macros expand options and add sort by 'title' and un-check the label and space options