Calling on Outlook and sending an email to multiple addresses

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TADropik - 27 Feb 2006 22:26 GMT

In my access module I call on Outlook and automatically send emails.
Basically my code reads as follows to set up the CC address:

Dim stEmailAddress As STring
Set objOutlookRecip = .Recipients.Add(stEmailAddress)
objOutlookRecip.Type = olCC

Everything works great as long as stEmailAddress contains only 1 email address
ie: stEmailAddress = "tom@Address.com"
If I want to send to multiple address,
ie: stEmailAddress = "tom@Address.com; ted@company.com"
it only sends it to 'ted@company.com'

Is it possible to send to multiple addresses?
Is is a matter of syntax?

Thanks in advance.

Reply to this Message

Martin - 28 Feb 2006 14:01 GMT

I don't know why your code isn't working but I've always had problems
including multiple addresses explicitly divided by semicolons. An
alternative approach which seems more reliable is to loop, using the
Recipients.Add line repeatedly to add multiple individual addresses without
using the semicolon.

> In my access module I call on Outlook and automatically send emails.
> Basically my code reads as follows to set up the CC address:
[quoted text clipped - 13 lines]
>
> Thanks in advance.

Reply to this Message