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.

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?

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?

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?

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?

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?

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?