sending a workbook by email to multiple recipients
 

Paul, try:

.sendmail array("name1","name2"),"Subj"

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"PAul Maskens" wrote:

I'm having a minor problem with an Excel automation from VFP7.

oXL.ActiveWorkbook.SendMail("Robert Jackson","Test: Please Ignore")

Now it should be possible to dispatch to multiple people but it is
eluding me. Any pertinent suggestions would be gratefully appreciated.

sending a workbook by email to multiple recipients
 

Thanks - but ...

This is via automation from VFP (Visual Foxpro) and passing an array seems
not to be possible.
Do you know what kind of array it expects?

sending a workbook by email to multiple recipients
 

this is what help says..

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.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"PAul Maskens" wrote:

Thanks - but ...

This is via automation from VFP (Visual Foxpro) and passing an array
seems not to be possible.
Do you know what kind of array it expects?

sending a workbook by email to multiple recipients
 

Thanks, now to work out how to pass such an array.

"keepitcool" wrote in message
...
this is what help says..

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.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"PAul Maskens" wrote:

Thanks - but ...

This is via automation from VFP (Visual Foxpro) and passing an array
seems not to be possible.
Do you know what kind of array it expects?

sending a workbook by email to multiple recipients
 

Hi Paul

With all E-mail addresses in a range

Dim MyArr As Variant
MyArr = Sheets("mysheet").Range("c1:c10")
ActiveWorkbook.SendMail MyArr, _
"This is the Subject line"


Post back if it is not working

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"PAul Maskens" wrote in message ...
Thanks, now to work out how to pass such an array.

"keepitcool" wrote in message
...
this is what help says..

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.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"PAul Maskens" wrote:

Thanks - but ...

This is via automation from VFP (Visual Foxpro) and passing an array
seems not to be possible.
Do you know what kind of array it expects?

sending a workbook by email to multiple recipients
 

Try:
DIMENSION rcpts(10) AS String

For lots of explanation on passing arrays in VFP
see language reference on DIMENSION and COMARRAY
i'm an excel man myself.. gotta find yourself a fox

Have Fun...


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"PAul Maskens" wrote:

Thanks, now to work out how to pass such an array.

"keepitcool" wrote in message
...
this is what help says..

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.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"PAul Maskens" wrote:

Thanks - but ...

This is via automation from VFP (Visual Foxpro) and passing an
array seems not to be possible.
Do you know what kind of array it expects?

sending a workbook by email to multiple recipients
 

Yesh, I was expecting it to be COMARRAY, just never used it before :)
I like Ron de Bruin's solution better - makes it not a VFP problem!

"keepitcool" wrote in message
...

Try:
DIMENSION rcpts(10) AS String

For lots of explanation on passing arrays in VFP
see language reference on DIMENSION and COMARRAY
i'm an excel man myself.. gotta find yourself a fox

Have Fun...


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"PAul Maskens" wrote:

Thanks, now to work out how to pass such an array.

"keepitcool" wrote in message
...
this is what help says..

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.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"PAul Maskens" wrote:

Thanks - but ...

This is via automation from VFP (Visual Foxpro) and passing an
array seems not to be possible.
Do you know what kind of array it expects?