Calling on Outlook and sending an email to multiple addresses

[TADropik]

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 = "[email protected]"
If I want to send to multiple address,
ie: stEmailAddress = "[email protected]; [email protected]"
it only sends it to '[email protected]'

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

Thanks in advance.

 

[Martin]

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.