View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Benson Dave Benson is offline
external usenet poster
 
Posts: 6
Default 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