First a word of Thanks!

[Yadlik]

First I wanted to thank Iain Lewis for his tremendous (off board) support in solving my last post!
And now for something new:
Is there a way to have cell contents be included in an automatic e-mail? For instance: "This auto-generated e-mail is being sent to inform you that the [CUSTOMER]... Where [CUSTOMER] is from the sheet and variable?

[Jack in the UK]

do you have millions to email if so i have a xls sheet that will allow data entry ie subject and text in the text field, NO ATTACHMENTS all to any email address

it a bulk emailer, half the email punchers in my company use it, i nabbed it from some site SORRY to the programmer i have had it donkeys and only used now, so i cant credit the guy, i have mega edited it...

I tested on LAn 200 per minute... bleeds emails ...

any good!

does not like hotmail or yahoo and these type of email clients thou:

[Yadlik]

Not exactly what I am looking for, but thanks for the thought! I have a sheet that when you change a cell to 3 or 9 it sends the sheet to an e-mail address the problem arises thiough that I amy get an e-mail but I don't know which cell in the designated column changed. The [CUSTOMER] would make it so I could immediately identify what changed. Clear as mudd?

[Jack in the UK]

Are these one offs?

ANd is it the same range>

as attachment or as body text?

your need VBA for this..

[Yadlik]

That is what I thought.... I just don't know how to do it.

[Nimrod]

Here's and article on sending Personalized email from excel ... maybe it will help
http://<br /> <a href="http://www.j....htm</a><br />

Here's also a little piece of code I use for an email demo

Sub Email()

EmailAddr = InputBox("Please Enter Recipient's Email Address", "Destination Address")
ActiveWorkbook.SendMail Recipients:=EmailAddr
End Sub

[ This Message was edited by: Nimrod on 2002-05-14 13:22 ]