HOW TO SEND E-MAIL VIA EXCEL

[NIMISH]

Hi All,

I am quite comfortable with Excel. But, I want to take the matter to
extrem.

I have list of over six thousand documents generated by various users.
I have e-mail address as one of the field in database.

Once a batch of documents is released I want to send E-mail to
concerned users.

Is it possible with Excel? We have Outlook in our office.

I AM NOT INTERESTED USING (FILE -> SEND TO) OPTION OF Excel.

Nimish Parikh

 

[DJH]

try
Public Sub Sent()
ActiveWorkbook.SendMail Recipients:=Range("a1")
End Sub


where A1 = email address

 

[Norman Jones]

Hi Nimish,

See Ron de Bruins SendMail page for an exstensive tange of email code. See
also Ron's SendMail Addin:

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

 

[aaron.kempf]

you're ****ing crazy dude

use a database for this; Excel isn't reliable enough. And what happens
when your list of 6000 people grows to 66,000? Do you really want to
have to rebuild your app every week; or do you want something that
works?

Use ACCESS -- it can email reports a lot more effectively than Excel

 

[NIMISH]

Oh no!

I have 6000+ documents generated by hardly fifteen users. I do not mean
6000+ users.

Sorry for confusion.

Nimish