EMail Automation Send To Many Recipients Question

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

Guest

I am using office 2003, just upgraded from 2000. In 2000 the code below
worked fine for the CC in outlook. In 2003 it doesnt find the names unless i
click in the cc box in outlook and change something. I have also tried typing
in the actual email address with no success.


' add the CC recipient(s) to the message.
Set olookRecipient = .Recipients.Add("Bob Smith; Jane Doe; Rick
Recruit")
olookRecipient.Type = olCC
 
one last time sorry..I should leave this stuff to the mvps

Dim olApp As New Outlook.Application
Dim olMsg As Outlook.MailItem
Dim olRecip As Outlook.Recipient

Set olMsg = olApp.CreateItem(olMailItem)
Set olRecip = olMsg.Recipients.Add("Bob Smith; Jane Doe")
olRecip.Type = olCC
olMsg.Display
 
Ralph said:
one last time sorry..I should leave this stuff to the mvps
Click to expand...

HAH! We make mistakes too. And we like folks who aspire to become
MVPs. Please continue answering questions.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Thank you for the reply Ralph.

The problem I am having is not with the code though, I think. What his
happening is Outlook doesnt seem able to resolve the names before the message
is sent. Anything more than one name causes Outlook not to recogonize the
seperate names. Hopefully that makes sense!
 
AirgasRob said:
The problem I am having is not with the code though, I think. What his
happening is Outlook doesnt seem able to resolve the names before the message
is sent. Anything more than one name causes Outlook not to recogonize the
seperate names. Hopefully that makes sense!
Click to expand...

I'd suggest asking in an Outlook VBA or programmatic newsgroup. I'm
not familiar with that detail of minutiae with Outlook.

But I'd also have a problem with sending just first and last names off
to Outlook. How many John Smith's are there? And what if the
intended recipient is John B Smith but John Smith is the one chosen in
Outlook?

I'd switch to the exact email address.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Actually I have tried using the exact email address and I get the same
problem. I will do some more research and if i find a viable answer will be
sure to post back.
 
Back
Top