how do i call an Outlook Procedures in Excell Macro

  • Thread starter M Armaghan Khan
  • Start date
M

M Armaghan Khan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Workbook reminder 0
VSTO C# add in Outlook.Appointment error 0
MsgBox; if 10-seconds, assumed 'No' Clicked 3
How do i stop a clock in excel 0
Closing down running macros at the file close 5
Timer Procedures 9
Scheduling a Macro 4
Application.OnTime - Macro Cannot Be Found - Internet Explorer 0

Top