Excel email: Outlook not recognizing email ID

I'm not sure if this belongs in the Excel Programming area, or an Outlook group, but since it begins with Excel I'll start here.

The macro below picks up a report from the user's desktop and mails it to one of three people: Clarence, Keith, or "someone else". The someone else is where the problem lies ("Case is = 2") . The code works fine when hitting Yes to mail to Keith, or No to mail to Clarence; if I hit cancel, Excel puts up a message box asking for a valid email ID to mail to, so all that is just as designed. However, when I put a valid USERID in, even "henry.lastname@dshs.state.fl.us", which is used elsewhwere in the macro, I get a message back saying Outlook doesn't recognize one or more names. I'd appreciate some help in straightening this out.

Thanks,
John

Please Login or Register  to view this content.

oh jeez - just saw the problem. there's a semicolon missing in the cc line when you have two extra addresses instead of one

Please Login or Register  to view this content.

you're a braver guy than me putting your wife at #2.