Martyn Pattison
New Member
I have created an Excel (365) Userform which has various email VBA routines, which for instance will a) email a report automatically when file opened or b) email a PDF report when code is run, plus others? The Excel file is located on a network drive and all routines work well. However, routines do not work for some users as they at using Outlook NEW as opposed to Outlook Classic. When reading various snippets about the way forward, I believe that this functionality will eventually not work at all - due to Microsoft’s future direction.
Simply seeking best advice on what my own best direction or options should be, so I can continue using email code with Excel 365 from a local / network drive?
Appreciate any pointers.
Many thanks
Simply seeking best advice on what my own best direction or options should be, so I can continue using email code with Excel 365 from a local / network drive?
Appreciate any pointers.
Many thanks