PDA

View Full Version : VBA code for automatic open sheet & Update & send mail



amartakale
07-09-2018, 12:12 AM
Dear All

I need VBA code for automatic open target sheet at given time (it still open 2-3 minute for data updation) & then run macro in this sheet automatically as paste special value 5 sheet & then send mail sheet automatically.

Can We con do this all through in excel by VBA code.

Thanks
Amar

Logit
07-09-2018, 07:05 PM
Yes.

Here is the best resource for VBA email : https://www.rondebruin.nl/win/s1/outlook/mail.htm

amartakale
07-10-2018, 12:39 AM
Yes.

Here is the best resource for VBA email : https://www.rondebruin.nl/win/s1/outlook/mail.htm

amartakale
07-10-2018, 12:40 AM
Thank sir,I will check this