Thread: SendMail
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default SendMail

EAddr being a variant what is the value assigned to EAddr ...

(Extract from help)
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.

Subject Optional Variant. Specifies the subject of the message. If this
argument is omitted, the document name is used.

If not an array declare the receipients variable as a string and mention the
variables

..SendMail Recipients:=strAddress, Subject:=strSubject,


If this post helps click Yes
---------------
Jacob Skaria


"thomas donino" wrote:

When I use the line
wb.SendMail "","" all works fine

why when i replace the "" with two variables
EAddr which is dimmed as variant
and Subj which is dimmed as string

does the program barf on the sendmail line?