+ Reply to Thread
Results 1 to 10 of 10

Outlook confirmation message while esnding email via VBA

  1. #1
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Outlook confirmation message while esnding email via VBA

    I have a macro that sends a worksheet via email [Outlook] to a list of recipients. Everytime an email is created, outlook pops up a confirmation window and waits for user input "yes".


    Can I set up vba or outlook to skip that step?

    I really want to create a macro with a loop to go through a list of files, execute a macro in each one, save the files and send emails to various people. This process will create about 40 emails and I don'd want the admin person to have to sit there and confirm each message going out.

    Any help would be apprecited.
    modytrane
    Last edited by modytrane; 12-05-2008 at 03:33 PM.

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326
    Your problem seems related to Outlook, not to XL.
    Better post at a forum for Outlook.

  3. #3
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Modytrane,

    It would help to if you posted your workbook. I can review all your code and give you an answer.

    Sincerely,
    Leith Ross

  4. #4
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Outlook Confirmation Msg

    Leith,
    Thanks for your response.
    Here is the file.
    The worksheet "Breakdown" is updated with other programs and the attached file sends out email to recipients and CC as identified on this file.

    The code for sending email was found on this forum. I edited it to suit my requirements.

    This file is only part of a larger process. I have another issue on this project that I am trying to get answer via seperate thread.

    Appreciate your help.
    modytrane.
    Attached Files Attached Files

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    This is a Microsoft security measure to prevent unauthorised use of Outlook by malicious programs
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  6. #6
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Microsoft Security Measure

    Roy,
    We all know why the confirmation messages are put up.
    Microsoft programs also have Password features to prevent unauthorized access to files. However, there are hundreds of solutions to break the passwords.
    Sometimes these security features get in our way, when we are trying to create productivity improvement tools.
    What I am trying to do is automate a process of sending out multiple emails.
    How does it make sense to make the admin pesron sit there and acknowledge 50 or 60 times, when she could be doing something more productive.

    I don't want to disable the security measure permanantly, just bypass it during this process [my macro], so that all the emails will go out without user action.

    Hope you understand.

    modytrane.

  7. #7
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Quote Originally Posted by modytrane View Post
    Roy,
    We all know why the confirmation messages are put up.
    Microsoft programs also have Password features to prevent unauthorized access to files. However, there are hundreds of solutions to break the passwords.
    Sometimes these security features get in our way, when we are trying to create productivity improvement tools.
    What I am trying to do is automate a process of sending out multiple emails.
    How does it make sense to make the admin pesron sit there and acknowledge 50 or 60 times, when she could be doing something more productive.

    I don't want to disable the security measure permanantly, just bypass it during this process [my macro], so that all the emails will go out without user action.

    Hope you understand.

    modytrane.
    No-one else seems to have mentioned it! Strictly speaking security issue questions should not be asked or answered on the Forum, however Ron de Bruin has information on this
    Last edited by royUK; 12-06-2008 at 11:44 AM.

  8. #8
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Outlook Confirmation message

    I just thought about a different way to look at my problem.
    What I was trying to do was to make it efficient for the admin person to send out multiple emails.

    If we don't want to bypass security or if it is too complex to implement, then maybe following can be considered.

    Can the macro create all the emails and hold them for later?
    When all emails are done [macro has gone through all the files], then one security question is asked and one user confirmation would send out all the emails.

    Thanks,
    modytrane

  9. #9
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Have you tried Ron's method?

  10. #10
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello modytane,

    Here is a macro I wrote to delay the sending of an email. You specify the data and time for the email to be sent. This can be easily adapted for your use. I can make the necessary changes if you like.
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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