emailing multiple addresses

R

ronmic

Hello, my name is Ron
using Excel XP and outlook express.
I have a columb containig e-mail address (hyperlinks). who can I mail more
than one address at a time? each click on an address opens a new message, I'd
like to add a few to the message's "To" field (I know I can copy paste... )
I need to send the same message to more than one person
thanks- Ron
 
L

Lon

If someone tells you how to do this, using Excel alone, I'll be happy for
you . . . and will kick myself.

I just bought a program called e-Campaign that does exactly what you want to
do. It's available here http://www.lmhsoft.com/ and works exactly as
advertised. It's not free though; it's $99.95.

-Lon
 
R

Ron de Bruin

With code you can do this

See
http://www.rondebruin.nl/mail/folder3/smallmessage.htm

Use this in the example for addresses in C

If you want to mail to all E-mail addresses in column C use this code
instead of .To = "[email protected]"

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)


Change the To line to .To = strto
 
R

ronmic

first of all thanks
but, what exactly should i do? do I need to copy those command rows and
paste them somwhere? is that a macro file? in which program- Excel or outlook?
is it relevant for outlook express as well?
 
R

ronmic

I think I got what your add in does, but that is not what I ment...
all I want is to compose a mesage in outlook express to addresses that i
have selected from an existing list in an excel worksheet. not to send them
info. from the excel file itself. that file only contains the e-mail
addresses.
is there a way to do this directly with out copy-paste? say select the
addresses and than create the mail?
(when you click a single address it "knows" what to do... )
thanks again, hope there is solution, Ron
 
Top