Linking a cell with email header

[neener]

Hello:
I made up a template with Excel, a Bad Order template for emailing. I have a drop down box in the body of the message for-To who this message is going to . Once you select to who it is going to their email address shows up in the cell. My question is do you know if there is a way once I select who the Bad Order message is going to and their email address is in the cell , is there a way to have that email address link to the email header so I don't have to put the email addy in again .Then all you would have to do is click send and the template would go automatically. I don't know if this is possible to link a cell in the excel template with the send it to line in the email header.?

Any help would be greatly appreciated.

Thank you

 

[CWatts]

You could do something like this:

=HYPERLINK("mailto:"&B2&"?Subject=Bad%20Order&Body="&D1,"Send Email")

Where your email address would be in B2 and the body of the text is in D1 so you'd just click the link, it would pass everything into an email that would open in your mail program and you just pushed send.

I think you'd need to use some sort of VBA to have it auto push the send button though, but that will save you from having to put the email in again.

 

[neener]

You could do something like this:

=HYPERLINK("mailto:"&B2&"?Subject=Bad%20Order&Body="&D1,"Send Email")

Where your email address would be in B2 and the body of the text is in D1 so you'd just click the link, it would pass everything into an email that would open in your mail program and you just pushed send.

I think you'd need to use some sort of VBA to have it auto push the send button though, but that will save you from having to put the email in again.

Thanks for your response CWatts. Your formula :=HYPERLINK("mailto:"&B2&"?Subject=Bad%20Order&Body="&D1,"Send Email") would it have to be written exactly like that with after writing in the brackets("mailto:"&b2&"? What does the "?" do? and after the = sign you have Bad%20Order&Body= what does this do?
Would you know the VBA to auto push the send button through?
Thank you

 

[CWatts]

All of those symbols are part of the mailto: HTML header. The ? and stuff are part of the required.

For example, the required code for a web page is:

mailto:toperson@site.com?CC=ccperson@site.com&BCC=bccperson@site.com&Subject=Subject&Body=Body%20of%20email.

All I did as remove the address and put a cell reference in that housed an email address. I'm not that good with vba so I wouldn't know how to do it, but I did some googling and I got a bunch of search results come upl that may help.

 

[neener]

Thanks again. You mentioned that you have a bunch of search results come up that may help, do you have them handy to let me know.

Thank you.