How to Pass the Contents of a Cell in Excel to an Email

If you want to email someone the contents of a single Excel worksheet cell, you don't have to send the entire file as an attachment. Instead, you can use Excel's Hyperlink function to launch your email application, address the message and include the contents of one or more cells with a single mouse click. An even simpler way to pass worksheet data by email is the old-fashioned, copy and paste method.

Click an empty worksheet cell that will contain the email Hyperlink function.

... Courtesy Microsoft

Type the Hyperlink function formula to email a worksheet cell. The formula should contain at least the recipient's email address and the cell that contains the data you want to pass. In addition, you can add a subject for your message. The final Hyperlink function argument is an optional "friendly" name for the link itself. If you omit the friendly name, however, Excel will display the contents of the formula instead as a hyperlink instead. For example, if the email address is "[email protected]," your subject is "My Excel Data," your data is in cell H1 and your “friendly” name is “Send Data From Cell Above," your formula will resemble the following:

\=HYPERLINK("mailto:[email protected]?&subject=My Excel Data&body="&H1,"Send Data From Cell Above")

Click "Enter" to accept the formula.

... Courtesy Microsoft

Click the friendly name or email hyperlink to send your message using your system's default email application.

Select the Excel worksheet cell containing the data you want to send.

Press "Ctrl-C" to copy the cell's content to your clipboard.

Launch your email application, click your mouse within the body or message section and then press "Ctrl-V" to paste the worksheet cell contents into the email.