View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
adamico adamico is offline
external usenet poster
 
Posts: 1
Default .SendMail Method into Eudora


I have Eudora 6.1 and Excel 2003.

I've tried a few different .SendMail commands in an Excel macro, an
all of them are giving me a weird '400' error.

Dim myRecipient As String
myRecipient = Sheets("Sheet1").Range("A1").Value
ActiveWorkbook.SendMail Recipients:=Array(myRecipient
"), Subject:=("Assignments for ")

doesn't work

Nor does ActiveWorkbook.SendMail "

Any ideas

--
adamic
-----------------------------------------------------------------------
adamico's Profile: http://www.excelforum.com/member.php...fo&userid=3244
View this thread: http://www.excelforum.com/showthread.php?threadid=54532