![]() |
how do i call an Outlook Procedures in Excell Macro
i m using onTime method on Excell Module to copy some files from other location
to my desktop on specific time and also i want to call an Outlook procedure within excell macro to email these files but i am unable to call outlook procedures please help Please see the code below. Sub RechargeCopy() Application.OnTime Now + TimeValue("00:05:15"), "FileCopy1" Application.OnTime Now + TimeValue("00:05:30"), "FileCopy2" Dim myOlApp As Object Dim myOlApp1 As Object Set myOlApp = CreateObject("Outlook.Application") project1.Module1.RechargeSending ''error on this line it says object required please help which object should be used to call outlook procedures |
All times are GMT +1. The time now is 04:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com