Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
The following articles are available for the 'Email' topic. Click the article's title (shown in bold) to see the associated article.
Automatic Text in an E-mail
When creating an e-mail address hyperlink using the Insert Hyperlink dialog box, Excel allows you to enter a subject for the message to be created by the link. If you want to also specify some body text, you need to use the techniques described in this tip.
Extracting E-mail Addresses from Hyperlinks
If you have a list of hyperlinked e-mail addresses in a worksheet, you may want to extract the addresses from those hyperlinks and store them in the next column as plain text. You can do this using either a formula or a macro, as described in this tip.
Sending Single Worksheets via E-mail
Got a single worksheet that you want to e-mail to someone, but don't want them to see the rest of the worksheets in the workbook? You can apply the techniques described in this tip to send just the information you want.