+ Reply to Thread
Results 1 to 9 of 9

Excel email: Outlook not recognizing email ID

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Excel 2016 Office 365 64-Bit
    Posts
    3,498

    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.
    Last edited by jomili; 04-16-2012 at 09:39 AM.

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Excel email: Outlook not recognizing email ID

    maybe add
    Please Login or Register  to view this content.
    before the .Send line

  3. #3
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Excel 2016 Office 365 64-Bit
    Posts
    3,498

    Re: Excel email: Outlook not recognizing email ID

    Joseph,
    I was very excited to get your post, because I was sure that was going to solve all my problems, but no such luck. The added code didn't seem to help at all. BTW, I noticed in my code posted above that I neglected to note that I have "Option Compare Text" at the top of the module.

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Excel email: Outlook not recognizing email ID

    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.
    Last edited by JosephP; 04-16-2012 at 09:34 AM.

  5. #5
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Excel 2016 Office 365 64-Bit
    Posts
    3,498

    Re: Excel email: Outlook not recognizing email ID

    JosephP, you're a genius (or at least your eyes are more open than mine)! The missing semi-colon was the problem. Thanks for spotting it, and for seeing what I kept looking past. I hope I can return the favor some day.

  6. #6
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Excel email: Outlook not recognizing email ID

    definitely not a genius - I commented that line out when testing at first which is why I thought the resolveall had fixed it!

  7. #7
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Excel 2016 Office 365 64-Bit
    Posts
    3,498

    Re: Excel email: Outlook not recognizing email ID

    Well, you can have your own opinion of yourself, but in my world, right now, rank goes like this:

    Jesus
    My wife
    JosephP
    My mom
    My kids
    My friends
    My boss
    Everyone else

    So, you're way up there!

  8. #8
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Excel email: Outlook not recognizing email ID

    you're a braver guy than me putting your wife at #2.
    Remember what the dormouse said
    Feed your head

  9. #9
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Excel email: Outlook not recognizing email ID

    and mom at #3!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1