Re: Multiple Recipients in SendMail Method. HELP!!!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: John Baker (Baker.JH_at_Verizon.net)
Date: 02/01/04 

Date: Sun, 01 Feb 2004 01:40:19 GMT

Dan:

Thank you very much. Its amazing how many times the good folks on this and other
Newsgroups have helped me with something that I was totally stumped on.

Regards

John Baker

"Daniel Klann" <danielklann@hotmail.com> wrote:

>Hi John,
>
>ActiveWorkbook.SendMail Array("someone@somewhere.com", "dave@hotmail.com")
>
>Should work for you.
>
>Regards,
>Dan
>-----------------------------------------
>Website : http://www.danielklann.com
>Favourites Add-in for Microsoft Excel -
>http://www.danielklann.com/excel/excel_favourites_add-in.htm
>
>"John Baker" <Baker.JH@Verizon.net> wrote in message
>news:44io105dkatnke4fgv3v8ib9ed8h90o54h@4ax.com...
>> Hi:
>>
>> I have been automatically sending an e mail from my Excel for some time,
>using the
>> following statement:
>>
>> ActiveWorkbook.SendMail recipients "baker.jh@verizon.net", _
>> etitle
>>
>> I am not attempting to add another recipient, and am having a difficult
>time. The "Help"
>> on sendmail says the following:
>>
>> "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."
>>
>> It refers to "an array of text strings", but i cant appear to set up an
>array that is
>> acceptable and will work.
>> I have tried:
>> ActiveWorkbook.SendMail "baker.jh@verizon.net", _
>> etitle
>>
>> a) ActiveWorkbook.SendMail "baker.jh@verizon.net, smith.sam@verizon.net",
>_
>> etitle
>> b) ActiveWorkbook.SendMail
>"baker.jh@verizon.net,""Smith.sam@verizon.net",_
>> etitle
>> c)ActiveWorkbook.SendMail "baker.jh@verizon.net Smith.Sam@verizon.net", _
>> etitle
>>
>> None of them work! Either the compiler does not like them or Outlook does
>not..
>>
>> Can someone tell me the right way to set this up please?
>>
>> Regards
>>
>> John Baker
>>
>

Relevant Pages

  • string to array
    ... please help me with converting string to an array: ... Ako ste ovu poruku primili gre¹kom i nije vam namijenjena, ... Distribucija, kopiranje i otvaranje privitaka je strogo zabranjeno. ... recipient and may contain legally privileged or confidential information. ...
    (alt.php)
  • RE: Using SendMail through Access - Excel Automation
    ... to separate my string of email addresses into components within the array I ... If strpos = 0 Then ... the Email field only contains the email address of one ... an error stating "Unknown recipient name found in the recipient list." ...
    (microsoft.public.excel.programming)
  • Re: One User Name in multiple domains.
    ... When you send outgoing email only Primary SMTP address is "attached" to that ... Regards, ... > I've additional recipient policy. ... >>> I've set up a new exchange system. ...
    (microsoft.public.exchange.setup)
  • Re: Reply macro...
    ... The Recipients.Add returns a Recipient object. ... Viele Gruesse / Best regards ... Michael Bauer - MVP Outlook ...
    (microsoft.public.outlook.program_vba)
  • Re: Customize Exchange error Message
    ... Regards ... > You do not have permission to send to this recipient. ... > Thanks in advance for your assistance. ...
    (microsoft.public.exchange.admin)