A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - General Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Access 2000 / Outlook 2007



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old September 17th 07, 07:18 PM posted to microsoft.public.access.modulesdaovba,microsoft.public.office.developer.outlook.vba,microsoft.public.office.developer.vba,microsoft.public.outlook
bh
external usenet poster
 
Posts: 3
Default Access 2000 / Outlook 2007

I'm trying to email from Access 2000 using the following:

Dim objOutlook As Outlook.Application
Dim objOutlookMsg As Outlook.MailItem
Dim objOutlookRecip As Outlook.Recipient
Dim objOutlookAttach As Outlook.Attachment

Set objOutlook = CreateObject("Outlook.Application")
Set objOutlookMsg = objOutlook.CreateItem(olMailItem)

With objOutlookMsg
Set objOutlookRecip = .Recipients.Add("Email addresses separated
by semicolons")
objOutlookRecip.Type = olTo
.Subject = "Whatever subject"
.Body = "Whatever message text"
For Each objOutlookRecip In .Recipients
objOutlookRecip.Resolve
Next
.Display
End With

Set objOutlook = Nothing
SendMessage = True

This process always worked fine with Outlook 2000 and then Outlook 2003;
however, in Outlook 2007, I get an Error 287 (Object definition error). I
was using Outlook Library 11.0, previously, but now some users are using
Outlook 2007 instead of '03. When I put the program on a machine with 2007,
however, the Library 12.0 is showing as referenced in my code-behind
(appearing to have grabbed automatically)... The machine I actually
developed the app on has Outlook 2003, and only some of the users will have
2007, and I manually had chosen the 11.0 library. Any ideas on how to
resolve this would be helpful.


Ads
 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to program to export certain Outlook 2000 messages to Access 2000 database Oscar Outlook and VBA 4 December 21st 06 06:43 PM
How do I Import tables from Access 2000 into Outlook 2000? The Big O Outlook - Using Contacts 7 November 21st 06 02:02 PM
Outlook 2003 can't access Exchange Server 2000 [email protected] Outlook - General Queries 0 October 16th 06 08:48 PM
Access denied to .pst folder - Outlook 2000 jon Outlook - Installation 1 July 24th 06 05:05 PM
Cannot Access Exchange Mailbox With Outlook 2000 Ray Lewis Outlook - General Queries 0 July 12th 06 03:27 PM


All times are GMT +1. The time now is 08:42 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2024 Outlook Banter.
The comments are property of their posters.