ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Late binding issues with Excel and Outlook (https://www.excelbanter.com/excel-programming/346639-late-binding-issues-excel-outlook.html)

Dave Benson

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