ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how do i call an Outlook Procedures in Excell Macro (https://www.excelbanter.com/excel-programming/413758-how-do-i-call-outlook-procedures-excell-macro.html)

M Armaghan Khan

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