SendMail

  • Thread starter Thread starter thomas donino
  • Start date Start date
T

thomas donino

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?
 
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,

I sorted out that issue, I wasn't populating the variable properly so it was
blank.
I am now stuck on how to get text for the body of the email message into the
body of the email. The sendmail command only has address and subject line as
delimeters

tom
 
Back
Top