Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using MailEnvelope
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 use MailEnvelope to send out multiple e- mails. My problem is the code only works 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 .MailEnvelope to work more than once? TIA Dion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Method 'MailEnvelope' of object '_Worksheet' failed | Excel Discussion (Misc queries) |