Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SendMail
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
SendMail
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 "Jacob Skaria" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SendMail as pdf | Excel Programming | |||
SendMail Add-in | Excel Programming | |||
SendMail | Excel Programming | |||
SendMail and BCC | Excel Programming | |||
SendMail and BCC | Excel Programming |