Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code to "Send To" Multi addresses
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:= " Help will be appreciated Murray |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code to "Send To" Multi addresses
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 Recipients:= " Help will be appreciated Murray . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code to "Send To" Multi addresses
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 Recipients:= " Help will be appreciated Murray . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 giving annoying "Send/Don't Send" error when closing | Excel Discussion (Misc queries) | |||
Signature missing when "send to" "mail recipient" | Excel Discussion (Misc queries) | |||
Can you "duplicate" "copy" listboxes and code to multiple cells? | Excel Programming | |||
Looking for VB code to test for "RING" , "BUSY" disconnects or other signals | Excel Programming | |||
Annoying "virus" alert when using code to send mail | Excel Programming |