ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How can I get my Excel macro to automatically send mail using Outl (https://www.excelbanter.com/excel-programming/409122-how-can-i-get-my-excel-macro-automatically-send-mail-using-outl.html)

Argent

How can I get my Excel macro to automatically send mail using Outl
 
My users have recently migrated to Outlook OWA. They have spreadsheets that
automatically send mail but, obviously, this does not now work as there is no
email client on their machine.

We have experimented with SendKeys, but this is not an ideal solution as we
have to program in waits between keypresses and as the time OWA takes to
respond can vary, we can't always get this right.

I would appreciate any ideas on this.


All times are GMT +1. The time now is 12:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com