Results 1 to 9 of 9
  1. #1
    d9pierce1 is offline Expert
    Windows 10 Access 2019
    Join Date
    Jan 2012
    Location
    Oklahoma
    Posts
    828

    New outlook and sending reports


    Hi all,
    I gues we are all forced into this new outlook and now my email code dont work?
    It doesnt send my email? Is there new code available for this new outlook.
    I have been using the following code for a long time and no issues till I got the new outlook?
    Code:
    Private Sub cmdEmailReport_Click()
    On Error Resume Next
        Call CmdReport_Click
        DoCmd.SendObject acReport
        
    DoCmd.Close
    End Sub
    Thanks
    Dave

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,550
    If you can go back to normal outlook, do so, else you could use CDO.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows 11 Access 2021
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    d9pierce1 is offline Expert
    Windows 10 Access 2019
    Join Date
    Jan 2012
    Location
    Oklahoma
    Posts
    828
    Thanks all,
    I downloaded the classic and it works good again! Really is a poor change on MS if you ask me.
    I guess it is what it is...
    Will mark as solved
    Thanks again,
    Dave

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows 11 Access 2021
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Beware, could die on you again. I just tried my code and it opens an email object with all the info completed but Send will not work. Email just dies, no error and doesn't appear in my inbox (I send to myself for testing - swear it worked a few weeks ago).

    MS is pushing for Office 365. I think if you do subscribe, can automate Outlook there.

    EDIT: gets more bizarre. Just installed Classic on another laptop and test emails I sent 5/28 are showing in Inbox, not the ones I tried today - they are in Outbox. Not showing other emails in my Inbox. Restarted Outlook Classic and it says I am running "unlicensed" version and keeps prompting me to subscribe to 365. This just gets more annoying. The download page says "A Microsoft 365 Personal or Family subscription is required to use this app with personal accounts." So I am at another deadend.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,550
    Perhaps review this link https://www.google.com/search?q=stop...hrome&ie=UTF-8

    TBH I have no idea what MS think they are doing. When you think of all the users using automation, why would you want to alienate them all?
    I think I have used the HideNewOutlookToggle, even though I am the only one using my PCs. Just in case MS takes that as me wanting it.

    This is a tidy video.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  7. #7
    June7's Avatar
    June7 is online now VIP
    Windows 11 Access 2021
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Latest info: on machine which has Office 2021 Pro and Outlook Classic, using .Send in VBA does send email but if I use .Display then SEND from Outlook, it only saves to Outbox. Again, would swear it used to send. Thought I had those registry edits in place but just checked and they are not. However, the toggle is not showing when I open Outlook Classic, it does when I open just Outlook. I bought this Office 2021 Pro last year from a third party.

    Now to see if I can fix the other laptop still running Office 2010.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  8. #8
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,550
    I am sure .Send just put it in the Outbox.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  9. #9
    June7's Avatar
    June7 is online now VIP
    Windows 11 Access 2021
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    No, with .Send email shows up in Inbox.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 03-27-2022, 03:14 PM
  2. Replies: 7
    Last Post: 12-12-2018, 03:06 PM
  3. Combining 'sending mail' with 'sending a report'.
    By Mattbro in forum Programming
    Replies: 2
    Last Post: 11-25-2012, 07:42 AM
  4. Replies: 1
    Last Post: 03-09-2006, 01:50 PM
  5. Sending email via Outlook (and Exchange2003) from Access2003
    By Larry Elfenbein in forum Programming
    Replies: 0
    Last Post: 11-15-2005, 09:03 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums