 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008Convert to email address
I copied and pasted email address's into a column but the address's are not active. I can't click on them to send email. How can I format the column for email?? Thanks  Signature---------------------------------------------------- This mailbox protected from unsolicited email by Spam Alarm from Dignity Software http://www.dignitysoftware.com =HYPERLINK(A1) SignatureKind regards, Niek Otten Microsoft MVP - Excel |I copied and pasted email address's into a column but the address's are not | active. I can't click on them to send email. How can I format the column for | email?? | | Thanks Also... Tools (menu) | Auto Correct Options | AutoFormat as you Type (tab)... Checkmark "Internet and Network Paths..." ( I hope all those emails you send are solicited) SignatureJim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Doug" <doug57@www.com> wrote in message I copied and pasted email address's into a column but the address's are not active. I can't click on them to send email. How can I format the column for email?? Thanks -- ---------------------------------------------------- This mailbox protected from unsolicited email by Spam Alarm from Dignity Software http://www.dignitysoftware.com Actually I have a youth football league and I am setting up player rosters with contact information. Thanks Signature---------------------------------------------------- This mailbox protected from unsolicited email by Spam Alarm from Dignity Software http://www.dignitysoftware.com > > Also... > Tools (menu) | Auto Correct Options | AutoFormat as you Type (tab)... > Checkmark "Internet and Network Paths..." > ( I hope all those emails you send are solicited) Sub MakeHyperlinks() 'David McRitchie Dim cell As Range For Each cell In Intersect(Selection, _ Selection.SpecialCells(xlConstants, xlTextValues)) With Worksheets(1) .Hyperlinks.Add anchor:=cell, _ Address:=cell.Value, _ ScreenTip:=cell.Value, _ TextToDisplay:=cell.Value End With Next cell End Sub Gord Dibben MS Excel MVP >I copied and pasted email address's into a column but the address's are not >active. I can't click on them to send email. How can I format the column for >email?? > >Thanks
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.