![]() |
Late binding issues with Excel and Outlook
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 |
All times are GMT +1. The time now is 12:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com