LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Late Binding issues when closing workbooks HeatherO Excel Programming 18 April 1st 05 06:04 PM
Late Binding examples of binding excel application HeatherO Excel Programming 13 March 17th 05 08:19 AM
repost: need help trying to automate Outlook from XL, with late binding KR Excel Programming 5 January 6th 05 03:20 PM
Late Binding to Outlook from Excel: Outlook modifies email body Lenny Wintfeld Excel Programming 0 December 12th 04 04:03 PM
Creating a MailItem in Outlook from Excel using Late Binding Steven Kelder Excel Programming 3 December 17th 03 05:34 PM


All times are GMT +1. The time now is 03:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"