VB code to "Send To" Multi addresses

  • Thread starter Thread starter muzzas news
  • Start date Start date
M

muzzas news

I have a line of VB code to send a spreadsheet by e-mail to a recipient. I
have tried modifying this to allow me to send to more than one recipient but
can't get it to work.
Currently I have:
ActiveWorkbook.SendMail Recipients:= "(e-mail address removed)"

Help will be appreciated

Murray
 
hi
see this site. there are 2 good suggestions here for you.

http://www.rondebruin.nl/sendmail.htm
-----Original Message-----
I have a line of VB code to send a spreadsheet by e-mail to a recipient. I
have tried modifying this to allow me to send to more than one recipient but
can't get it to work.
Currently I have:
ActiveWorkbook.SendMail
Click to expand...
Recipients:= "(e-mail address removed)"
 
Hi Murray,

see the Excel help for some help ;o)

cited:

"Recipients: Required Variant. Specifies the name of the
recipient as text, or as an array of text strings if there
are multiple recipients. At least one recipient must be
specified, and all recipients are added as To recipients."

So simply connect a range with the recipients as follows:

ActiveWorkbook.SendMail Recipients:=Range("A1", "A3")

Or you first read your recipients in an array and conntect
this with the recipients... whatever ;o)


Best

Markus

-----Original Message-----
I have a line of VB code to send a spreadsheet by e-mail to a recipient. I
have tried modifying this to allow me to send to more than one recipient but
can't get it to work.
Currently I have:
ActiveWorkbook.SendMail
Click to expand...
Recipients:= "(e-mail address removed)"
 
Back
Top