D
Dave Benson
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
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