+ Reply to Thread
Results 1 to 4 of 4

Trying to open a new outlook mail window

  1. #1
    Registered User
    Join Date
    07-14-2013
    Location
    Grand Rapids, Michigan
    MS-Off Ver
    Excel 2010
    Posts
    35

    Trying to open a new outlook mail window

    So, I've been trying to work out a distribution list. So far, my research has shown me how to code to be able to send a message through outlook by typing content into a spreadsheet, but I'm trying to find code that will simply open a new message window in outlook. I don't want to send it through excel as I've found to be possible b/c outlook is asking for permission to send to each recipient on the mailing list and we have a fairly large staff here, so clicking that button 20 times to allow the email to go through is more labor intensive than just verifying who's on the distribution list and sending. Anyone who can help me with this code will be my new hero. I've scoured the earth and been unable to locate what I'm looking for.

    PLEASE HELP!!!

  2. #2
    Forum Expert
    Join Date
    02-22-2013
    Location
    London, UK
    MS-Off Ver
    Office 365
    Posts
    1,218

    Re: Trying to open a new outlook mail window

    Try this:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-14-2013
    Location
    Grand Rapids, Michigan
    MS-Off Ver
    Excel 2010
    Posts
    35

    Re: Trying to open a new outlook mail window

    Thanks, I'll give this a shot today and see what happens.

  4. #4
    Registered User
    Join Date
    07-14-2013
    Location
    Grand Rapids, Michigan
    MS-Off Ver
    Excel 2010
    Posts
    35

    Re: Trying to open a new outlook mail window

    This worked just the way I needed it to. Thanks for your help Berlan.

+ 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. Need to search & Open a mail from Outlook folders
    By u767 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2013, 05:44 AM
  2. Replies: 0
    Last Post: 04-04-2013, 07:18 AM
  3. Open Outlook / send existing mail
    By koltregaskes in forum Excel General
    Replies: 1
    Last Post: 05-28-2012, 04:47 AM
  4. outlook redemtion macro cant send mail if outlook is not open ?
    By okl in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-03-2010, 07:35 AM
  5. Excel open an Outlook e-mail?
    By Lawson Wentworth in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2005, 09:40 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