ExcelBanter - Send Mail

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Send Mail (https://www.excelbanter.com/excel-programming/272333-send-mail.html)

janet

Send Mail

ActiveWorkbook.SendMail Array:=
")

When I use this command to automatically send an e-mail I
get a syntax error messge.

What is the proper way to send to more then one recipient?

Tom Ogilvy

Send Mail

Change Array:= to
","ldeluc ")

Regards,
Tom Ogilvy

"janet" wrote in message
...
ActiveWorkbook.SendMail Array:=
")

When I use this command to automatically send an e-mail I
get a syntax error messge.

What is the proper way to send to more then one recipient?

Tom Ogilvy

Send Mail

typo: change Array(( to Array(

Regards,
Tom Ogilvy

"Tom Ogilvy" wrote in message
...
Change Array:= to
","ldeluc ")

Regards,
Tom Ogilvy

"janet" wrote in message
...
ActiveWorkbook.SendMail Array:=
")

When I use this command to automatically send an e-mail I
get a syntax error messge.

What is the proper way to send to more then one recipient?

All times are GMT +1. The time now is 11:52 PM.