Ask. How to connect EXCEL with mobile phone? For example, a data in my EXCEL is out of range and generates an alert. Is my mobile phone a text message?

Setting the alarm message to the mobile phone when the data is out of range in EXCEL can be realized by the following steps:

Setting alarm rules: First, set alarm rules for data out of range in EXCEL. This can be achieved by conditional formatting. Select the cell range that contains the data you want to check, and then on the Home tab, select Conditional Formatting, and then select New Rule. In the pop-up dialog box, select "Use Formula to Determine Cells to Format" and enter a conditional formula. For example, suppose your data is in the cell A 1, and the formula for setting the condition is: = a1> 1000 (assuming that 1000 is an out-of-bounds value). Then select the alarm format, such as red background color.

Setting e-mail reminders: Sending SMS reminders in EXCEL requires the help of e-mail service. Please make sure that your computer is configured with a mail client to send mail. In EXCEL, click File, then select Options, select Trust Center in the pop-up dialog box, and then click Trust Center Settings. In the Trust Center settings, select "Automatic Download", then find "External Content" on the right, click "Enable all data connections without prompting (not recommended)", and click OK.

Write VBA macro code: use VBA macro code to send email alerts to mobile phones. Press ALT+F 1 1 to open the VBA editor. In the VBA editor, click Insert, select Module, and then enter the following VBA code in the newly created module to send an email:

Setting the alarm message to the mobile phone when the data is out of range in EXCEL can be realized by the following steps:

Setting alarm rules: First, set alarm rules for data out of range in EXCEL. This can be achieved by conditional formatting. Select the cell range that contains the data you want to check, and then on the Home tab, select Conditional Formatting, and then select New Rule. In the pop-up dialog box, select "Use Formula to Determine Cells to Format" and enter a conditional formula. For example, suppose your data is in the cell A 1, and the formula for setting the condition is: = a1> 1000 (assuming that 1000 is an out-of-bounds value). Then select the alarm format, such as red background color.

Setting e-mail reminders: Sending SMS reminders in EXCEL requires the help of e-mail service. Please make sure that your computer is configured with a mail client to send mail. In EXCEL, click File, then select Options, select Trust Center in the pop-up dialog box, and then click Trust Center Settings. In the Trust Center settings, select "Automatic Download", then find "External Content" on the right, click "Enable all data connections without prompting (not recommended)", and click OK.

Write VBA macro code: use VBA macro code to send email alerts to mobile phones. Press ALT+F 1 1 to open the VBA editor. In the VBA editor, click Insert, select Module, and then enter the following VBA code in the newly created module to send an email:

Vbcopycode sub sendalertemail () dim outlook app as object

Dim OutlookMail messages as objects.

Displays the message body as a string.

set Outlook app = CreateObject(" Outlook。 Apply ") Set OutlookMail = OutlookApp. CreateItem(0)

MailBody = "The data is out of range, please handle it in time!"

Use OutlookMail

. To = "Your mobile phone number @ operator SMS gateway address", please refer to the SMS gateway address of the relevant operator to obtain the correct email address.

. Subject = "Data out of range alarm"

. Body = message body

. If you want to send mail directly, you can use. Send.

End with ...

Set OutlookMail = none.

Set OutlookApp = NothingEnd Sub

Trigger e-mail: In conditional format, besides setting the red background color, we can also select "New Rule" in the "New Rule" dialog box, and then select "Macro". Select the SendAlertEmail macro you just wrote from the macro list that pops up. In this way, when the data is out of range, EXCEL will automatically execute the macro and send an alarm email to the mobile phone.

It should be noted that to successfully send SMS to your mobile phone, you need to find the SMS gateway address of your operator and replace your mobile phone number with the correct email address. In addition, your computer needs to be connected to the Internet to send e-mail successfully.