Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / November 2006

Tip: Looking for answers? Try searching our database.

How to email from Excel?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Nathan  Gutman - 15 Nov 2006 15:58 GMT
I have an Excel worksheet with a list of email addresses. I want to use this
list for a mass emailing using Outlook Express.
Can I do it directly from Excel i.e Outlook Express will use this list in
the To: field and I will manually add the Subject and the body of the
message.
Thanks,
Signature

Nathan Gutman

Ron de Bruin - 15 Nov 2006 16:10 GMT
Hi Nathan

Body is only possible when you use Sendkeys in OE
See this page for a example
http://www.rondebruin.nl/mail/oebody.htm
The last macro loop through a list of addresses

You can also use CDO
http://www.rondebruin.nl/cdo.htm

Signature

Regards Ron de Bruin
http://www.rondebruin.nl

"Nathan Gutman" <nzgutman@sbcglobal.net> wrote in message news:mOG6h.10572$yl4.7692@newssvr12.news.prodigy.com...

>I have an Excel worksheet with a list of email addresses. I want to use this list for a mass emailing using Outlook Express.
> Can I do it directly from Excel i.e Outlook Express will use this list in the To: field and I will manually add the Subject and
> the body of the message.
> Thanks,
Nathan  Gutman - 15 Nov 2006 21:27 GMT
Not sure that I understand. All I want is get the addresses from Excel to
Outlook Express 6. I will fill out then in OE6 the subject and the body of
the message.
Signature

Nathan Gutman

> Hi Nathan
>
[quoted text clipped - 12 lines]
>> message.
>> Thanks,
Chip Pearson - 15 Nov 2006 21:43 GMT
Outlook Express doesn't support any form of automation. There is no way,
short of using SendKeys to simulate keystrokes, to automate anything in
Outlook Express. OE just doesn't support it.

The short answer is that you can't do what you want to do, at least with
Outlook Express. However, Ron demonstrates how you can use CDO to send the
emails rather than using Outlook Express.

Signature

Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
(email address is on the web site)

> Not sure that I understand. All I want is get the addresses from Excel to
> Outlook Express 6. I will fill out then in OE6 the subject and the body of
[quoted text clipped - 15 lines]
>>> message.
>>> Thanks,
Ron de Bruin - 15 Nov 2006 21:53 GMT
I think I misunderstood the OP Chip ?
See the code example I posted

Signature

Regards Ron de Bruin
http://www.rondebruin.nl

> Outlook Express doesn't support any form of automation. There is no way, short of using SendKeys to simulate keystrokes, to
> automate anything in Outlook Express. OE just doesn't support it.
[quoted text clipped - 18 lines]
>>>> the body of the message.
>>>> Thanks,
Ron de Bruin - 15 Nov 2006 21:51 GMT
Hi Nathan

Ok, try this for OE with in column C in "Sheet1" the mail addresses
Change to your sheet and column

Sub Tester()
   Dim Recipient As String, HLink As String
   Dim Recipientcc As String, Recipientbcc As String
   Dim cell As Range
   Dim strto As String

   For Each cell In ThisWorkbook.Sheets("Sheet1") _
       .Columns("C").Cells.SpecialCells(xlCellTypeConstants)
       If cell.Value Like "?*@?*.?*" Then
           strto = strto & cell.Value & ";"
       End If
   Next
   strto = Left(strto, Len(strto) - 1)

   Recipient = strto
   Recipientcc = ""
   Recipientbcc = ""
   HLink = "mailto:" & Recipient & "?" & "cc=" & Recipientcc & "&" & "bcc=" & Recipientbcc & "&"

   ActiveWorkbook.FollowHyperlink (HLink)
End Sub

Signature

Regards Ron de Bruin
http://www.rondebruin.nl

"Nathan Gutman" <nzgutman@sbcglobal.net> wrote in message news:nDL6h.2476$yE6.328@newssvr14.news.prodigy.com...

> Not sure that I understand. All I want is get the addresses from Excel to Outlook Express 6. I will fill out then in OE6 the
> subject and the body of the message.
[quoted text clipped - 12 lines]
>>> the body of the message.
>>> Thanks,

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.