Dear sue

thanks for your reply please see below i have mad a program in excel to copy
some file on my desktop and i want to email it to my ID but problem is i m
unable to run outlook procedure within excel macro i have created an object
of Outlook.application but i still don't understand how to call procedure of
Outlook
please see below code on the last line the error occurs it said object
required please tell me what object should i use it will be very helpful .



Sub Copy()


Application.OnTime Now + TimeValue("00:00:15"), "FileCopy1"

Application.OnTime Now + TimeValue("00:00: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




"Sue Mosher [MVP-Outlook]" wrote:

Before you can call any Outlook methods, you must instantiate an
Outlook.Application object. See
http://www.outlookcode.com/codedetail.aspx?id=83 for a code sample.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx



"M Armaghan Khan" wrote:

i am stuck in calling Outlook procedures in Excel macro how do i call and
which object should i choose to call Outlook Procedures Please Help!!!.