View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
M Armaghan Khan M Armaghan Khan is offline
external usenet poster
 
Posts: 1
Default 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