+ Reply to Thread
Results 1 to 3 of 3

E-mail warning

  1. #1
    Forum Contributor
    Join Date
    09-03-2008
    Location
    Somerset, England
    MS-Off Ver
    XP, 2003, 2007 - depends on location
    Posts
    185

    E-mail warning

    Hi all,

    I have a macro that opens a workbook, filters certian information and e-mails it to various recipents. This all works fine, the only trouble being that for every e-mail sent a message is generated asking if I want to continue. The message is sent to 57 recipents, all containing different filtered data, so this is very time consuming. Is there any way of skipping this message?

    Any help greatly appricated.

    Thanks,
    David

  2. #2
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    try adding the following command before the command that is generating the alert & another one after it with the it DisplayAlerts = true
    Please Login or Register  to view this content.
    Remember that you may not get any messages if something goes wrong after the DisplayAlerts = False command is run
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.

  3. #3
    Forum Contributor
    Join Date
    09-03-2008
    Location
    Somerset, England
    MS-Off Ver
    XP, 2003, 2007 - depends on location
    Posts
    185
    Hey,

    Thanks for getting back to me. No joy with that one I am afraid. On further investigation the message that comes up looks like it is actully a warning from Outlook, so I am searching through outlook options now to try and find something that will allow me to do this.

    Thanks,
    David

+ Reply to Thread

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