Re^2: Sending email from excel by one click

Thanks a lot Martell.. for detail explanation.. :)

i want to with first option.. as user will have control over the email which he is sending( i.e he can add other users or extend body..etc )

Now my Question.. can we have variables in the body (i.e using Hyper LInk),as i want to put cell values in the body

Thanks

Comment on Re^2: Sending email from excel by one click

Replies are listed 'Best First'.
Re^3: Sending email from excel by one click by martell (Hermit) on May 25, 2011 at 20:45 UTC
Normally you can. Simply use the concatenation function '&' in excel. For example: `=(Hyperlink("Mailto:me@home.com?Subject=" & A3 & "&Body=" & A2 & "Kind + regards"))` [download] This will put the content of cell A3 in the subject and A2 into the body. Search in google on: 'excel mailto body' for other examples. Kind Regards Martell	[reply] [d/l]