E-Mail Subject From Cell

[Tpainguin]

Hello there.

I was wondering is there a macro I can make or any way possible so that the e-mails that I click, which are all located in Collum E, have the subject that is located in Collum O.

Thanks so much!

Sincerely,
Tpainguin

[DonkeyOte]

I think you will need to elaborate... if you're saying you have email addresses in E which when clicked generate a mail dialog then no.

You could however modify E or use a new column that combines the two pieces of info, eg:

Please Login or Register  to view this content.

assumes E2 contains (and is displaying) a mail address in the form of ronald@mcdonald.com

[Tpainguin]

Sorry about that, here's an example.


______E________________________O________________
Hello@aim.com I Subect
Bye@ aim.com I Subject


So how exactly would I make the program to do this?

Sincerely,
Tpainguin