Email sheet and cell reference

[sureshprabhu]

Hi Everybody!
can anybody help me to send mail with active work book!
thanks in advance

[XLGibbs]

Hi Everybody!
can anybody help me to send mail with active work book!
thanks in advance

You might find the code in this: http://vbaexpress.com/kb/getarticle.php?kb_id=880

usefull.

You can also do a search for SendMail in this forum and find multiple ideas on sending mail.

[Ken Puls]

Or, if that's not enough, you could visit Ron's site. He's got several examples (http://www.rondebruin.nl/sendmail.htm) of sending mail from Excel.

HTH,

[sureshprabhu]

Thankyou very much Gibbs!
Its working!

[sureshprabhu]

Hi!
How can I give reference of one cell in another sheet?
Thanks in advance!

[XLGibbs]

split out of solved topic for better visibility to new poster.

[Ken Puls]

Pete, was that advice, or did you do it? Maybe a link? ;)