e-mail hpyerlink in excel

J

jenniferd

I received an excel document with several e-mail addresses that aren't live
and I need to be able to click on the e-mail address and have it hyperlink.
Can someone walk me through the steps, please? I have changed the column to
text and tried using the hyperlink key. Do I need some sort of code or
formula to activate the link? I have 1000's of e-mails to send out and I
don't have time to "cut and paste" every e-mail address.
Thanks in advance to anyone who can help me!
Jen
 
B

Beth Melton

jenniferd said:
I received an excel document with several e-mail addresses that aren't
live
and I need to be able to click on the e-mail address and have it
hyperlink.
Can someone walk me through the steps, please? I have changed the column
to
text and tried using the hyperlink key. Do I need some sort of code or
formula to activate the link? I have 1000's of e-mails to send out and I
don't have time to "cut and paste" every e-mail address.
Thanks in advance to anyone who can help me!
Jen

If you have a lot of emails to send then use the Excel workbook as the data
source for a mail merge in Word. If your main document for mail merge is set
to Email Messages then an individual email will be sent to each email
address in your data source.

If you don't know how to use mail merge then here is an article that should
help you out.
http://office.microsoft.com/en-us/word/HP051872571033.aspx

If you are using Word 2007 I can't seem to find a tutorial right now but you
should be able to adapt the article referenced above to Word 2007. All of
the commands noted in the article (for the mail merge wizard) can be found
on the Mailings tab in Word 2007. If you prefer to use the Mail Merge Wizard
then on the Mailings tab, click Start Mail Merge, and then click Step by
step mail merge wizard.
--
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton
What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

Guides for the Office 2007 Interface:
http://office.microsoft.com/en-us/training/HA102295841033.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top