Results 1 to 2 of 2

Macro doesn't automatically resolve All email address when email is drafted

Threaded View

sonny.thind Macro doesn't automatically... 07-20-2011, 03:11 PM
sonny.thind Re: Macro doesn't... 08-23-2011, 12:58 PM
  1. #1
    Forum Contributor
    Join Date
    07-04-2011
    Location
    London, Ontario
    MS-Off Ver
    Excel 365
    Posts
    119

    Smile Macro doesn't automatically resolve All email address when email is drafted

    Ok So I found a Macro to send the emails --however I still have to click the 'Check Name' tab in outlook to validate the addresses from my exchange server.
    how do I add this to the macro to do it for me?
    here is the code..
    Sub Mail()
        Dim OutlookApp As Object
        Dim Mess As Object, Recip
        Recip = Range("E8")
        Set OutlookApp = CreateObject("Outlook.Application")
        Set Mess = OutlookApp.CreateItem(olMailItem)
        With Mess
            .Subject = "Subject"
            .Body = "Body"
            .To = Recip
            .Display
            End With
    End Sub


    TRIED to use Resovle ALL but that doesnt work.. Help!
    Attached Files Attached Files
    Last edited by romperstomper; 07-26-2011 at 10:19 AM. Reason: adding code tags!

Thread Information

Users Browsing this Thread

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

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