Is it possible to send emails using VBA from the new Outlook App?

Fiona Ellis 10 Reputation points
2023-10-01T23:14:26.0566667+00:00

Hi,

A number of models I have built in Excel use VBA to automatically send out emails via the Outlook. The code works fine when using the application included with Microsoft 365, however I recently switched to the new (free) Outlook app and the code is not working anymore. The email is created perfectly fine, and there are no errors when the macro runs, but it doesn't actually send the email.

Do I have to to switch to Power Automate to send emails from the new Outlook app or is it possible to get them to send using VBA with some tweaks to the code?

Outlook
Outlook
A family of Microsoft email and calendar products.
3,086 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,520 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,565 questions
{count} votes

1 answer

Sort by: Most helpful
  1. SokiGuo-MSFT 23,871 Reputation points Microsoft Vendor
    2023-10-02T06:58:18.7333333+00:00

    Hi @Fiona Ellis

    Welcome to our forum!

    Looks like your issue is more related to Outlook development, please kindly understand that the Outlook tag here we mainly focus on general issues about Outlook desktop client. We are not very familiar with the code, the following is for reference only.


    As far as I know, currently New Outlook does not support VBA. For the latest developments in New Outlook, see: https://techcommunity.microsoft.com/t5/outlook-blog/the-new-outlook-for-windows-for-organization-admins/ba-p/3929169.

    Please kindly understand that many functions are not designed at present. For your experience, consider switching back to the classic version.

    To get this feature more quickly, I have found a post in feedback collection website, and you could vote for it. Many features of our current products are designed and upgraded based on customers’ feedback. You can also make suggestions on that website and hope Microsoft will notice this in the future. Thank you for your understanding and support.

    Hope this helps!


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.