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

Fiona Ellis 20 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?

Microsoft 365 and Office Development Other
Outlook Windows Classic Outlook for Windows For business
Microsoft 365 and Office Excel For business Windows
{count} votes

1 answer

Sort by: Most helpful
  1. SokiGuo-MSFT 31,526 Reputation points Microsoft External Staff
    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.



Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.