+ Reply to Thread
Results 1 to 8 of 8

Warning when sending outside local domain and/or a specific internal email.

  1. #1
    Registered User
    Join Date
    05-10-2019
    Location
    carol stream, il
    MS-Off Ver
    newest
    Posts
    15

    Warning when sending outside local domain and/or a specific internal email.

    Below is my current VBA setup to give a warning when sending to an external domain. I would like to add a way to show the same warning when sending to a specific email address.

    Please help. :-)

    *********************************************************************

    Please Login or Register  to view this content.
    Last edited by LHARISIADIS; 06-17-2019 at 11:47 AM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Warning when sending outside local domain and/or a specific internal email.

    Please take a few minutes to read the Forum Rules, and then edit your post to wrap your code with CODE tags.

    Thanks.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Warning when sending outside local domain and/or a specific internal email.

    Thank you.

    I don't do enough Outlook automation to help, but this

    Please Login or Register  to view this content.
    ... will always return 0.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Warning when sending outside local domain and/or a specific internal email.

    How about something simple-minded?

    Please Login or Register  to view this content.
    Untested.

  5. #5
    Registered User
    Join Date
    05-10-2019
    Location
    carol stream, il
    MS-Off Ver
    newest
    Posts
    15

    Re: Warning when sending outside local domain and/or a specific internal email.

    Quote Originally Posted by shg View Post
    How about something simple-minded?

    Please Login or Register  to view this content.
    Untested.
    I guess my question is how wouldi insert that into my existing code.

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Warning when sending outside local domain and/or a specific internal email.

    I dunno. Maybe ...

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    05-10-2019
    Location
    carol stream, il
    MS-Off Ver
    newest
    Posts
    15

    Re: Warning when sending outside local domain and/or a specific internal email.

    Quote Originally Posted by shg View Post
    I dunno. Maybe ...

    Please Login or Register  to view this content.
    Maybe I'm misunderstanding, but I would really like to use my existing code and just add a way to get a message for a specific email address.

  8. #8
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Warning when sending outside local domain and/or a specific internal email.

    As I said, I do very little Outlook automation, so it's probably my lack of understanding.

    Your code seems needlessly complex, but that may be due to my limited knowledge of the Outlook object model. What my code does (maybe, didn't test) is check for a specific recipient plus anyone outside your company, which was what I thought you wanted.

    Please don't quote whole posts.
    Last edited by shg; 06-19-2019 at 12:19 PM.

+ 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. [SOLVED] sending email with specific details in body of email
    By murray83 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-14-2017, 10:31 AM
  2. [SOLVED] sending email with specific range as email body vba modification
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-19-2014, 11:24 AM
  3. [SOLVED] Getting a outlook warning (2010) while sending an email through excel 2010 macro
    By Kiran Kurapati in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-26-2014, 12:21 PM
  4. Sort Email by domain and move domain group to new list
    By grandparocks in forum Excel General
    Replies: 4
    Last Post: 01-06-2013, 09:04 PM
  5. Sending email using macro - using a specific sender
    By jhuang in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-24-2011, 09:16 PM
  6. Email sending without warning message
    By joneswesley in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-24-2009, 06:07 AM
  7. [SOLVED] How to get rid of the warning msg from Outlook when sending email via VBA code in Excel
    By new.microsoft.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-14-2005, 05:06 PM

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