+ Reply to Thread
Results 1 to 9 of 9

VBA Outlook Email "Check Names"

  1. #1
    Registered User
    Join Date
    04-19-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    48

    VBA Outlook Email "Check Names"

    Hi - Really struggling to find the answers to multiple problems this afternoon, and my latest conundrum is as follows (I'd appreciate any help anyone can throw my way):

    Here is my code for generating and populating an email with data from Excel... This works fine:

    Please Login or Register  to view this content.
    What I would like to happen, is that when the "To" field of the new message is populated with the contents of "F2" (i.e. "John Smith") the "Check Names" function of Outlook is automatically triggered so that the Global Address List pops up (if multiple people called John Smith are found) etc.

    Is this possible?

    Thanks,
    PAS

  2. #2
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: VBA Outlook Email "Check Names"

    I think you may add:
    Please Login or Register  to view this content.
    inside the With block.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  3. #3
    Registered User
    Join Date
    04-19-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    48

    Re: VBA Outlook Email "Check Names"

    Thanks for the quick response.
    This seems to work when locating someone with an 'unusal' name in the GAL (after showing the "A programm is trying to access..." message 3 x, but with a more common name (i.e. my own) it doesn't give option of selecting from the various people who share my name.

    Any thoughts?

  4. #4
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: VBA Outlook Email "Check Names"

    Do you have Outlook 2003 only, or later version?

  5. #5
    Registered User
    Join Date
    04-19-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    48

    Re: VBA Outlook Email "Check Names"

    2003 I think???

  6. #6
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: VBA Outlook Email "Check Names"

    I do not think this dialog may be programmed in this version (only 2007 and later). If you send the message, the Check Names dialog does not appear?

  7. #7
    Registered User
    Join Date
    04-19-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    48

    Re: VBA Outlook Email "Check Names"

    Hi. Thanks again, yes it does - I was just hoping it could pop up at the time the name was entered. Not to worry though.
    One last question, is there any way of making it only say "A programm is trying to access..." once rather than three times or is this because of the Recipient.ResolveAll code?

  8. #8
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: VBA Outlook Email "Check Names"

    I think it is probably due to ResolveAll. May be best to remove this (because you can not invoke Check names dialog), unless you may use third-party Redemption library, which will avoid security prompts.

  9. #9
    Registered User
    Join Date
    01-11-2019
    Location
    Round Rock
    MS-Off Ver
    365
    Posts
    1

    Re: VBA Outlook Email "Check Names"

    You can use SendKeys to send the keyboard commands to activate the Check Names on the OUTLOOK bar

    SendKeys "^v"
    SendKeys "%"
    SendKeys "h"
    SendKeys "m"


    PASTE Pasting My clip board into the send line
    ALT activate the keyboard commands
    h select messages
    m check names

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 01-23-2014, 11:02 AM
  2. Check before sending an email that "new sheet has perticular data"
    By pranayttt in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-21-2013, 12:20 PM
  3. Check Names in Outlook, email created with Excel VBA
    By BlueValentine in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-04-2013, 12:27 PM
  4. MSoffice Outlook 2003 message to be saved in C dir with the file name "From" "Sent" "Sub"
    By shailendra0509 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-09-2012, 01:32 AM
  5. Outlook macro that looks at email titles for the word "error".
    By student1976 in forum Outlook Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2011, 05:03 PM

Tags for this Thread

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