It's a long while later, but I'm having a similar problem to Dion.
I'm not trying to send to multiple addresses, but I can't get
MailEnvelope to run more than once per Excel session. If I close
Excel and start again the command runs fine. Any thoughts on how I
can 'reset' using code or similar?

On Jul 29 2003, 9:53 am, keepitcool wrote:
Dion,

send it to an ARRAY of addresses, like:

ActiveSheet.MailEnvelope.Item.To = Array("ROsborne","SomeBodyElse")

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage:http://members.chello.nl/keepitcool



"Dion" wrote:
I am trying to useMailEnvelopeto send out multiple e-
mails. My problem is the codeonlyworks for the first e-
mail. When it gets to the second attempt at
using .MailEnvelope, I get a "Method 'MailEnvelope' of
object '_Worksheet' failed" message.
My code:
For i = 0 To 5
Sheets("Sheet1").Range("A1:F12").AutoFilter
Selection.AutoFilter Field:=6, Criteria1:=RptList(i)
ActiveSheet.MailEnvelope.Item.To = "ROsborne"
ActiveSheet.MailEnvelope.Item.Send
Next

Does anyone know why I can't get .MailEnvelopeto work
more thanonce?
TIA
Dion- Hide quoted text -

- Show quoted text -