EMail Automation Send To Many Recipients Question

[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

 

[Guest]

..Recipients.CC="Bob Smith; Jane Doe; Rick Recruit"

 

[Guest]

oops had that wrong..

with olMsg
.cc=("Bob Smith; Jane Doe; Rick Recruit"
end with

sorry

 

[Guest]

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

 

[Tony Toews [MVP]]

one last time sorry..I should leave this stuff to the mvps

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/

 

[Guest]

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!

 

[Tony Toews [MVP]]

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!

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/

 

[Guest]

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.