Send email to mosre than one user

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve - 01 Sep 2006 09:54 GMT

How do I use SendMail when I have multiple addressees? The following
produces valid looking email addresses as you would type them in outlook but
the result is undeliverable.

...
Worksheets("emailAddresses").Activate
ActiveSheet.Range("A2").Select
While Selection.Value & "" <> ""
If MailAddr & "" = "" Then
MailAddr = Selection.Value
Else
MailAddr = MailAddr & ", " & Selection.Value
End If
Selection.Offset(1).Select
Wend

ActiveWorkbook.SendMail Recipients:=MailAddr, Subject:=wbName

--
Steve

Reply to this Message

Dave Peterson - 01 Sep 2006 13:10 GMT

Ron de Bruin shows how:
http://www.rondebruin.nl/mail/folder1/mail5.htm

> How do I use SendMail when I have multiple addressees? The following
> produces valid looking email addresses as you would type them in outlook but
[quoted text clipped - 16 lines]
> --
> Steve

Signature

Dave Peterson

Reply to this Message

Ron de Bruin - 01 Sep 2006 18:17 GMT

Hi Steve

See
http://www.rondebruin.nl/mail/tips1.htm

Signature

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

> Ron de Bruin shows how:
> http://www.rondebruin.nl/mail/folder1/mail5.htm
[quoted text clipped - 19 lines]
>> --
>> Steve

Reply to this Message

Steve - 02 Sep 2006 00:36 GMT

Ron

Thank you. In retrospect, I'm kicking myself for not thinking of array.

Steve

> Hi Steve
>
[quoted text clipped - 25 lines]
>>> --
>>> Steve

Reply to this Message