Is there a way to insert an email address in Excel so when someone clicks it will activate their email programn?
Is there a way to insert an email address in Excel so when someone clicks it will activate their email programn?
Last edited by C Holmes; 01-20-2010 at 04:14 PM.
An email address entered into a cell will normally automatically resolve to a hyperlink. When clicked this will start a new mail message but will probably only send if the mail program is open, if not it will send the message next time you start the mail program.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks