hyperlinks and cells

[Timehri]

When I create an e-mail hyperlink to a cell, is there any way for the subject line to be filled in by the contents of another cell?
Example: cell A2 contains the e-mail address hyperlink, B2 the subject information.
When I click on A2 and have MS outlook open up, can the subject line be filled in with B2?

Thank you,
Timehri

[Tom Schreiner]

I don't know the syntax, but I would be very surprised if you could not pass information from Excel to another office program.
I'd bet a bunch that you can do it and easily. Post the code if you can?
Tom

[BabyTiger]

Hi,

You might want to try to use a line of VBA code instead of using hyperlinks. And then create a button to activate it.

Example:

Sub Send_File()
activeworkbook.sendmail recipients:="email@email.com", subject:="Email Subject"
End Sub

HTH