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





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







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









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
Bypass: A program is trying to send mail using Item.Send prompt Vick Excel Discussion (Misc queries) 1 June 25th 09 03:31 AM
Send an e-mail Pa Maher Excel Discussion (Misc queries) 1 September 16th 07 04:27 PM
Send e-mail Andrea Excel Discussion (Misc queries) 3 March 25th 07 12:37 PM
using macro to send e-mail bob777 Excel Discussion (Misc queries) 1 November 2nd 05 11:16 PM
help with send mail through excell Maya Excel Worksheet Functions 0 March 16th 05 05:09 PM


All times are GMT +1. The time now is 09:40 AM.

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"