Calling on Outlook and sending an email to multiple addresses

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 = "(e-mail address removed)"
If I want to send to multiple address,
ie: stEmailAddress = "(e-mail address removed); (e-mail address removed)"
it only sends it to '(e-mail address removed)'

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

Thanks in advance.
 
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.
 
Back
Top