mail button with dynamic content/ and hrefs

[goldiloxx]

Hello all,

I hope someone can help me with these two questions I have.

The first one is: i found this macro on the mr Excel site to make a submit to email button, and it worked like a charm
here it is : Sub SendIt()
Application.Dialogs(xlDialogSendMail).Show arg1:="whatever@gmail.com", _
arg2:="e-mail subject"
End Sub

However, I would like the subject of the e-mail to be the content of the first cell the person fills in. Their name. It's on the first worksheet. Is this possible, and how do i code this?


The second question has to do with hrefs. I'd like to add hrefs to the cell with a question. but only have the href show after the adjacent field is filled in with an answer. they are yes and no questions. Is this possible, and how do i code this.

Thank you in advance for any help you can give with either of these questions.

 

[BrianExcel]

Check out Ron DeBruin's site. He gives example workbooks and code for exactly what you're looking for.

http://www.rondebruin.nl/sendmail.htm

 

[goldiloxx]

thank you for your help, but that is not what I was looking for. I have the code to send the workbook as mail. I'll try to explain better what I mean. The workbook I made will be sent to hundreds of people, who will fill the book and send it back. now for ease of reference i would like the subject of the mail to automattically show the name they fill in in one of the cells on the first page. However, the code I found sets argument 2, which will be the mail subject as a static text defined by me.

My question therefor is, can I replace that static text with code to refer to that cell, and what would that code be?

 

[goldiloxx]

i tried the &worksheet cell name code but that didnt work so I hope someone can help me

 

[BrianExcel]

Would you be able to post the workbook somewhere like box.net & provide the link?

It sounds like what you are trying to do, is a user will complete a cell (with their name) and then you want the value of that cell to be the subject line?

part of this depends on what mail code you are using. Certain ones allow dynamic subject lines & some don't.