2. I do not know how to
> send
> > > mail if you have more than one emial addrees. But I think this may help
> you.
> >
> > > Regards
> > > Hiren
> >
> > > -Original Message-
> > > From: excel-macros@googlegroups.com [mailto:
&g
l").Range("A2").Value then
> > mail will be sent to e-mail ID mention in cell A2. I do not know how to send
> > mail if you have more than one emial addrees. But I think this may help you.
>
> > Regards
> > Hiren
>
> > -Original Message-
>
w to send
> > mail if you have more than one emial addrees. But I think this may help you.
>
> > Regards
> > Hiren
>
> > -Original Message-
> > From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
> > On Behalf Of JMac
> > Se
to:excel-mac...@googlegroups.com]
> On Behalf Of JMac
> Sent: Tuesday, December 15, 2009 8:21 PM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Send Email from Excel to Multiple Addresses
>
> I have a excel 2003 file that contains the following code to send a
> email me
ddrees. But I think this may help you.
Regards
Hiren
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of JMac
Sent: Tuesday, December 15, 2009 8:21 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Send Email from Excel to Mult
t;Test"
.Body = "Testing 1,2,3"
.To = Sheets("Email").Cells(A, 1)
.Send
End With
A = A + 1
Loop
This is just a guess, and untested.
Regards - Dave.
> Date: Tue, 15 Dec 2009 06:51:23 -0800
> Subject: $$Excel-Macros$$ Send Email from Excel to Multiple Addre
I have a excel 2003 file that contains the following code to send a
email message to several people.
Sub SendMail()
Dim OL As Object, MailSendItem As Object
Set OL = CreateObject("Outlook.Application")
Set MailSendItem = OL.CreateItem(olMailItem)
With MailSendItem
.Subject = "Test"
.Body = "Tes
