Prev: Excel English to French and French to English
Next: Vlookup with difference between two data
From: Nanou qwist Nanou on 9 Apr 2010 00:24
How do I send an email from Excell?l
From: Harald Staff on 9 Apr 2010 02:43
http://www.rondebruin.nl/sendmail.htm


"Nanou qwist" <Nanou qwist(a)discussions.microsoft.com> wrote in message
news:34FFE908-50C6-4BB1-85CE-FE8F52BBB7EF(a)microsoft.com...
> How do I send an email from Excell?l

From: JT1977 on 9 Apr 2010 08:05
I'm assuming you're asking how to do this using macro code rather than just
manually via point and click.

Below is some code I used to generate and send a e-mail using a macro.

' Show the envelope on the ActiveWorkbook populate the specified
fields and send e-mail
ActiveWorkbook.EnvelopeVisible = True
With ActiveSheet.MailEnvelope 'Opens a blank MS Outlook e-mail letter
.Introduction = Range("U14") 'Cell U14 on the worksheet contains
the text that will go in the body of the note.
.Item.To = Range("U15") 'Cell U15 on the worksheet contains the
addresses of those to be included on the mailing.

.Item.Subject = Range("U16") 'Cell U16 on the worksheet contains
the text for the subject line of the note.

.Item.Send 'Sends the note
End With

"Nanou qwist" wrote:

> How do I send an email from Excell?l
 | 
Pages: 1
Prev: Excel English to French and French to English
Next: Vlookup with difference between two data