Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2008
    Posts
    78

    Unanswered: Turn of Outlook Send Confirmation from Access

    I have some Macros that create queries and email them to users in the form of spreadsheets. That works OK other than I have to click yes for each email that gets sent out. I don't know if Access can answer "Yes" to Outlook's confirmation dialog. Is there a way? I might want a user to start running the macro but I don't want them to have to answer yes all the time they run it.

    "Send 11:00 AM Email Report" Macro {description}



    Action: SendObject
    Object Type: Query
    Object Name: (Name of a working, existing query )
    Output Format: Microsoft Excel 97-2003 (*.xls)
    To: {Valid Distribution List}

    The rest of the settings are not important


    When this runs, it stops and asks permission to send the email. I have other macros that send up to 5 emails, needing me to say yes 5 times.

    Can it send w/out confirmation? Do I have to move to direct SMTP and bypass Outlook or something?

    Thanks!

  2. #2
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    You can get around this by using the Outlook object to create and send your email rather than SendObject. Use .Display to display the email and send keys to 'push' the Send button on the displayed email.

    Make sure that spell check is turned of and all email addresses are valid. If another dialog box comes up, it will throw off the routine.

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Do I have to move to direct SMTP and bypass Outlook or something?
    That's what I do.

    http://www.dbforums.com/showthread.php?t=1626609
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Aug 2008
    Posts
    78
    Thanks for the info, I think I'll go SMTP.

  5. #5
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,420
    Provided Answers: 7
    There is a program call "express CLick yes" that click the yes for you
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •