PC Review


Reply
Thread Tools Rate Thread

how do i call an Outlook Procedures in Excell Macro

 
 
M Armaghan Khan
Guest
Posts: n/a
 
      9th Jul 2008
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




 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
trigger outlook macro from excell. Atishoo Microsoft Excel Programming 2 26th Oct 2009 05:15 PM
call Outlook Procedures from Excel M Armaghan Khan Microsoft Outlook VBA Programming 5 10th Jul 2008 01:16 PM
Call macro stored in Excel workbook from Outlook's macro =?Utf-8?B?R3ZhcmFt?= Microsoft Excel Programming 0 4th Oct 2006 05:47 PM
Call macro stored in Excel workbook from Outlook's macro =?Utf-8?B?R3ZhcmFt?= Microsoft Outlook VBA Programming 5 4th Oct 2006 06:26 AM
Remote Procedures Call Faye Ferrell Windows XP General 4 12th Aug 2003 04:48 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:16 AM.