HOW TO SEND E-MAIL VIA EXCEL

  • Thread starter Thread starter NIMISH
  • Start date Start date
N

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
 
try
Public Sub Sent()
ActiveWorkbook.SendMail Recipients:=Range("a1")
End Sub


where A1 = email address
 
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
 
Oh no!

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

Sorry for confusion.

Nimish
 
Back
Top