#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 89
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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?

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 89
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SendMail as pdf ogerriz Excel Programming 1 April 29th 09 10:16 AM
SendMail Add-in AccessHelp Excel Programming 3 October 24th 05 06:02 PM
SendMail upstate_steve Excel Programming 4 May 26th 05 07:11 PM
SendMail and BCC Darrin Henry Excel Programming 0 September 15th 03 10:17 PM
SendMail and BCC Darrin Henry Excel Programming 1 September 13th 03 03:18 PM


All times are GMT +1. The time now is 03:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"