Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have written a set of macros to Email certain sheets following Ron
DeBruin's excellent help articles and by following various "Dick's Clicks" pages. Here are the problems I'm still strugggling with: I am using my home computer running Excel 2003 and sending them to various users on a network that uses Outlook 2003 Web Apps running on Exchange Server 2003 and (strangley) using Excel 2000. I set up the late binding methods as per Dick's examples. When I try to Email the sheeet from a networked computer that has (Excel 2000), I get the following error: Run-Time error 91. Object variable With block variable not set. The debugger takes me to the line of code: Set olNS = olApp.GetNamespace("MAPI") Any suggestions? Thanks -- Dave Benson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Late Binding issues when closing workbooks | Excel Programming | |||
Late Binding examples of binding excel application | Excel Programming | |||
repost: need help trying to automate Outlook from XL, with late binding | Excel Programming | |||
Late Binding to Outlook from Excel: Outlook modifies email body | Excel Programming | |||
Creating a MailItem in Outlook from Excel using Late Binding | Excel Programming |