Make all E-Mails have the same subject line.

Hello.

I'm a bit new to Excel, and still learning things.


Here's the situation:

I have to send out a good 500 E-Mails, and each e-mail address is a hyperlink in Colum E. Each row has a different E-Mail, but I want them to all have the same Subject line. I tried highlighting the entire Colum and making the subject line "hello", and while it did make the subject line "hello" for each e-mail, I lost all of the individual e-mail addresses! Now whichever e-mail I clicked, it would display the correct subject line but the e-mail addresses of the first e-mail address only. I could use a macro, or a tip, or anything. I don't want Excel to actually send the e-mail though, as I need to enter text in the body of the e-mail. Thank you so much!

Sincerely,
Tpainguin

I thank you very much, but sadly this does not allow me to configure e-mails, only actual letters. Thanks so much though!